mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2025-12-27 16:32:54 +00:00
db89235474
* feat: only allow timestamp data type as time index * test: update sqltest cases, todo: need some fixes * fix: sqlness tests * fix: forgot adding back cte test * chore: style
44 lines
716 B
SQL
44 lines
716 B
SQL
CREATE SCHEMA test_public_schema;
|
|
|
|
CREATE SCHEMA test_public_schema;
|
|
|
|
CREATE SCHEMA IF NOT EXISTS test_public_schema;
|
|
|
|
SHOW DATABASES LIKE '%public%';
|
|
|
|
SHOW DATABASES WHERE Schemas='test_public_schema';
|
|
|
|
USE test_public_schema;
|
|
|
|
CREATE TABLE hello(i TIMESTAMP TIME INDEX);
|
|
|
|
DROP TABLE hello;
|
|
|
|
CREATE TABLE hello(i TIMESTAMP TIME INDEX);
|
|
|
|
SHOW TABLES FROM test_public_schema;
|
|
|
|
SHOW TABLES FROM public;
|
|
|
|
INSERT INTO hello VALUES (2), (3), (4);
|
|
|
|
SELECT * FROM hello;
|
|
|
|
SHOW TABLES;
|
|
|
|
DROP TABLE hello;
|
|
|
|
DROP TABLE hello;
|
|
|
|
SHOW TABLES FROM test_public_schema;
|
|
|
|
SHOW TABLES FROM public;
|
|
|
|
SHOW TABLES FROM public WHERE Tables='numbers';
|
|
|
|
DROP SCHEMA test_public_schema;
|
|
|
|
SELECT * FROM test_public_schema.hello;
|
|
|
|
USE public;
|