[V4RB2] Different results for search between Valentina and MySQL

[Ruslan Zasukhin]

On 4/8/05 10:42 AM, "Ivan Smahin" <IvanSmahin at public.kherson.ua> wrote:

>>> I am able to run a search that yields different results in Valentina and
>>> MySQL, and I don't know which one is doing it correctly (although I think
>>> it's MySQL).
>>> 
>>> If I have the zip codes 10597 and 10579, MySQL will find both if I use fld
>>> LIKE '105%9%' and Valentina will find only 10579 if I use fld.FindLike(
>>> "105%9%" ).
>>> 
>>> Is this a bug in Valentina, MySQL, or just different implementations of SQL?
> 
> RZ> Ivan,
> 
> RZ> Please check this issue and inform us.
> RZ> Test it also on MS and Sybase.
> 
> 
> MS test:
> ----------
> create table likeTest ( f1 char(20))
> insert into likeTest values ( '10597')
> insert into likeTest values ( '10579')
> 
> select * from likeTest where f1 LIKE '105%9%'
> Result: BOTH values selected in the result.
> 
> select * from likeTest where f1 LIKE '105%9'
> Result: '10579' value selected in the result.
> 
> Valentina SQL:
> --------------
> The same test for Valentina gets THE SAME result!!!

Kem,

I also have check above 4 SQL commands in viSQL.
And get correct result as MS and mySQL.

So please test all again.

We cannot reproduce your report.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]