Misleading error message for SQL typo

[tisonkun]

What type of enhancement is this?

User experience

What does the enhancement do?

CREATE TABLE IF NOT EXIST t(`Hits` STRING NULL, ts TIMESTAMP(3) NOT NULL, TIME INDEX ("ts"));

throws:

ERROR 1815 (HY000): Missing time index constraint

But it's actually because IF NOT EXIST should be IF NOT EXISTS.

Implementation challenges

No response

[tisonkun]

This may not be trivial as it firstly looks like, since IF and EXISTS can be valid table name (NOT is invalid for PG but valid in sqlparser-rs by default).

Push #3472 to terminate parsing on invalid columns eagerly so we can have a much simpler context when considering this issue.