Re: [sqlite] Odd problem with select on large table

2008-03-08 Thread BareFeet
Hi James, > / > sqlite3 test.db `select name from PerfTest1 where name = > "key5000"' > > does work. I know this because if I query for "key500" I get back > that row. It may work, but it's still wrong ;-) You should use single quotes for literals, which is correct SQL syntax. SQLite

Re: [sqlite] Odd problem with select on large table

2008-03-07 Thread John Stanton
For SQL it needs to be 'key5000' not "key3000". James Kimble wrote: > On the command line: > > / > sqlite3 test.db `select name from PerfTest1 where name = "key5000"' > > does work. I know this because if I query for "key500" I get back that > row. It's not blanks either because if I > do: >

Re: [sqlite] Odd problem with select on large table

2008-03-07 Thread Dennis Cote
James Kimble wrote: > It's not blanks either because if I > do: > > where name link "key1%" > > I only get rows prior to "key199". James can you try this to check the names? select ':' || name || ':' from PerfTest1 where length(name) != length(trim(name)); It should display

Re: [sqlite] Odd problem with select on large table

2008-03-07 Thread James Kimble
On the command line: / > sqlite3 test.db `select name from PerfTest1 where name = "key5000"' does work. I know this because if I query for "key500" I get back that row. It's not blanks either because if I do: where name link "key1%" I only get rows prior to "key199". Very weird. I did

Re: [sqlite] Odd problem with select on large table

2008-03-07 Thread John Stanton
An SQL literal uses single quotes [EMAIL PROTECTED] wrote: > I created a 40 column table with 10,000 rows as a test database > for a reader and a writer process to bang on (performance proof). > > The table is as so: > > sqlite3 test.db 'create table PerfTest1 (name varchar(20), value1 int, >

Re: [sqlite] Odd problem with select on large table

2008-03-07 Thread Kees Nuyt
On Fri, 7 Mar 2008 14:34:53 -0500 (EST), you wrote: > sqlite3 test.db `select name from PerfTest1 where name = "key5000"' In SQL, a string should be delimited with single quotes, not double quotes. Try: sqlite3 test.db "select name from PerfTest1 where name = 'key5000' " or echo "select name

Re: [sqlite] Odd problem with select on large table

2008-03-07 Thread Gerry Snyder
[EMAIL PROTECTED] wrote: > > What's driving me mad is that when I do a select from the command line > like so: > > sqlite3 test.db `select name from PerfTest1 where name = "key5000"' > > 0 rows are returned. However if I do a simple: > > sqlite3 test.db 'select name from PerfTest1' > > and just

[sqlite] Odd problem with select on large table

2008-03-07 Thread jkimble
I created a 40 column table with 10,000 rows as a test database for a reader and a writer process to bang on (performance proof). The table is as so: sqlite3 test.db 'create table PerfTest1 (name varchar(20), value1 int, value2 int, value3 int, value4 int, value5 int, value6 int, value7 int,