Andrew Pilloud created CALCITE-2571: ---------------------------------------
Summary: TRIM does not match the behavior of most SQL implementations Key: CALCITE-2571 URL: https://issues.apache.org/jira/browse/CALCITE-2571 Project: Calcite Issue Type: Bug Components: core Reporter: Andrew Pilloud Assignee: Julian Hyde Most SQL implementations trim all characters if more then one is provided to the trim function. Calcite's SqlFunctions implementation silently drops the extra characters, resulting in data corruption. Here is a sampling of implementations that trim all characters: MySQL - https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_trim Sql Server - https://docs.microsoft.com/en-us/sql/t-sql/functions/trim-transact-sql?view=sql-server-2017 Flink - https://ci.apache.org/projects/flink/flink-docs-stable/dev/table/sql.html Spark - https://spark.apache.org/docs/2.3.0/api/sql/index.html#trim Postgres - https://www.postgresql.org/docs/9.1/static/functions-string.html SqLite - https://www.sqlite.org/lang_corefunc.html#trim Also see: CALCITE-2530 BEAM-4704 -- This message was sent by Atlassian JIRA (v7.6.3#76005)