[Bug] Table creation failed via cursor.execute func

[DjangoPeng]

An error occurred when I want to create a table via cursor.execute function.

You can reproduce as below:

conn.create_database("tf_demo")
conn.switch_database("tf_demo")
print(conn.list_database())
        
cursor.execute(f"CREATE TABLE [IF NOT EXISTS] sunspot (date STRING, mssn DOUBLE,);")

ERROR:root:Invalid syntax or Object not exists, get ERROR from database : HTTP Error 422: Unprocessable Entity
[{'Database': 'public'}, {'Database': 'tf_demo'}]

[DjangoPeng]

@Subsegment

[yukkit]

Maybe you can remove the square brackets around “if not exists” and retry

[DjangoPeng]

[DjangoPeng]

Actually it's make me confused after removing [].

So I opened an issue of cnosdb syntax here cnosdb/cnosdb#910

[yukkit]

Thank you very much, we will optimize our documentation and error messages