[PHOENIX-117] Creating a sequence with CACHE LONG.MAX_VALUE fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Assignee: Unassigned
• Reporter: Samarth Jain
• Created: 06/Mar/14 20:59
• Updated: 10/Mar/14 21:29
• Resolved: 10/Mar/14 21:29

Description

Statement:
CREATE SEQUENCE ABC CACHE LONG.MAX_VALUE fails with the stacktrace:

java.sql.SQLException: ERROR 1204 (42Z04): Sequence CACHE value must be a non negative integer constant. tableName=ABC
	at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:308)
	at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133)
	at org.apache.phoenix.compile.CreateSequenceCompiler.compile(CreateSequenceCompiler.java:175)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableCreateSequenceStatement.compilePlan(PhoenixStatement.java:469)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableCreateSequenceStatement.compilePlan(PhoenixStatement.java:459)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:224)
	at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:923)