[
https://issues.apache.org/jira/browse/FLINK-16506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Flink Jira Bot updated FLINK-16506:
-----------------------------------
Labels: auto-deprioritized-major stale-minor (was:
auto-deprioritized-major)
I am the [Flink Jira Bot|https://github.com/apache/flink-jira-bot/] and I help
the community manage its development. I see this issues has been marked as
Minor but is unassigned and neither itself nor its Sub-Tasks have been updated
for 180 days. I have gone ahead and marked it "stale-minor". If this ticket is
still Minor, please either assign yourself or give an update. Afterwards,
please remove the label or in 7 days the issue will be deprioritized.
> SqlCreateTable can not get the original text when there exists non-ascii char
> in the column definition
> ------------------------------------------------------------------------------------------------------
>
> Key: FLINK-16506
> URL: https://issues.apache.org/jira/browse/FLINK-16506
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API
> Affects Versions: 1.10.0
> Reporter: Terry Wang
> Priority: Minor
> Labels: auto-deprioritized-major, stale-minor
>
> We can reproduce this problem in FlinkSqlParserImplTest, add one more column
> definition
> ` x varchar comment 'Flink 社区', \n`
> ```
> @Test
> public void testCreateTableWithComment() {
> conformance0 = FlinkSqlConformance.HIVE;
> check("CREATE TABLE tbl1 (\n" +
> " a bigint comment 'test column comment
> AAA.',\n" +
> " h varchar, \n" +
> " x varchar comment 'Flink 社区', \n" +
> " g as 2 * (a + 1), \n" +
> " ts as toTimestamp(b, 'yyyy-MM-dd HH:mm:ss'),
> \n" +
> " b varchar,\n" +
> " proc as PROCTIME(), \n" +
> " PRIMARY KEY (a, b)\n" +
> ")\n" +
> "comment 'test table comment ABC.'\n" +
> "PARTITIONED BY (a, h)\n" +
> " with (\n" +
> " 'connector' = 'kafka', \n" +
> " 'kafka.topic' = 'log.test'\n" +
> ")\n",
> "CREATE TABLE `TBL1` (\n" +
> " `A` BIGINT COMMENT 'test column comment
> AAA.',\n" +
> " `H` VARCHAR,\n" +
> " `X` VARCHAR COMMENT 'Flink 社区', \n" +
> " `G` AS (2 * (`A` + 1)),\n" +
> " `TS` AS `TOTIMESTAMP`(`B`, 'yyyy-MM-dd
> HH:mm:ss'),\n" +
> " `B` VARCHAR,\n" +
> " `PROC` AS `PROCTIME`(),\n" +
> " PRIMARY KEY (`A`, `B`)\n" +
> ")\n" +
> "COMMENT 'test table comment ABC.'\n" +
> "PARTITIONED BY (`A`, `H`)\n" +
> "WITH (\n" +
> " 'connector' = 'kafka',\n" +
> " 'kafka.topic' = 'log.test'\n" +
> ")");
> }
> ```
> the actual unparse of x column will be ` X` VARCHAR COMMENT u&'Flink
> \793e\533a' instead of our expection.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
