Fournier Jocelyn [Presence-PC] writes: > Hi, > > I have the latest 4.0.2 source installed, and the problem is still here > AFAIK : > > mysql> \s > -------------- > mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) > > -=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch > <(13:29:52) > # This is a BitKeeper generated patch for the following project: > # Project Name: MySQL - fast and reliable SQL database > # This patch format is intended for GNU patch command version 2.5 or higher. > # This patch includes the following deltas: > # ChangeSet 1.1235 -> 1.1236 > # Docs/manual.texi 1.865 -> 1.866 > # > # The following is the BitKeeper ChangeSet Log > # -------------------------------------------- > # 02/04/15 [EMAIL PROTECTED] 1.1236 > # Documentation fix. > # -------------------------------------------- > > mysql> SELECT DISTINCT topic FROM > forum.searchmainpresencepc4,forum.searchjoinpresencepc4 WHERE > searchmainpresencepc4.numreponse=searchjoinpresencepc4.numreponse AND > (mot='les') ORDER BY date DESC LIMIT 0,40; > +-------+ > | topic | > +-------+ > | 11462 | > <cut> > | 12313 | > | 9673 | > | 11462 | > <cut> > | 12282 | > | 9673 | > | 12224 | > +-------+ > 40 rows in set (0.06 sec) > > > BTW I have a problem with the latest mysql client (12.1) : > > It seems to be locked when I make a 'use database' : > > > mysql> use forum > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > <locked> > > Regards, > > Jocelyn
Hi! Can you upload a gzipped dump of your table, so that we could check the above ?? -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php