diff options
author | unknown <jimw@mysql.com> | 2005-11-07 14:59:52 -0800 |
---|---|---|
committer | unknown <jimw@mysql.com> | 2005-11-07 14:59:52 -0800 |
commit | 73e4a7788679effd0908e1d27ad15c52f5cbaca3 (patch) | |
tree | 0965829dc50e47eeeb6a0f614da6554fc32ea05a /mysql-test/r/func_equal.result | |
parent | 0e878d7e541983757bc0b31e7caa8a16a5fd2896 (diff) | |
download | mariadb-git-73e4a7788679effd0908e1d27ad15c52f5cbaca3.tar.gz |
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.
Diffstat (limited to 'mysql-test/r/func_equal.result')
-rw-r--r-- | mysql-test/r/func_equal.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/func_equal.result b/mysql-test/r/func_equal.result index 352b76f2744..98838c80861 100644 --- a/mysql-test/r/func_equal.result +++ b/mysql-test/r/func_equal.result @@ -27,3 +27,12 @@ id value select * from t1 where id <=> value or value<=>id; id value drop table t1,t2; +create table t1 (a bigint unsigned); +insert into t1 values (4828532208463511553); +select * from t1 where a = '4828532208463511553'; +a +4828532208463511553 +select * from t1 where a in ('4828532208463511553'); +a +4828532208463511553 +drop table t1; |