Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

rrule functions in where clause #10

Open
Falmarri opened this issue May 9, 2016 · 2 comments
Open

rrule functions in where clause #10

Falmarri opened this issue May 9, 2016 · 2 comments

Comments

@Falmarri
Copy link

Falmarri commented May 9, 2016

Are the various rrule functions not supported in where clauses?

running select id, rrule from test where get_freq(rrule) = 'WEEKLY';

testdb-# \d test
 id     | bigint | not null default nextval('test_id_seq'::regclass)
 rrule  | rrule  | 

segfaults with this:

May 09 16:31:43 opal systemd-coredump[18790]: Process 18491 (postgres) of user 88 dumped core.

    Stack trace of thread 18491:
    #0  0x00007f3b0f3b4646 strlen (libc.so.6)
    #1  0x00007f3b04990b66 icalmemory_append_string (libical.so.2)
    #2  0x00007f3b04999854 icalrecurrencetype_as_string_r (libical.so.2)
    #3  0x00007f3b04999c16 icalrecurrencetype_as_string (libical.so.2)
    #4  0x00007f3b04bd127f pg_rrule_out (pg_rrule.so)
    #5  0x000000000079be48 FunctionCall1Coll (postgres)
    #6  0x000000000079d2ee OutputFunctionCall (postgres)
    #7  0x0000000000471661 n/a (postgres)
    #8  0x00000000005ac369 standard_ExecutorRun (postgres)
    #9  0x00000000006aac50 n/a (postgres)
    #10 0x00000000006ac04e PortalRun (postgres)
    #11 0x00000000006a8f93 PostgresMain (postgres)
    #12 0x0000000000467c64 n/a (postgres)
    #13 0x00000000006529ef PostmasterMain (postgres)
    #14 0x0000000000468e04 main (postgres)
    #15 0x00007f3b0f356710 __libc_start_main (libc.so.6)
    #16 0x0000000000468e79 _start (postgres)


@Falmarri
Copy link
Author

Falmarri commented May 9, 2016

Actually, it seems like something's wrong with just converting the ical to string.
select * from test throws the same segfault

@petropavel13
Copy link
Owner

I see you found the issue: Falmarri@2b5ea09
Let's create pull request and specify minimum required version of libical in readme

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants