List:General Discussion« Previous MessageNext Message »
From:Chris Bolt Date:June 16 2001 2:47am
Subject:RE: I think this is a bug for sure...
View as plain text  
> 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>

Thread
I think this is a bug for sure...Simon Shapiro16 Jun
  • RE: I think this is a bug for sure...Chris Bolt16 Jun
    • Re: I think this is a bug for sure...Simon Shapiro16 Jun