Chris Bolt wrote:
>>Assuming any SQL statement that causes the mysqld to go away is a bug:
>>
>>Assume table foo has a column bar bigint(20);
>>
>>select * from foo where bar = 0x7fffffffffffffff;
>>
>>The above works fine. The below crashes the server:
>>
>>select * from foo where bar = 9223372036854775807;
>>
>>They are equivalent.
>>
>
>What version are you using?
>
3.23.38
>
>
>mysql> create table foo (id int(11) auto_increment, bar bigint(20) default
>'0', primary key(id));
>Query OK, 0 rows affected (0.06 sec)
>
>mysql> insert into foo (bar) values (9223372036854775807);
>Query OK, 1 row affected (0.03 sec)
>
>mysql> insert into foo (bar) values (9223372036854775806);
>Query OK, 1 row affected (0.00 sec)
>
>mysql> select * from foo where bar = 0x7fffffffffffffff;
>+----+---------------------+
>| id | bar |
>+----+---------------------+
>| 1 | 9223372036854775807 |
>+----+---------------------+
>1 row in set (0.02 sec)
>
>mysql> select * from foo where bar = 9223372036854775807;
>+----+---------------------+
>| id | bar |
>+----+---------------------+
>| 1 | 9223372036854775807 |
>+----+---------------------+
>1 row in set (0.00 sec)
>
>mysql> select version();
>+-----------+
>| version() |
>+-----------+
>| 3.23.32 |
>+-----------+
>1 row in set (0.00 sec)
>
>mysql>
>
>
>---------------------------------------------------------------------
>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
>
--
Sincerely Yours, [EMAIL PROTECTED]
770.265.0958
Simon Shapiro
Unwritten code has no bugs and executes at twice the speed of mouth
---------------------------------------------------------------------
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