[V4RB] SQL bug

[Ruslan Zasukhin]

on 12/12/03 3:49 PM, jda at jda at his.com wrote:

> Hi Ruslan,
> 
> 
> This used to work, but somewhere along the line is seems to have broken:
> 
> I have a method (allFields) that returns a concatenation of all the
> fields in my database, separated by a space. If all fields are empty,
> it returns 15 spaces.
> 
> To search for any record in which all fields are empty, I use the
> following statement:
> 
>     select id,hit from references where allFields='               '
> // that's 15 spaces
> 
> This used to work, but in 1.10b21 (and 1.9.8) fails.
> 
> However, this statement works:
> 
>     select id,hit from references where allFields LIKE '
> ' // that's 15 spaces
> 
> So there is an easy workaround, but if = is broken here it might mean
> there are other problems I just haven't run across yet.

Way to reproduce?

Looks to be again bug in TEXT method + index.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------