This is an automated email from the ASF dual-hosted git repository. jiangtian pushed a commit to branch fix_table_blob in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit 590e7a42fe6a53a74ce75f5cee8f96d538488fe5 Author: Tian Jiang <[email protected]> AuthorDate: Fri Jul 26 17:39:21 2024 +0800 restore IoTDBSubStringFunctionTableIT (cherry picked from commit 60c6870a715ac21979145ee48e7e67400a014808) --- .../scalar/IoTDBSubStringFunctionTableIT.java | 22 +++++++--------------- 1 file changed, 7 insertions(+), 15 deletions(-) diff --git a/integration-test/src/test/java/org/apache/iotdb/relational/it/query/old/builtinfunction/scalar/IoTDBSubStringFunctionTableIT.java b/integration-test/src/test/java/org/apache/iotdb/relational/it/query/old/builtinfunction/scalar/IoTDBSubStringFunctionTableIT.java index d31c12525b8..10afb199438 100644 --- a/integration-test/src/test/java/org/apache/iotdb/relational/it/query/old/builtinfunction/scalar/IoTDBSubStringFunctionTableIT.java +++ b/integration-test/src/test/java/org/apache/iotdb/relational/it/query/old/builtinfunction/scalar/IoTDBSubStringFunctionTableIT.java @@ -48,15 +48,8 @@ public class IoTDBSubStringFunctionTableIT { new String[] { "CREATE DATABASE " + DATABASE_NAME, "use " + DATABASE_NAME, - // "create table table1(device_id STRING ID, s1 TEXT MEASUREMENT, s2 INT32 - // MEASUREMENT, s3 INT64 MEASUREMENT, s4 FLOAT MEASUREMENT, s5 DOUBLE MEASUREMENT, s6 - // BOOLEAN MEASUREMENT, s7 DATE MEASUREMENT, s8 TIMESTAMP MEASUREMENT, s9 STRING - // MEASUREMENT, s10 BLOB MEASUREMENT)", - // "INSERT INTO table1(Time,device_id,s1,s2,s3,s4,s5,s6,s7,s8,s9,s10) values(1, - // 'd1', 'abcd', 1, 1, 1, 1, true, '2021-10-01', 1633046400000, 'abcd', X'abcd')", - - "create table table1(device_id STRING ID, s1 TEXT MEASUREMENT, s2 INT32 MEASUREMENT, s3 INT64 MEASUREMENT, s4 FLOAT MEASUREMENT, s5 DOUBLE MEASUREMENT, s6 BOOLEAN MEASUREMENT, s7 DATE MEASUREMENT, s8 TIMESTAMP MEASUREMENT, s9 STRING MEASUREMENT)", - "INSERT INTO table1(Time,device_id,s1,s2,s3,s4,s5,s6,s7,s8,s9) values(1, 'd1', 'abcd', 1, 1, 1, 1, true, '2021-10-01', 1633046400000, 'abcd')", + "create table table1(device_id STRING ID, s1 TEXT MEASUREMENT, s2 INT32 MEASUREMENT, s3 INT64 MEASUREMENT, s4 FLOAT MEASUREMENT, s5 DOUBLE MEASUREMENT, s6 BOOLEAN MEASUREMENT, s7 DATE MEASUREMENT, s8 TIMESTAMP MEASUREMENT, s9 STRING MEASUREMENT, s10 BLOB MEASUREMENT)", + "INSERT INTO table1(Time,device_id,s1,s2,s3,s4,s5,s6,s7,s8,s9,s10) values(1, 'd1', 'abcd', 1, 1, 1, 1, true, '2021-10-01', 1633046400000, 'abcd', X'abcd')", "INSERT INTO table1(Time,device_id,s1) values(2, 'd1', 'test')", "INSERT INTO table1(Time,device_id,s1) values(3, 'd1', 'abcdefg')", "INSERT INTO table1(Time,device_id,s9) values(2, 'd1', 'test')", @@ -190,12 +183,11 @@ public class IoTDBSubStringFunctionTableIT { // TODO add back after blob support // Wrong input type - // tableAssertTestFail( - // "select SUBSTRING(s10 FROM 1 FOR 1) from table1", - // TSStatusCode.SEMANTIC_ERROR.getStatusCode() - // + ": Scalar function substring only accepts two or three arguments and first must - // be text or string data type, second and third must be numeric data types [INT32, INT64]", - // DATABASE_NAME); + tableAssertTestFail( + "select SUBSTRING(s10 FROM 1 FOR 1) from table1", + TSStatusCode.SEMANTIC_ERROR.getStatusCode() + + ": Scalar function substring only accepts two or three arguments and first must be text or string data type, second and third must be numeric data types [INT32, INT64]", + DATABASE_NAME); // Using substring with float start position tableAssertTestFail(
