min() bug

[Artem V. Ryabov]

Hello bugs,

min return not value from table.

mysql> select min(ord) from cSectText where SectID=932;
+---------------------+
| min(ord)            |
+---------------------+
| -200204120000051744 |
+---------------------+
1 row in set (0.00 sec)

mysql> select ord from cSectText where SectID=932 order by ord limit 10;
+---------------------+
| ord                 |
+---------------------+
| -200204120000051754 |
| -200204120000051752 |
| -200204120000051750 |
| -200204120000051748 |
| -200204120000051746 |
| -200204120000051744 |
| -200204120000051742 |
| -200204120000051740 |
| -200204120000051738 |
| -200204120000051730 |
+---------------------+
10 rows in set (0.00 sec)

mysql> select ord from cSectText where SectID=1 order by ord limit 10;
+---------------------+
| ord                 |
+---------------------+
| -200204120000051794 |
| -200204120000051754 |
| -200204120000051752 |
| -200204120000051750 |
| -200204120000051748 |
| -200204120000051746 |
| -200204120000051744 |
| -200204120000051742 |
| -200204120000051740 |
| -200204120000051738 |
+---------------------+
10 rows in set (0.00 sec)

mysql> select min(ord) from cSectText where SectID=1;
+---------------------+
| min(ord)            |
+---------------------+
| -200204120000051808 |
+---------------------+
1 row in set (0.00 sec)

mysql> select * from cSectText where ord=-200204120000051808 and SectID=1;
Empty set (0.00 sec)

mysql> show create table cSectText;
| cSectText | CREATE TABLE `cSectText` (
  `SectID` int(11) NOT NULL default '0',
  `ID` int(11) NOT NULL default '0',
  `Date` date NOT NULL default '0000-00-00',
  `ord` bigint(17) NOT NULL default '0',
  PRIMARY KEY  (`ID`,`SectID`),
  UNIQUE KEY `d` (`SectID`,`ord`),
  UNIQUE KEY `a` (`SectID`,`Date`,`ID`)
) TYPE=MyISAM COMMENT='ΣΣΣ' |
1 row in set (0.00 sec)
mysql> show variables like 'version';
+---------------+----------------+
| Variable_name | Value          |
+---------------+----------------+
| version       | 3.23.49yes-log |
+---------------+----------------+
1 row in set (0.00 sec)


-- 
Best regards,
 Artem                          mailto:[EMAIL PROTECTED]


---------------------------------------------------------------------
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