Hi Richard, Our longest select so far this one:
select * from log where ((aut not like '6%' and aut not like '-1%') or (avm not like '6%' and avm not like '-1%') or (lam not like '6%' and lam not like '-1%') or (pam not like '6%' and pam not like '-1%') or (pas not like '6%' and pas not like '-1%') or (clc not like '6%' and clc not like '-1%') or (fro not like '6%' and fro not like '-1%') or (spw_ifr not like '6%' and spw_ifr not like '-1%') or (spw_dem not like '6%' and spw_dem not like '-1%') or (sp_reg not like '6%' and sp_reg not like '-1%') or (uni_10 not like '6%' and uni_10 not like '-1%') or (aut_dem not like '6%' and aut_dem not like '-1%') or (uni_11 not like '6%' and uni_11 not like '-1%')) order by system, id This returns 29 columns. I claim no credit for such a rotten data model that requires a query like this -- it was converted from a spreadsheet. In another app we have an insert into that inserts 60 columns. The query is generated by a program so I can't just copy it for you, but I can provide it if will help. HTH, Stephen Toney Systems Planning [EMAIL PROTECTED] http://www.systemsplanning.com On Wed, 2007-05-09 at 23:32 +0000, [EMAIL PROTECTED] wrote: > I'm looking for an upper bound on how big legitimate > SQL statements handed to SQLite get to be. I'm not > interested in contrived examples. I want to see > really big SQL statements that are actually used in > real programs. > > "Big" can be defined in several ways: > > * Number of bytes of text in the SQL statement. > * Number of tokens in the SQL statement > * Number of result columns in a SELECT > * Number of terms in an expression > > If you are using really big SQL statements, please > tell me about them. I'd like to see the actual > SQL text if possible. But if your use is proprietary, > please at least tell me how big your query is in > bytes or tokens or columns or expression terms. > > Thanks. > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- -- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
