CREATE SCHEMA test_public_schema;

Affected Rows: 1

CREATE SCHEMA test_public_schema;

Error: 1004(InvalidArguments), Schema test_public_schema already exists

CREATE SCHEMA IF NOT EXISTS test_public_schema;

Affected Rows: 1

SHOW DATABASES LIKE '%public%';

+--------------------+
| Schemas            |
+--------------------+
| public             |
| test_public_schema |
+--------------------+

SHOW DATABASES WHERE Schemas='test_public_schema';

+--------------------+
| Schemas            |
+--------------------+
| test_public_schema |
+--------------------+

USE test_public_schema;

Affected Rows: 0

CREATE TABLE hello(i TIMESTAMP TIME INDEX);

Affected Rows: 0

DROP TABLE hello;

Affected Rows: 0

CREATE TABLE hello(i TIMESTAMP TIME INDEX);

Affected Rows: 0

SHOW TABLES FROM test_public_schema;

+--------+
| Tables |
+--------+
| hello  |
+--------+

SHOW TABLES FROM public;

+---------+
| Tables  |
+---------+
| numbers |
+---------+

INSERT INTO hello VALUES (2), (3), (4);

Affected Rows: 3

SELECT * FROM hello;

+-------------------------+
| i                       |
+-------------------------+
| 1970-01-01T00:00:00.002 |
| 1970-01-01T00:00:00.003 |
| 1970-01-01T00:00:00.004 |
+-------------------------+

SHOW TABLES;

+--------+
| Tables |
+--------+
| hello  |
+--------+

DROP TABLE hello;

Affected Rows: 0

DROP TABLE hello;

Error: 4001(TableNotFound), Table not found: greptime.test_public_schema.hello

SHOW TABLES FROM test_public_schema;

+--------+
| Tables |
+--------+
+--------+

SHOW TABLES FROM public;

+---------+
| Tables  |
+---------+
| numbers |
+---------+

SHOW TABLES FROM public WHERE Tables='numbers';

+---------+
| Tables  |
+---------+
| numbers |
+---------+

DROP SCHEMA test_public_schema;

Error: 1001(Unsupported), SQL statement is not supported: DROP SCHEMA test_public_schema;, keyword: SCHEMA

SELECT * FROM test_public_schema.hello;

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Table not found: greptime.test_public_schema.hello

USE public;

Affected Rows: 0