[
https://issues.apache.org/jira/browse/TRAFODION-2202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15455813#comment-15455813
]
liu ming commented on TRAFODION-2202:
-------------------------------------
in mode_special_4, the binder try to accept Oracle syntax of seq.nextval, so it
will do transformation about nextval.
The executor code to execute sequence will run a query to get the current/next
value of a sequence and in that query text, it use 'nextval' which will
recursively trigger binder to do a replacement, and cause issues.
Simple fix is to replace 'nextval' to other name.
> in mode_special_4, sequence function is broken
> ----------------------------------------------
>
> Key: TRAFODION-2202
> URL: https://issues.apache.org/jira/browse/TRAFODION-2202
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: liu ming
> Assignee: liu ming
>
> CREATE SEQUENCE TRAFODION.SEABASE.TEST_SEQ
> START WITH 1 /* NEXT AVAILABLE VALUE 1 */
> INCREMENT BY 1
> MAXVALUE 99999999999999999
> MINVALUE 1
> CACHE 25
> NO CYCLE
> LARGEINT
> ;
> >>cqd mode_special_4 'on';
> --- SQL operation complete.
> >>select seqnum(test_seq1,current) from (values(1));
> *** ERROR[8402] A string overflow occurred during the evaluation of a
> character expression.
> --- 0 row(s) selected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
