diff options
| author | unknown <evgen@moonbone.local> | 2006-06-20 23:05:55 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2006-06-20 23:05:55 +0400 |
| commit | 3e7d68b11cd65dac087e2a634a8f007a295c6528 (patch) | |
| tree | a57765ed6fcc2dd2957cb73bff76c3ac8b851454 /mysql-test/r/select.result | |
| parent | 846c46ea4d916cf3adfacdee67bf5d0a191e07b5 (diff) | |
| download | mariadb-git-3e7d68b11cd65dac087e2a634a8f007a295c6528.tar.gz | |
select.result:
Added test case for bug#18759 Incorrect string to numeric conversion.
select.test:
Added test case for bug#18759 Incorrect string to numeric conversion.
item_cmpfunc.cc:
Cleanup after fix for bug#18360 removal
sql/item_cmpfunc.cc:
Cleanup after fix for bug#18360 removal
mysql-test/t/select.test:
Added test case for bug#18759 Incorrect string to numeric conversion.
mysql-test/r/select.result:
Added test case for bug#18759 Incorrect string to numeric conversion.
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 7808e787e39..c7df11ab018 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2738,3 +2738,9 @@ ERROR HY000: Key 'a' doesn't exist in table 't1' EXPLAIN SELECT * FROM t1 FORCE INDEX (a); ERROR HY000: Key 'a' doesn't exist in table 't1' DROP TABLE t1; +CREATE TABLE t1 (i BIGINT UNSIGNED NOT NULL); +INSERT INTO t1 VALUES (10); +SELECT i='1e+01',i=1e+01, i in (1e+01), i in ('1e+01') FROM t1; +i='1e+01' i=1e+01 i in (1e+01) i in ('1e+01') +0 1 1 1 +DROP TABLE t1; |