Files
greptimedb/tests/cases/standalone/common/create/create_database.result
Jeff Chiang 9d12496aaf feat: create database with options (#3751)
* feat: create database with options

* fix: clippy

* fix: clippy

* feat: rebase and add Display test

* feat: sqlness test for creating database with options

* address comments

Signed-off-by: tison <wander4096@gmail.com>

* fixup tests

Signed-off-by: tison <wander4096@gmail.com>

* catch up

Signed-off-by: tison <wander4096@gmail.com>

* DefaultOnNull

Signed-off-by: tison <wander4096@gmail.com>

---------

Signed-off-by: tison <wander4096@gmail.com>
Co-authored-by: tison <wander4096@gmail.com>
2024-05-13 09:00:15 +00:00

37 lines
692 B
Plaintext
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

create database '㊙database';
Error: 1002(Unexpected), Unexpected, violated: Invalid database name: ㊙database
create database illegal-database;
Error: 1001(Unsupported), SQL statement is not supported: create database illegal-database;, keyword: -
create database 'illegal-database';
Affected Rows: 1
create database mydb with (ttl = '1h');
Affected Rows: 1
show databases;
+--------------------+
| Database |
+--------------------+
| greptime_private |
| illegal-database |
| information_schema |
| mydb |
| public |
+--------------------+
drop database 'illegal-database';
Affected Rows: 0
drop database mydb;
Affected Rows: 0