[jira] [Closed] (FLINK-28003) 'pos ' field would be updated to 'POSITION' when use SqlClient

["Martijn Visser (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-28003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Martijn Visser closed FLINK-28003.
----------------------------------
    Resolution: Won't Fix

If you want to use a reserved keyword in your SQL syntax, you'll need to use backticks for these columns. 

> 'pos  ' field would be updated to 'POSITION' when use SqlClient
> ---------------------------------------------------------------
>
>                 Key: FLINK-28003
>                 URL: https://issues.apache.org/jira/browse/FLINK-28003
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Client
>    Affects Versions: 1.15.0
>            Reporter: Jing Zhang
>            Priority: Major
>         Attachments: zj_test.sql
>
>
> When I run the following sql in SqlClient using 'sql-client.sh -f zj_test.sql'
> {code:java}
> create table if not exists db.zj_test(
> pos                   int,
> rank_cmd              string
> )
> partitioned by (
> `p_date` string,
> `p_hourmin` string);
> INSERT OVERWRITE TABLE db.zj_test PARTITION (p_date='20220605', p_hourmin = '0100')
> SELECT
> pos ,
> rank_cmd
> FROM db.sourceT
> where p_date = '20220605' and p_hourmin = '0100'; {code}
> An error would be thrown out because the 'pos' field is changed to 'POSITION'. I guess `SqlCompleter` in sqlClient module might do something wrong.
> The error could be reproduced using the attached file.
>  
>  



--
This message was sent by Atlassian Jira
(v8.20.7#820007)