This is an automated email from the ASF dual-hosted git repository. jackietien pushed a commit to branch ty/TableModelDevelop in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit d52875a6f0aa358e475f2e8a4d2d647c892e9ff0 Author: JackieTien97 <[email protected]> AuthorDate: Tue Jun 4 21:24:37 2024 +0800 Add IT for database management --- .../relational/it/schema/IoTDBDatabaseIT.java | 38 ++++++++++++++++++++++ 1 file changed, 38 insertions(+) diff --git a/integration-test/src/test/java/org/apache/iotdb/relational/it/schema/IoTDBDatabaseIT.java b/integration-test/src/test/java/org/apache/iotdb/relational/it/schema/IoTDBDatabaseIT.java index b76676f9c78..fca431f8432 100644 --- a/integration-test/src/test/java/org/apache/iotdb/relational/it/schema/IoTDBDatabaseIT.java +++ b/integration-test/src/test/java/org/apache/iotdb/relational/it/schema/IoTDBDatabaseIT.java @@ -40,6 +40,7 @@ import java.sql.Statement; import static org.apache.iotdb.db.queryengine.common.header.ColumnHeaderConstant.showDBColumnHeaders; import static org.junit.Assert.assertEquals; import static org.junit.Assert.assertFalse; +import static org.junit.Assert.assertTrue; import static org.junit.Assert.fail; @RunWith(IoTDBTestRunner.class) @@ -113,6 +114,43 @@ public class IoTDBDatabaseIT { assertEquals("508: Path [root.test] does not exist", e.getMessage()); } + // create with strange name + try { + statement.execute("create database 1test"); + fail("create database 1test shouldn't succeed because test1 doesn't exist"); + } catch (SQLException e) { + assertTrue( + e.getMessage(), + e.getMessage() + .endsWith( + "identifiers must not start with a digit; surround the identifier with double quotes")); + } + + statement.execute("create database \"1test\""); + statement.execute("use \"1test\""); + + try { + statement.execute("create database 1"); + fail("create database 1test shouldn't succeed because test1 doesn't exist"); + } catch (SQLException e) { + // TODO add error msg assert + } + + // TODO fix it, should succeed + statement.execute("create database \"1\""); + statement.execute("use \"1\""); + + try { + statement.execute("create database a.b"); + fail("create database 1test shouldn't succeed because test1 doesn't exist"); + } catch (SQLException e) { + // TODO add error msg assert + } + + // TODO fix it, should succeed + statement.execute("create database \"a.b\""); + statement.execute("use \"a.b\""); + } catch (SQLException e) { e.printStackTrace(); fail(e.getMessage());
