sql-tests/inputs/show-views.sql

0001 -- Test data.
0002 CREATE DATABASE showdb;
0003 USE showdb;
0004 CREATE TABLE tbl(a STRING, b INT, c STRING, d STRING) USING parquet;
0005 CREATE VIEW view_1 AS SELECT * FROM tbl;
0006 CREATE VIEW view_2 AS SELECT * FROM tbl WHERE c='a';
0007 CREATE GLOBAL TEMP VIEW view_3 AS SELECT 1 as col1;
0008 CREATE TEMPORARY VIEW view_4(e INT) USING parquet;
0009
0010 -- SHOW VIEWS
0011 SHOW VIEWS;
0012 SHOW VIEWS FROM showdb;
0013 SHOW VIEWS IN showdb;
0014 SHOW VIEWS IN global_temp;
0015
0016 -- SHOW VIEWS WITH wildcard match
0017 SHOW VIEWS 'view_*';
0018 SHOW VIEWS LIKE 'view_1*|view_2*';
0019 SHOW VIEWS IN showdb 'view_*';
0020 SHOW VIEWS IN showdb LIKE 'view_*';
0021 -- Error when database not exists
0022 SHOW VIEWS IN wrongdb LIKE 'view_*';
0023
0024 -- Clean Up
0025 DROP VIEW global_temp.view_3;
0026 DROP VIEW view_4;
0027 USE default;
0028 DROP DATABASE showdb CASCADE;