RE: Re[2]: [sqlite] To whom to inform on a bug?

2006-02-14 Thread Robert Simpson
> -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?

2006-02-14 Thread Chris Schirlinger
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