List:General Discussion« Previous MessageNext Message »
From:Przemyslaw Popielarski Date:November 16 2004 11:28pm
Subject:Re: 4.1.7: bug in FT search (ORDER BY used, results NOT sorted)
View as plain text  
> SELECT TYTUL FROM tKsidata
> WHERE MATCH (TYTUL) AGAINST ("space")
> ORDER BY TYTUL
>
> TYTUL
> Shaping Space 2ed
> National Air & Space Museum
> Light & Space
> Free Space Architecture
> Does Economics Space Matter ?
> Economies of Signs & Space
> Industry Space & Competition Contribution of Economists of P
> Money & Space Economy
> Improving Performance How to Manage White Space on Organisat
> State Space Modeling of Time Series
> Biogeography Introduction to Space Time and Life
> Cognition of Geographic Space
> (and so on)
>
> Already done optimize table, analyze table. Table is MyISAM, MySQL
> 4.1.7 Linux x86 standard-binary.
>
> Any ideas?  This worked in 4.0 perfectly!

One of the users of this list pointed me, that I didn't tell you that here
is the problem with proper sorting. So I'm telling you, that it is :-)
Also, it's worth to mention, that I have latin2 charset set in host, db, all
tables and in connection settings.

-- 
./ premax
./ premax@stripped
./ koniec i bomba, a kto czytal ten traba. w.g.

Thread
Re: 4.1.7: bug in FT search (ORDER BY used, results NOT sorted)Przemyslaw Popielarski17 Nov