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 to search for the answer to this
> question.
>
>
>
> Sample SQL:
>
> SELECT "SalesLine"."ROWID" AS "FQROWID", "Item"."FullName" AS "FQALIAS_1",
> "Ite
>
> m"."Type" AS "FQALIAS_2", "Customer"."CustomFieldLevel" AS "FQALIAS_3",
> "Custom
>
> er"."FullName" AS "FQALIAS_4", "SalesLine"."SalesLineDesc" AS "FQALIAS_5",
> "Sal
>
> esLine"."SalesLineItemRefFullName" AS "FQALIAS_6", "SalesLine"."TxnDate" AS
> "FQ
>
> ALIAS_7", "SalesLine"."SalesLineAmount" AS "FQALIAS_8", "SalesLine"."Type"
> AS "
>
> FQALIAS_9" FROM "SalesLine" "SalesLine" LEFT OUTER JOIN "Item" "Item" ON
> "Item"
>
> ."ListID" = "SalesLine"."SalesLineItemRefListID" LEFT OUTER JOIN "Customer"
> "Cu
>
> stomer" ON "Customer"."ListID" = "SalesLine"."CustomerRefListID" WHERE
> ((("Sale
>
> sLine"."TxnDate" >= '2006-01-01') AND ("SalesLine"."TxnDate" <=
> '2006-09-30'))
>
> AND (("Item"."Type" = 'ItemInventory') AND (("Customer"."FullName" =
> 'Amazon.co
>
> m.ksdc, Inc. - Campbellsville') OR (("Customer"."FullName" =
> 'Amazon.com.ksdc,
>
> Inc. - Coffeyville') OR (("Customer"."FullName" = 'Amazon.com.ksdc, Inc. -
> Fern
>
> ley') OR (("Customer"."FullName" = 'Arizona Select') OR
> (("Customer"."FullName"
>
> = 'ATW - Cobb Dist.') OR (("Customer"."FullName" = 'SunOpta Food
> Distribution
>
> Group') OR (("Customer"."FullName" = 'Callaway Consumer Products, LLC') OR
> (("C
>
> ustomer"."FullName" = 'Cedarlane Natural Foods') OR (("Customer"."FullName"
> = '
>
> City Glatt, Inc.') OR (("Customer"."FullName" = 'Columbus Distributing,
> Inc.')
>
> OR (("Customer"."FullName" = 'Cost Plus World Markets-West') OR
> (("Customer"."F
>
> ullName" = 'DeKalb Farmers Market') OR (("Customer"."FullName" =
> 'DPI-Midwest')
>
> OR (("Customer"."FullName" = 'DPI-Northwest') OR (("Customer"."FullName" =
> 'DP
>
> I-Rocky Mountain') OR (("Customer"."FullName" = 'DPI-West') OR
> (("Customer"."Fu
>
> llName" = 'Exel Pak') OR (("Customer"."FullName" = 'Falcon Trading Co.') OR
> (("
>
> Customer"."FullName" = 'Foodguys') OR (("Customer"."FullName" = 'Foodology')
> OR
>
> (("Customer"."FullName" = 'Gourmet Awards - Milwaukee') OR
> (("Customer"."FullN
>
> ame" = 'Kehe Foods') OR (("Customer"."FullName" = 'Marc Popcorn Company') OR
> ((
>
> "Customer"."FullName" = 'Marukai Markets') OR (("Customer"."FullName" =
> 'Matsuk
>
> as Food Company') OR (("Customer"."FullName" = 'McCain Foods USA, Inc.') OR
> (("
>
> Customer"."FullName" = 'Okami') OR ("Customer"."FullName" = 'Quickspice,
> Inc.')
>
> )))))))))))))))))))))))))))))
>
____________________________________________________________________________________
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
