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