diff options
| author | Galina Shalygina <galashalygina@gmail.com> | 2017-10-28 20:54:18 +0200 |
|---|---|---|
| committer | Galina Shalygina <galashalygina@gmail.com> | 2017-10-28 20:54:18 +0200 |
| commit | a4ded0a9b57ee7a801ce20cffdaee21fee281123 (patch) | |
| tree | 05470ab32497f0c4cde65905ae92a3c289aaeb00 /mysql-test/t/errors.test | |
| parent | 75370a58f4e4ac90e0fe441676917468afca5576 (diff) | |
| download | mariadb-git-a4ded0a9b57ee7a801ce20cffdaee21fee281123.tar.gz | |
Mistakes corrected.
TVC can be used in IN subquery and in PARTITION BY struct now.
Special variable to control working of optimization added.
Diffstat (limited to 'mysql-test/t/errors.test')
| -rw-r--r-- | mysql-test/t/errors.test | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/t/errors.test b/mysql-test/t/errors.test index 6ce6e439919..6b559d60eb4 100644 --- a/mysql-test/t/errors.test +++ b/mysql-test/t/errors.test @@ -178,16 +178,16 @@ SELECT UPDATEXML(-73 * -2465717823867977728,@@global.auto_increment_increment,nu CREATE TABLE t1 (a INT); CREATE TABLE t2(a INT PRIMARY KEY, b INT); --error ER_BAD_FIELD_ERROR -SELECT '' AS b FROM t1 GROUP BY VALUES(b); +SELECT '' AS b FROM t1 GROUP BY VALUE(b); --error ER_BAD_FIELD_ERROR -REPLACE t2(b) SELECT '' AS b FROM t1 GROUP BY VALUES(b); +REPLACE t2(b) SELECT '' AS b FROM t1 GROUP BY VALUE(b); --error ER_BAD_FIELD_ERROR -UPDATE t2 SET a=(SELECT '' AS b FROM t1 GROUP BY VALUES(b)); +UPDATE t2 SET a=(SELECT '' AS b FROM t1 GROUP BY VALUE(b)); --error ER_BAD_FIELD_ERROR INSERT INTO t2 VALUES (1,0) ON DUPLICATE KEY UPDATE - b=(SELECT '' AS b FROM t1 GROUP BY VALUES(b)); + b=(SELECT '' AS b FROM t1 GROUP BY VALUE(b)); INSERT INTO t2(a,b) VALUES (1,0) ON DUPLICATE KEY UPDATE - b=(SELECT VALUES(a)+2 FROM t1); + b=(SELECT VALUE(a)+2 FROM t1); DROP TABLE t1, t2; --echo # |