diff options
Diffstat (limited to 'mysql-test/suite/sql_sequence/other.result')
-rw-r--r-- | mysql-test/suite/sql_sequence/other.result | 13 |
1 files changed, 6 insertions, 7 deletions
diff --git a/mysql-test/suite/sql_sequence/other.result b/mysql-test/suite/sql_sequence/other.result index 643233149d2..5226ce78789 100644 --- a/mysql-test/suite/sql_sequence/other.result +++ b/mysql-test/suite/sql_sequence/other.result @@ -310,9 +310,9 @@ CREATE TABLE t1 (a INT); CREATE TEMPORARY TABLE tmp (b INT); LOCK TABLE t1 READ; DROP SEQUENCE tmp; -ERROR 42S02: 'test.tmp' is not a SEQUENCE +ERROR 42S02: Unknown SEQUENCE: 'test.tmp' DROP TEMPORARY SEQUENCE tmp; -ERROR 42S02: 'test.tmp' is not a SEQUENCE +ERROR 42S02: Unknown SEQUENCE: 'test.tmp' DROP SEQUENCE t1; ERROR HY000: Table 't1' was locked with a READ lock and can't be updated DROP TEMPORARY SEQUENCE t1; @@ -324,19 +324,17 @@ DROP TEMPORARY SEQUENCE t1; ERROR 42S02: Unknown SEQUENCE: 'test.t1' DROP TABLE t1; CREATE TABLE t (a INT); -CREATE TEMPORARY TABLE s (f INT); CREATE SEQUENCE s; LOCK TABLE t WRITE; DROP SEQUENCE s; -ERROR 42S02: 'test.s' is not a SEQUENCE +ERROR HY000: Table 's' was not locked with LOCK TABLES DROP TEMPORARY SEQUENCE s; -ERROR 42S02: 'test.s' is not a SEQUENCE +ERROR 42S02: Unknown SEQUENCE: 'test.s' UNLOCK TABLES; CREATE TEMPORARY SEQUENCE s; LOCK TABLE t WRITE; DROP TEMPORARY SEQUENCE s; UNLOCK TABLES; -DROP TEMPORARY TABLE s; DROP SEQUENCE s; create table s(a INT); CREATE TEMPORARY TABLE s (f INT); @@ -352,9 +350,10 @@ CREATE VIEW v1 as SELECT * FROM t; CREATE SEQUENCE s; DROP SEQUENCE IF EXISTS v1; Warnings: -Note 4091 Unknown SEQUENCE: 'test.v1' +Note 1965 'test.v1' is a view DROP VIEW IF EXISTS s; Warnings: +Warning 1347 'test.s' is not of type 'VIEW' Note 4092 Unknown VIEW: 'test.s' DROP VIEW v1; DROP SEQUENCE s; |