Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.37.0
Description
The SQL can run success in Postgres:
select concat_ws(',',ARRAY[10000, 10000, 10000, 10000]);
But in Calcite, It will throw exception:
@Test void testConcatFunction() { final String sql = "select concat_ws(',',ARRAY[10000, 10000, 10000, 10000]) as c"; fixture() .withFactory(c -> c.withOperatorTable(t -> SqlValidatorTest.operatorTableFor(SqlLibrary.POSTGRESQL))) .withCatalogReader(MockCatalogReaderExtended::create) .withSql(sql) .ok(); }
From line 1, column 8 to line 1, column 55: Cannot apply 'CONCAT_WS' to arguments of type 'CONCAT_WS(<CHAR(1)>, <INTEGER ARRAY>)'. Supported form(s): 'CONCAT_WS(<STRING>)'
This issue find in comment CALCITE-6446 .
Attachments
Attachments
Issue Links
- is related to
-
CALCITE-5741 Add CONCAT_WS function (enabled in MSSQL, MySQL, Postgres libraries)
- Closed
-
CALCITE-6446 Add CONCAT_WS function (enabled in Spark library)
- Closed
- links to