1 files changed, 17 insertions, 10 deletions
diff --git a/mysql-test/suite/sysschema/t/pr_table_exists.test b/mysql-test/suite/sysschema/t/pr_table_exists.test
index 06226510d32..d0c538843b1 100644
--- a/mysql-test/suite/sysschema/t/pr_table_exists.test
+++ b/mysql-test/suite/sysschema/t/pr_table_exists.test
@@ -1,25 +1,36 @@
 -- source include/not_embedded.inc
 
---disable_warnings
-DROP TABLE IF EXISTS t1, t2;
-DROP VIEW IF EXISTS v_t1;
---enable_warnings
 
 # Create a base table and a view
 CREATE TABLE t1 (id INT PRIMARY KEY);
-CREATE view v_t1 AS SELECT * FROM t1;
-
 # Verify the base table and view is supported
 CALL sys.table_exists('test', 't1', @exists);
 SELECT @exists;
+DROP TABLE t1;
 
+CREATE view v_t1 AS SELECT 1;
 CALL sys.table_exists('test', 'v_t1', @exists);
 SELECT @exists;
+DROP VIEW v_t1;
+
+CREATE TABLE tv (i int) with system versioning;
+CALL sys.table_exists('test','tv',@exists);
+SELECT @exists;
+DROP TABLE tv;
+
+CREATE SEQUENCE s;
+CALL sys.table_exists('test','s',@exists);
+SELECT @exists;
+DROP SEQUENCE s;
 
 # Replace the base table with a temporary table
 CREATE TEMPORARY TABLE t1 (id INT PRIMARY KEY);
 CALL sys.table_exists('test', 't1', @exists);
 SELECT @exists;
+DROP TEMPORARY TABLE t1;
+
+CALL sys.table_exists('information_schema', 'all_plugins', @exists);
+SELECT @exists;
 
 # Try a non-existing table
 CALL sys.table_exists('test', 't2', @exists);
@@ -34,8 +45,4 @@ CALL sys.table_exists(@identifier, 't1', @exists);
 -- error 1406
 CALL sys.table_exists('test', @identifier, @exists);
 
-# Clean up
-DROP TEMPORARY TABLE t1;
-DROP TABLE t1;
-DROP VIEW v_t1;
 SET @identifier := NULL;