Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-117

Creating a sequence with CACHE LONG.MAX_VALUE fails

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Labels:
      None

      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)
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              samarthjain Samarth Jain
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: