From 73e4a7788679effd0908e1d27ad15c52f5cbaca3 Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 7 Nov 2005 14:59:52 -0800 Subject: Fix handling of comparisons done by IN() to be consistent with how they are done for the = operator, such as when doing a comparison with a large unsigned number that was quoted. (Bug #12612) mysql-test/r/func_equal.result: Add new results mysql-test/t/func_equal.test: Add new test sql/item_cmpfunc.cc: Handle FIELD_ITEM that can be compared as a longlong in agg_cmp_type() instead of in each of the places it is called. --- mysql-test/t/func_equal.test | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'mysql-test/t/func_equal.test') diff --git a/mysql-test/t/func_equal.test b/mysql-test/t/func_equal.test index 18d34e3ba16..382bde43647 100644 --- a/mysql-test/t/func_equal.test +++ b/mysql-test/t/func_equal.test @@ -32,4 +32,13 @@ select * from t1 where value <=> value; select * from t1 where id <=> value or value<=>id; drop table t1,t2; +# +# Bug #12612: quoted bigint unsigned value and the use of "in" in where clause +# +create table t1 (a bigint unsigned); +insert into t1 values (4828532208463511553); +select * from t1 where a = '4828532208463511553'; +select * from t1 where a in ('4828532208463511553'); +drop table t1; + # End of 4.1 tests -- cgit v1.2.1