diff options
author | Alexander Barkov <bar@mariadb.org> | 2017-02-20 19:30:58 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2017-04-05 15:02:57 +0400 |
commit | 99df09ecaba6b889330f987fbf8adcca88ebcd70 (patch) | |
tree | 3ae31562961e201dec080d5a2ffaed804e0fcbeb /mysql-test/suite/compat/oracle/t/misc.test | |
parent | af7f287b3b53742e32dd489c8e7187f336a222a9 (diff) | |
download | mariadb-git-99df09ecaba6b889330f987fbf8adcca88ebcd70.tar.gz |
MDEV-12086 sql_mode=ORACLE: allow SELECT UNIQUE as a synonym for SELECT DISTINCT
Diffstat (limited to 'mysql-test/suite/compat/oracle/t/misc.test')
-rw-r--r-- | mysql-test/suite/compat/oracle/t/misc.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/compat/oracle/t/misc.test b/mysql-test/suite/compat/oracle/t/misc.test new file mode 100644 index 00000000000..d939b20f8a0 --- /dev/null +++ b/mysql-test/suite/compat/oracle/t/misc.test @@ -0,0 +1,10 @@ +SET sql_mode=ORACLE; + +--echo # +--echo # MDEV-12086 sql_mode=ORACLE: allow SELECT UNIQUE as a synonym for SELECT DISTINCT +--echo # + +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (10),(20),(20),(30),(30),(30); +SELECT UNIQUE a FROM t1; +DROP TABLE t1; |