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 = 0x7fff;
>>
>>The above works fine. The below crashes the server:
>>
>>select * from foo where bar = 922337
> 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 = 0x7fff;
>
> The above works fine. The below crashes the server:
>
> select * from foo where bar = 9223372036854775807;
>
> They
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 = 0x7fff;
The above works fine. The below crashes the server:
select * from foo where bar = 9223372036854775807;
They are equivalent.