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.')
)))))))))))))))))))))))))))))
Thanks,
Matt Froncek
QODBC Development Support / FLEXquarters.com LLC Consultant
QODBC Driver for QuickBooks - Unleash your data at <http://www.qodbc.com/>
www.qodbc.com
