greptimedb/tests/cases/standalone/common/catalog/schema.result

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%';

+--------------------+
| Database           |
+--------------------+
| public             |
| test_public_schema |
+--------------------+

SHOW DATABASES WHERE Database = 'test_public_schema';

+--------------------+
| Database           |
+--------------------+
| 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_in_test_public_schema |
+------------------------------+
| hello                        |
+------------------------------+

SHOW TABLES FROM public;

+------------------+
| Tables_in_public |
+------------------+
| 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_in_test_public_schema |
+------------------------------+
| hello                        |
+------------------------------+

SHOW FULL TABLES WHERE Table_type != 'VIEW';

+------------------------------+------------+
| Tables_in_test_public_schema | Table_type |
+------------------------------+------------+
| hello                        | BASE TABLE |
+------------------------------+------------+

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_in_test_public_schema |
+------------------------------+
+------------------------------+

SHOW TABLES FROM public;

+------------------+
| Tables_in_public |
+------------------+
| numbers          |
+------------------+

SHOW TABLES FROM public WHERE Tables = 'numbers';

+------------------+
| Tables_in_public |
+------------------+
| numbers          |
+------------------+

DROP SCHEMA test_public_schema;

Error: 1004(InvalidArguments), Schema `test_public_schema` is in use

USE public;

Affected Rows: 0

DROP SCHEMA test_public_schema;

Affected Rows: 0

SELECT * FROM test_public_schema.hello;

Error: 4001(TableNotFound), Failed to plan SQL: Table not found: greptime.test_public_schema.hello

USE public;

Affected Rows: 0