[sqlite] Lemon-generated parser gives an assertion failure

The test case can be simplified to: bug.lemon: --- %include { #include #include #include #include "bug.h" } %code { int main(void) { void *pParser; pParser = ParseAlloc(malloc); if (!pParser) { printf("out of memory\n"); exit(1);

Re: [sqlite] Lemon-generated parser gives an assertion failure

On 4/25/17, Kelvin Sherlock wrote: > > I believe the issue is line 4164 which should be … = LEMON_TRUE. Currently, > when i=0, all rules will erroneously be optimized out. > > 4157/* Mark rules that are actually used for reduce actions after all > 4158**

[sqlite] RTree and foreign keys

Try as I might, I can't seem to get RTrees and foreign keys to play nicely with each other. With a little digging it looks like this is a general issue with the virtual nature of virtual tables in general. Are foreign keys at all possible with virtual tables like this? And if so, might it be a

Re: [sqlite] RTree and foreign keys

On 4/25/17, David Raymond wrote: > > Are foreign keys at all possible with virtual tables like this? > Foreign key constraints are possible on virtual tables, but it is up to the various virtual table implementations to implement them, and R-Tree does not. -- D.

Re: [sqlite] Performances and Foreign keys

Ok, I'll test with and without FKs. As you said, since one can turn them on and off, maybe there is something to do there. Thanks for your answer 2017-04-24 14:52 GMT+02:00 Dominique Devienne : > On Mon, Apr 24, 2017 at 2:31 PM, Bubu Bubu wrote: > > >

[sqlite] Build error in SQLite 3.18 if SQLITE_UNTESTABLE is defined

Hello, shell.c fails to build with: shell.c: In function 'do_meta_command': shell.c:6442:50: error: 'sql_trace_callback' undeclared (first use in this function) sqlite3_trace_v2(p->db, SQLITE_TRACE_STMT, sql_trace_callback,p->traceOut); ^

[sqlite] SQLITE AIX Driver

Team, I would like to know whether do we have a sqlite ODBC driver for AIX which has level 2 or above. We like to use the driver to connect the sqlite through Informatica. I have searched across the net but I don't fine one for AIX. I appreciates your reply. Thanks & Regards Rathnakumar P

Re: [sqlite] Performances and Foreign keys

All of your feedbacks are really insightful, I deeply thank you guys, I'm meeting with my boss later with all that stuff to discuss about. Great community and thanks again 2017-04-24 18:58 GMT+02:00 David Raymond : > Another situational space/speed helper I found for

Re: [sqlite] Build error in SQLite 3.18 if SQLITE_UNTESTABLE is defined

I'm curious: Why do you want to make SQLite untestable? On 4/24/17, Priebe, Sebastian wrote: > Hello, > > shell.c fails to build with: > shell.c: In function 'do_meta_command': > shell.c:6442:50: error: 'sql_trace_callback' undeclared (first use in this > function) >

Re: [sqlite] SQLITE AIX Driver

AIX is an obscure platform these days. Probably you will need to get the source code to an ODBC driver and compile it yourself. On 4/24/17, Periasamy, Rathnakumar (Larsen & Toubro Infotech Ltd.) wrote: > Team, > > I would like to know whether do we have

Re: [sqlite] 0x11C: automatic index warning for CTEs ?

Howard Kapustein wrote: >> you might have to change the query itself > > The question is how? The database has estimated that even with the cost of creating the temporary index, this way is the fastest. So it's unlikely that there is another way that would be an improvement. Anyway, try using