pilerexport where_condition query length limitation

2021-05-03 Thread Ryan Blenis
Hi Janos, Running some queries with pilerexport -w and it seems I'm running up against a wall with longer queries (the newly logged "pilerexport" sphinx query in the mail.log cuts off the query at about ~510 characters) which causes the query to fail and the following SQL just starts spewing

Re: pilerexport where_condition query length limitation

2021-05-03 Thread Ryan Blenis
Follow up for anyone needing this in the future: It looks like you can safely change ~line 159 of pilerexport.c (in the run_query function) from: char s[SMALLBUFSIZE]; to char s[MAXBUFSIZE]; to get a longer SQL query with pilerexport (from 512 to 8192 characters) But there should still probably

Re: pilerexport where_condition query length limitation

2021-05-03 Thread sj
Hello Ryan, I've updated pilerexport.c to have the increased buffer size, also print the sphinx query to see what's going on with this commit: https://bitbucket.org/jsuto/piler/commits/66a8f60d9d1ced70fe46d6e76041989e7b779f0f Janos On 2021-05-04 02:39, Ryan Blenis wrote: Follow up for