RE: Re[2]: [sqlite] To whom to inform on a bug?
> -Original Message- > From: Chris Schirlinger [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 14, 2006 8:45 PM > To: sqlite-users@sqlite.org > Subject: Re: Re[2]: [sqlite] To whom to inform on a bug? > > I tried the data you mentioned in SQLite Explorer and the SQL > statemen worked correctlyt: > > > select * from tResult where tex like '%ra%' > > returned the expected record perfectly > > Here is the output of the command line test > > SQLite version 3.3.3 > Enter ".help" for instructions > sqlite> .schema > CREATE TABLE tResult (id INTEGER,tex STRING); > sqlite> select * from tResult; > 3229|...Oracle... > sqlite> select * from tResult where tex like '%ra%'; > 3229|...Oracle... Perhaps the original poster is using a non-English version of Windows? Not sure if that makes a difference in this case. Robert
Re: Re[2]: [sqlite] To whom to inform on a bug?
I tried the data you mentioned in SQLite Explorer and the SQL statemen worked correctlyt: > select * from tResult where tex like '%ra%' returned the expected record perfectly Here is the output of the command line test SQLite version 3.3.3 Enter ".help" for instructions sqlite> .schema CREATE TABLE tResult (id INTEGER,tex STRING); sqlite> select * from tResult; 3229|...Oracle... sqlite> select * from tResult where tex like '%ra%'; 3229|...Oracle... > Script: > select * from tResult where tex like '%ra%' > result = 0 > > select tex from tResult where id = 3229 > tex = "...Oracle..." > > Soft on broblem: > sqlite3explorer, > and my soft
Re[2]: [sqlite] To whom to inform on a bug?
sorry :( >> version: >> 3.3.4 or 3.x >> >> System test: >> Win2003(NTFS) >> >> Script: >> select * from tResult where tex like '%ra%' >> result = 0 >> >> select tex from tResult where id = 3229 >> tex = "...Oracle..." >> >> Soft on broblem: >> sqlite3explorer, >> and my soft >> >> sample db: >> http://www.aidagw.com/files/dba.zip >> dhc> Thank you for the excellent information. dhc> Your query works correctly when run in the dhc> sqlite3 shell. Probably this is a bug in dhc> sqlite3explorer. dhc> -- dhc> D. Richard Hipp <[EMAIL PROTECTED]>
Re[2]: [sqlite] To whom to inform on a bug?
version: 3.3.4 or 3.x System test: Win2003(NTFS) Script: select * from tResult where tex like '%ra%' result = 0 select tex from tResult where id = 3229 tex = "...Oracle..." Soft on broblem: sqlite3explorer, and my soft sample db: http://www.aidagw.com/files/dba.zip dhc> http://www.sqlite.org/cvstrac/tktnew dhc> Hints: Unless you provide more information that you have dhc> shown above, your ticket will likely be ignored. The dhc> following kinds of information will help us to isolate dhc> and fix the problem: dhc>* What version of SQLite you are running. dhc>* What operating system you are using. dhc>* Did you build it yourself or used a precompiled dhc> binary. dhc>* What language bindings you are using. dhc>* The database schema. dhc>* The specific SQL statement that fails. dhc>* Can you reproduce the problem using the command-line dhc> shell or does it only appear in your program? dhc>* Include a reproducible script that demonstrates dhc> the problem. dhc>* If appropriate, attach a ZIP archive of your database dhc> file to the ticket. dhc> -- dhc> D. Richard Hipp <[EMAIL PROTECTED]>