diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-10-31 01:13:12 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-10-31 01:13:12 -0700 |
| commit | 3a7169572ce4759724d8532191c8e8a10cff3a7f (patch) | |
| tree | fb6e5852eaec6040099dc84499f2324d95cdfa50 /mysql-test/r/myisam_icp.result | |
| parent | 7dd42686fea5620c11865f57a955aabc08375e5a (diff) | |
| download | mariadb-git-3a7169572ce4759724d8532191c8e8a10cff3a7f.tar.gz | |
Backported the test case for bug 59843 from the mysql-5.6 code line.
(Failed to reproduce the bug in mariadb-5.3).
Diffstat (limited to 'mysql-test/r/myisam_icp.result')
| -rw-r--r-- | mysql-test/r/myisam_icp.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/myisam_icp.result b/mysql-test/r/myisam_icp.result index 5e33fee7d02..8b560b06fa4 100644 --- a/mysql-test/r/myisam_icp.result +++ b/mysql-test/r/myisam_icp.result @@ -562,6 +562,23 @@ pk i1 c1 i2 INSERT INTO t1 (i2) VALUES (1); DROP TABLE t1; # +# Bug #11766678 - 59843: +# USING UNINITIALISED VALUE IN USES_INDEX_FIELDS_ONLY +# +CREATE TABLE t1 ( +col999 FLOAT NOT NULL, +COL1000 VARBINARY(179) NOT NULL, +col1003 DATE DEFAULT NULL, +KEY idx4267 (col1000, col1003) +); +INSERT INTO t1 VALUES (),(); +Warnings: +Warning 1364 Field 'col999' doesn't have a default value +Warning 1364 Field 'COL1000' doesn't have a default value +SELECT col999 FROM t1 WHERE col1000 = "3" AND col1003 <=> sysdate(); +col999 +DROP TABLE t1; +# # BUG#778434 Wrong result with in_to_exists=on in maria-5.3-mwl89 # CREATE TABLE t1 ( f11 int) ; |