diff options
| author | Elena Stepanova <elenst@ubuntu11.home> | 2013-02-03 02:53:57 +0400 |
|---|---|---|
| committer | Elena Stepanova <elenst@ubuntu11.home> | 2013-02-03 02:53:57 +0400 |
| commit | 7f444caa0ad6b2eddc730de3cd9c94bfb9037b51 (patch) | |
| tree | 2ce4331394ace7fff468791666e8f03286720990 /mysql-test/suite/storage_engine/update_with_keys.test | |
| parent | 1701ee335740c970696fab081cfeac582991076d (diff) | |
| download | mariadb-git-7f444caa0ad6b2eddc730de3cd9c94bfb9037b51.tar.gz | |
MDEV-4028 - Converted rdiff files to uniform
MDEV-11 - Modifed tests and result files to use explicit column lists
in INSERT and SELECT statements
Diffstat (limited to 'mysql-test/suite/storage_engine/update_with_keys.test')
| -rw-r--r-- | mysql-test/suite/storage_engine/update_with_keys.test | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/suite/storage_engine/update_with_keys.test b/mysql-test/suite/storage_engine/update_with_keys.test index 578ee3b3294..77843365cef 100644 --- a/mysql-test/suite/storage_engine/update_with_keys.test +++ b/mysql-test/suite/storage_engine/update_with_keys.test @@ -32,7 +32,7 @@ if (!$mysql_errname) UPDATE t1 SET b='z' WHERE a < 2; UPDATE t1 SET b=''; --sorted_result - SELECT * FROM t1; + SELECT a,b FROM t1; } DROP TABLE t1; } @@ -62,7 +62,7 @@ if (!$mysql_errname) --source check_errors.inc UPDATE t1 SET a=12345 ORDER BY a, b LIMIT 1; --sorted_result - SELECT * FROM t1; + SELECT a,b FROM t1; # We'll check that the next update causes an error, # but won't check the result because it might be different depending @@ -101,7 +101,7 @@ if (!$mysql_errname) --source check_errors.inc UPDATE t1 SET a=a+1; --sorted_result - SELECT * FROM t1; + SELECT a,b FROM t1; --let $error_codes = ER_DUP_ENTRY,ER_DUP_KEY UPDATE t1 SET b='z'; --source check_errors.inc @@ -135,7 +135,7 @@ if (!$mysql_errname) UPDATE t1 SET a=12345 ORDER BY a DESC, b LIMIT 1; --sorted_result - SELECT * FROM t1; + SELECT a,b FROM t1; # We'll check that the next update causes an error, # but won't check the result because it might be different depending |