[IGNITE-11472] SQL: throw sane exception for unsupported features

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.7
• Component/s: sql
• Ignite Flags: Docs Required
• Assignee: Unassigned
• Reporter: Taras Ledkov
• Created: 05/Mar/19 09:39
• Updated: 28/Apr/20 10:56

Description

Feature	Issue	Comments
WITH RECURSIVE	IGNITE-7664	can be fixed immediately
DEFAULT value in the INSERT / MERGE	IGNITE-7664	can be fixed immediately
MEMORY, TEMPORARY, HIDDEN table types for CREATE TABLE	IGNITE-7664	can be fixed immediately
FIRST column position for ALTER TABLE ADD COLUMN	IGNITE-7664	can be fixed immediately
HELP / SHOW commands	IGNITE-7664	can be fixed immediately
GRANT / REVOKE commands	IGNITE-7664	can be fixed immediately
TIMESTAMP WITH TIME ZONE unsupported type	IGNITE-7664	can be fixed immediately
ENUM unsupported type	IGNITE-7664, IGNITE-11473	partially fixed, CAST and CONVERT functions have the bug at the H2 fixed at 1.4.198
MERGE USING	IGNITE-11444	cannot be fixed without patch to H2

Issue Links

• is a parent of: IGNITE-11444 SQL: MERGE USING must throw clear exception with UNSUPPORTED error code
• is a parent of: IGNITE-11473 SQL: check convert to ENUM type by functions CAST, CONVERT throws sane exception
• is a parent of: IGNITE-7664 SQL: throw sane exception on unsupported SQL statements
• links to: EPOCH discussion on userlist