[jira] [Created] (FLINK-29952) Using DROP TABLE XXX to drop a temporary table （or view） in sql-client can get an exception with incomplete explaination.

["Hang HOU (Jira)" <ji...@apache.org>]

Hang HOU created FLINK-29952:
--------------------------------

             Summary: Using DROP TABLE XXX to drop a temporary table （or view） in sql-client can get an exception with incomplete explaination.
                 Key: FLINK-29952
                 URL: https://issues.apache.org/jira/browse/FLINK-29952
             Project: Flink
          Issue Type: Improvement
          Components: Table SQL / API
    Affects Versions: 1.16.0
         Environment: Flink 1.16.0
Red Hat Enterprise Linux Server release 7.4
            Reporter: Hang HOU
         Attachments: image-2022-11-09-15-06-33-188.png

Drop temporary table by using DROP TABLE XXX...always get "Drop it first before removing the permanent table" but I just create a temporary table and have no relation with any permanent table. Like the official example :

-- create a word data generator table
CREATE TEMPORARY TABLE word_table (
    word STRING
) WITH (
    'connector' = 'datagen',
    'fields.word.length' = '1'
);

current exception:

 !image-2022-11-09-15-06-33-188.png! 


So I guess the exception  should append some notice like "please check whether miss  a TEMPORARY before TABLE".



--
This message was sent by Atlassian Jira
(v8.20.10#820010)