summaryrefslogtreecommitdiff
path: root/mysql-test/main/create.result
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2020-04-09 01:11:35 +0300
committerMonty <monty@mariadb.org>2020-04-19 17:33:51 +0300
commit78357796e8069f8cd041ea0bb0f5802234bdd2bc (patch)
treee917fe022d8c0796336bb626a12a702bfa718b5c /mysql-test/main/create.result
parent91ffdc8380ab48a2d57dc81472beb80af115318f (diff)
downloadmariadb-git-78357796e8069f8cd041ea0bb0f5802234bdd2bc.tar.gz
Added support for VISIBLE attribute for indexes in CREATE TABLE
MDEV-22199 Add VISIBLE attribute for indexes in CREATE TABLE This was done to make it easier to read in dumps from MySQL 8.0 generated with MySQL workbench
Diffstat (limited to 'mysql-test/main/create.result')
-rw-r--r--mysql-test/main/create.result2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/create.result b/mysql-test/main/create.result
index 45d4a24ddf8..d22d55669ac 100644
--- a/mysql-test/main/create.result
+++ b/mysql-test/main/create.result
@@ -2012,3 +2012,5 @@ CREATE TABLE t1 ( id1 INT, id2 INT, CONSTRAINT `foo` PRIMARY KEY (id1), CONSTRAI
Warnings:
Warning 1280 Name 'foo' ignored for PRIMARY key.
DROP TABLE t1;
+CREATE TABLE t1 (id1 INT, id2 INT, primary key (id1), unique index (id2) visible);
+drop table t1;