Martin Jenkins <[EMAIL PROTECTED]> wrote:
>
> I think you said that you generate the queries? If so, do you have to
> nest so many nested ORs? I'm no SQL expert but
>
> AND ( Customer.FullName in (
> 'Amazon.com.ksdc, Inc. - Campbellsville',
[...]
> 'Okami2',
>
"Matt Froncek" <[EMAIL PROTECTED]> wrote:
> I have a program generator that creates ORs in SQL nested. This causes a
> stack overflow in SQLite. Has this been addressed or will it be?
SQLite uses a push-down automaton to parse the input SQL.
(See http://en.wikipedia.org/wiki/Pushdown_automaton)
Matt Froncek wrote:
Martin,
Thank you for looking into this. The SQLite3.exe I tested with was 3.1.3.
And yes the SQL statement works fine as it. If you add one more nested OR to
the SQL statement then it stops working. I don't get a stack overflow like I
do in the ODBC driver I was testing
DBC Driver for QuickBooks - Unleash your data at www.qodbc.com
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2007 10:19 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Nested Parens Stack Overflow
Matt Froncek wrote:
> I have a prog
Can you post the schema of the tables in the SELECT?
--- Matt Froncek <[EMAIL PROTECTED]> wrote:
> I have a program generator that creates ORs in SQL nested. This causes a
> stack overflow in SQLite. Has this been addressed or will it be? If so what
> version was it addressed. I am not sure how
I have a program generator that creates ORs in SQL nested. This causes a
stack overflow in SQLite. Has this been addressed or will it be? If so what
version was it addressed. I am not sure how to search for the answer to this
question.
Sample SQL:
SELECT "SalesLine"."ROWID" AS "FQROWID",
6 matches
Mail list logo