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





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

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

2006-02-14 Thread Kirill
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]>