diff options
| author | unknown <monty@donna.mysql.fi> | 2001-04-10 11:32:28 +0300 |
|---|---|---|
| committer | unknown <monty@donna.mysql.fi> | 2001-04-10 11:32:28 +0300 |
| commit | 92de72694b78d41980c48b8a6fedf10f153bb56e (patch) | |
| tree | 95bbcccc6e046548f22eead9222fdd1cce980d1e /mysql-test/r/null_key.result | |
| parent | c7105d8008aa42e90e830ede25e7cbf0c22893c0 (diff) | |
| download | mariadb-git-92de72694b78d41980c48b8a6fedf10f153bb56e.tar.gz | |
Fixed bug with UPDATE/DELETE on UNIQUE key which could be NULL
Docs/manual.texi:
Updated replication section
mysql-test/r/null_key.result:
Added test UPDATE/DELETE with IS NULL on unique key
mysql-test/t/null_key.test:
Added test UPDATE/DELETE with IS NULL on unique key
mysys/Makefile.am:
Removed -f from $CP as this is not portable
Fixed rule for testhash
sql/field.cc:
Safety fix
sql/opt_range.cc:
Fixed bug with UPDATE/DELETE on UNIQUE key which could be NULL
sql/opt_range.h:
Fixed bug with UPDATE/DELETE on UNIQUE key which could be NULL
Diffstat (limited to 'mysql-test/r/null_key.result')
| -rw-r--r-- | mysql-test/r/null_key.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/null_key.result b/mysql-test/r/null_key.result index 98c43b20b01..ead1dc29326 100644 --- a/mysql-test/r/null_key.result +++ b/mysql-test/r/null_key.result @@ -92,3 +92,31 @@ NULL 9 0 NULL 9 0 a b c 6 6 0 +table type possible_keys key key_len ref rows Extra +t1 ref idx1 idx1 5 const 1 where used +table type possible_keys key key_len ref rows Extra +t1 const idx1 idx1 5 const 1 +id +101 +102 +105 +106 +109 +110 +id +101 +102 +105 +106 +109 +110 +id uniq_id +3 1 +4 2 +7 3 +8 4 +id uniq_id +3 1 +4 2 +7 3 +8 4 |