[PHOENIX-3437] Resolve sequence incompatibilities in phoenix-calcite

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Eric Lomore
• Reporter: Eric Lomore
• Created: 03/Nov/16 04:54
• Updated: 10/Nov/16 22:51

Description

1. The use of negative values in CREATE SEQUENCE statements is not currently supported.
CREATE SEQUENCE seq START WITH 2 INCREMENT BY -2

2. Exception throwing - resolving sequences is now handled in PhoenixSchema. We don't distinguish between a sequence and a table at this level. Hence we throw a TableNotFoundException rather than a SequenceNotFoundException when sequences cannot be found. This would be difficult to fix, so adjusting test cases seems like the best course.

3. Another issue that overhangs many of the cases is with the SYSTEM keyword - this is being handled in PHOENIX-3468