[
https://issues.apache.org/jira/browse/PHOENIX-117?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Samarth Jain updated PHOENIX-117:
---------------------------------
Description:
Statement:
CREATE SEQUENCE ABC CACHE LONG.MAX_VALUE fails with the stacktrace:
{code}
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)
{code}
was:
Statement:
CREATE SEQUENCE ABC CACHE LONG.MAX_VALUE fails with the stacktrace:
{code}
java.sql.SQLException: ERROR 1204 (42Z04): Sequence CACHE value must be a non
negative integer constant. tableName=06Qxx0000000007_SEQ
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)
{code}
> Creating a sequence with CACHE LONG.MAX_VALUE fails
> ---------------------------------------------------
>
> Key: PHOENIX-117
> URL: https://issues.apache.org/jira/browse/PHOENIX-117
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0
> Reporter: Samarth Jain
>
> Statement:
> CREATE SEQUENCE ABC CACHE LONG.MAX_VALUE fails with the stacktrace:
> {code}
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
