diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2015-01-08 21:26:56 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2015-01-09 10:23:28 +0100 |
| commit | 66278951761e973761fa037178ecf67562f0db2e (patch) | |
| tree | f379bad858784680acb7359a64af324c302a0375 /mysql-test/suite/funcs_1/datadict | |
| parent | b111d9884747001937f9272675536ece5254f1d3 (diff) | |
| download | mariadb-git-66278951761e973761fa037178ecf67562f0db2e.tar.gz | |
MDEV-6731 No ALGORITHM information in I_S.VIEWS
Diffstat (limited to 'mysql-test/suite/funcs_1/datadict')
| -rw-r--r-- | mysql-test/suite/funcs_1/datadict/is_views.inc | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/suite/funcs_1/datadict/is_views.inc b/mysql-test/suite/funcs_1/datadict/is_views.inc index 0ba1aaff3f2..716d50f5794 100644 --- a/mysql-test/suite/funcs_1/datadict/is_views.inc +++ b/mysql-test/suite/funcs_1/datadict/is_views.inc @@ -165,8 +165,13 @@ CREATE USER 'testuser1'@'localhost'; SELECT * FROM information_schema.views WHERE table_name LIKE 't1_%'; CREATE VIEW test.t1_view AS SELECT DISTINCT f1 FROM test.t1_table; +CREATE ALGORITHM=MERGE VIEW test.t1_view1 AS SELECT f1 FROM test.t1_table; +CREATE ALGORITHM=TEMPTABLE VIEW test.t1_view2 AS SELECT f1 FROM test.t1_table; SELECT * FROM information_schema.views WHERE table_name LIKE 't1_%'; +DROP VIEW test.t1_view1; +DROP VIEW test.t1_view2; + # # Check modification of DEFINER, SECURITY_TYPE, IS_UPDATABLE, VIEW_DEFINITION, # CHECK_OPTION |