macroguo-ghy commented on code in PR #3701:
URL: https://github.com/apache/calcite/pull/3701#discussion_r1500193502
##########
core/src/test/java/org/apache/calcite/rel/rel2sql/RelToSqlConverterTest.java:
##########
@@ -7893,6 +7980,132 @@ private void checkLiteral2(String expression, String
expected) {
sql(query).withPresto().ok(expectedPresto);
}
+ /** Test case for
+ * <a
href="https://issues.apache.org/jira/browse/CALCITE-6257";>[CALCITE-6257]
+ * StarRocks dialect implementation </a>.
+ */
+ @Test void testCastToTimestamp() {
+ final String query = "select * from \"employee\" where \"hire_date\" - "
+ + "INTERVAL '19800' SECOND(5) > cast(\"hire_date\" as TIMESTAMP) ";
+ final String expectedStarRocks = "SELECT *\n"
+ + "FROM `foodmart`.`employee`\n"
+ + "WHERE (`hire_date` - INTERVAL '19800' SECOND) > CAST(`hire_date` AS
DATETIME)";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ }
+
+ @Test void testArrayValueConstructor() {
+ final String query = "SELECT ARRAY[1, 2, 3]";
+ final String expectedStarRocks = "SELECT[1, 2, 3]";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ }
+
+ @Test void testTrimWithBothSpecialCharacter() {
+ final String query = "SELECT TRIM(BOTH '$@*A' from
'$@*AABC$@*AADCAA$@*A')\n"
+ + "from \"foodmart\".\"reserve_employee\"";
+ final String expectedStarRocks = "SELECT
REGEXP_REPLACE('$@*AABC$@*AADCAA$@*A',"
+ + " '^(\\$\\@\\*A)*|(\\$\\@\\*A)*$', '')\n"
+ + "FROM `foodmart`.`reserve_employee`";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ }
+
+ @Test void testUnparseSqlIntervalQualifier() {
+ final String sql0 = "select * from \"employee\" where \"hire_date\" - "
+ + "INTERVAL '19800' SECOND(5) > TIMESTAMP '2005-10-17 00:00:00' ";
+ final String expect0 = "SELECT *\n"
+ + "FROM `foodmart`.`employee`\n"
+ + "WHERE (`hire_date` - INTERVAL '19800' SECOND) > DATETIME
'2005-10-17 00:00:00'";
+ sql(sql0).withStarRocks().ok(expect0);
+
+ final String sql1 = "select * from \"employee\" where \"hire_date\" + "
+ + "INTERVAL '10' HOUR > TIMESTAMP '2005-10-17 00:00:00' ";
+ final String expect1 = "SELECT *\n"
+ + "FROM `foodmart`.`employee`\n"
+ + "WHERE (`hire_date` + INTERVAL '10' HOUR) > DATETIME '2005-10-17
00:00:00'";
+ sql(sql1).withStarRocks().ok(expect1);
+
+ final String sql2 = "select * from \"employee\" where \"hire_date\" + "
+ + "INTERVAL '1' YEAR > TIMESTAMP '2005-10-17 00:00:00' ";
+ final String expect2 = "SELECT *\n"
+ + "FROM `foodmart`.`employee`\n"
+ + "WHERE (`hire_date` + INTERVAL '1' YEAR) > DATETIME '2005-10-17
00:00:00'";
+ sql(sql2).withStarRocks().ok(expect2);
+
+ final String sql3 = "select * from \"employee\" "
+ + "where \"hire_date\" + INTERVAL '39' MINUTE"
+ + " > TIMESTAMP '2005-10-17 00:00:00' ";
+ final String expect3 = "SELECT *\n"
+ + "FROM `foodmart`.`employee`\n"
+ + "WHERE (`hire_date` + INTERVAL '39' MINUTE) > DATETIME '2005-10-17
00:00:00'";
+ sql(sql3).withStarRocks().ok(expect3);
+ }
+
+ @Test void testTrim() {
+ final String query = "SELECT TRIM(' str ')\n"
+ + "from \"foodmart\".\"reserve_employee\"";
+ final String expectedStarRocks = "SELECT TRIM(' str ')\n"
+ + "FROM `foodmart`.`reserve_employee`";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ }
+
+ @Test void testTrimWithBoth() {
+ final String query = "SELECT TRIM(both ' ' from ' str ')\n"
+ + "from \"foodmart\".\"reserve_employee\"";
+ final String expectedStarRocks = "SELECT TRIM(' str ')\n"
+ + "FROM `foodmart`.`reserve_employee`";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ }
+
+ @Test void testTrimWithLeading() {
+ final String query = "SELECT TRIM(LEADING ' ' from ' str ')\n"
+ + "from \"foodmart\".\"reserve_employee\"";
+ final String expectedStarRocks = "SELECT LTRIM(' str ')\n"
+ + "FROM `foodmart`.`reserve_employee`";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ }
+
+ @Test void testTrimWithTailing() {
+ final String query = "SELECT TRIM(TRAILING ' ' from ' str ')\n"
+ + "from \"foodmart\".\"reserve_employee\"";
+ final String expectedStarRocks = "SELECT RTRIM(' str ')\n"
+ + "FROM `foodmart`.`reserve_employee`";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ }
+
+ @Test void testTrimWithBothChar() {
+ final String query = "SELECT TRIM(both 'a' from 'abcda')\n"
+ + "from \"foodmart\".\"reserve_employee\"";
+ final String expectedStarRocks = "SELECT REGEXP_REPLACE('abcda',
'^(a)*|(a)*$', '')\n"
+ + "FROM `foodmart`.`reserve_employee`";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ }
+
+ @Test void testTrimWithTailingChar() {
+ final String query = "SELECT TRIM(TRAILING 'a' from 'abcd')\n"
+ + "from \"foodmart\".\"reserve_employee\"";
+ final String expectedStarRocks = "SELECT REGEXP_REPLACE('abcd', '(a)*$',
'')\n"
+ + "FROM `foodmart`.`reserve_employee`";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ }
+
+ @Test void testTrimWithLeadingChar() {
+ final String query = "SELECT TRIM(LEADING 'a' from 'abcd')\n"
+ + "from \"foodmart\".\"reserve_employee\"";
+ final String expectedStarRocks = "SELECT REGEXP_REPLACE('abcd', '^(a)*',
'')\n"
+ + "FROM `foodmart`.`reserve_employee`";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ }
+
+ @Test void testSelectQueryWithRollup() {
+ final String query = "select \"product_class_id\", \"product_id\",
count(*) "
+ + "from \"product\" group by rollup(\"product_class_id\",
\"product_id\")";
+ final String expectedStarRocks = "SELECT `product_class_id`, `product_id`,
COUNT(*)\n"
+ + "FROM `foodmart`.`product`\n"
+ + "GROUP BY ROLLUP(`product_class_id`, `product_id`)";
+ sql(query).withStarRocks().ok(expectedStarRocks);
+ SqlDialect sqlDialect = sql(query).withHive().dialect;
Review Comment:
`withHive()` ?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@calcite.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
