diff options
| author | Igor Babaev <igor@askmonty.org> | 2017-11-01 21:42:26 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2017-11-01 21:42:26 -0700 |
| commit | 6f1b6061d8e7aa867970c6827e6737c35ee8a254 (patch) | |
| tree | 412e4263ad9a6f3d06736f59187fd8759c266f88 /mysql-test/t/errors.test | |
| parent | 613dd62a76b51df38b96e36bce5bd8b7be2ca73a (diff) | |
| parent | 34737e0cee5cd101a23c19d1f30b872a45393382 (diff) | |
| download | mariadb-git-6f1b6061d8e7aa867970c6827e6737c35ee8a254.tar.gz | |
Merge remote-tracking branch 'shagalla/10.3-mdev12172' into 10.3
As a result of this merge the code for the following tasks appears in 10.3:
- MDEV-12172 Implement tables specified by table value constructors
- MDEV-12176 Transform [NOT] IN predicate with long list of values INTO
[NOT] IN subquery.
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 55461002fd4..6836fc5803c 100644 --- a/mysql-test/t/errors.test +++ b/mysql-test/t/errors.test @@ -179,16 +179,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 # |