Hello list, I've found this strange select bug in retrieving rows from a table. I can best illustrate this with an output of two queries:
mysql> select id,jn from paper_2001 limit 10; +----------+-------+ | id | jn | +----------+-------+ | 19360350 | 6165 | | 19360351 | 6165 | | 19360352 | 6165 | | 19360353 | 6165 | | 19360354 | 12030 | | 19360355 | 12030 | | 19360356 | 12030 | | 19360357 | 12030 | | 19360358 | 12030 | | 19360359 | 12030 | +----------+-------+ 10 rows in set (0.01 sec) That's ok. But now: mysql> select jn from paper_2001 limit 10; +----+ | jn | +----+ | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | +----+ 10 rows in set (0.00 sec) Odd, eh? But what's worse, the JOIN between this column and other columns *also* uses this truncated values and the result is bogus. The definition of this table is: CREATE TABLE `paper_2001` ( `id` int(10) NOT NULL default '0', `jn` int(10) NOT NULL default '0', `dt` smallint(5) NOT NULL default '0', `la` smallint(5) NOT NULL default '0', `isiprod` char(3) NOT NULL default '', `year` year(4) NOT NULL default '0000', `cdyear` year(4) NOT NULL default '0000', `volume` varchar(5) NOT NULL default '', `issue` varchar(5) NOT NULL default '', `fpage` varchar(5) NOT NULL default '', `lpage` varchar(5) NOT NULL default '', `gacode` varchar(6) NOT NULL default '', `matchkey` varchar(20) NOT NULL default '', `ed` varchar(20) NOT NULL default '', `cf` varchar(20) NOT NULL default '', `sl` varchar(20) NOT NULL default '', `sc` varchar(20) NOT NULL default '', `ar` varchar(20) NOT NULL default '', `ld` varchar(20) NOT NULL default '', `ut` varchar(20) NOT NULL default '', PRIMARY KEY (`id`), KEY `jn` (`jn`), KEY `matchkey` (`matchkey`), KEY `ut` (`ut`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | The version of the client and the database I'm using is: mysql> \s -------------- mysql Ver 14.12 Distrib 5.0.21, for pc-linux-gnu (i686) using readline 5.1 Connection id: 12 Current database: wos_0506 Current user: [EMAIL PROTECTED] SSL: Not in use Current pager: /usr/bin/less Using outfile: '' Using delimiter: ; Server version: 5.0.21 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 14 min 12 sec -------------- (you see, I've even restarted the thing) I'm currently compiling 5.0.24, but I'm not sure if this fixes the problem... Regards, Renald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]