[jira] [Commented] (PHOENIX-4197) Issue with creating multiple sequences

["James Taylor (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-4197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16165445#comment-16165445 ] 

James Taylor commented on PHOENIX-4197:
---------------------------------------

[~mujtabachohan] - just make this change as there's no reason to select from the SYSTEM.SEQUENCE table to get the next value of a sequence (FWIW, in the past we didn't have this capability):
{code}
    private static final String SELECT_NEXT_VALUE_SQL = "SELECT NEXT VALUE FOR %s";
{code}

> Issue with creating multiple sequences
> --------------------------------------
>
>                 Key: PHOENIX-4197
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4197
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Mujtaba Chohan
>         Attachments: SeqIT.java
>
>
> [~jamestaylor] Please see the attached test. If I drop any prior sequences then the test passes fine i.e. un-comment {{conn.createStatement().execute("DROP SEQUENCE BEFORE_TEST");}} then this test passes otherwise it fails with:
> {noformat}
> java.lang.AssertionError
> 	at org.junit.Assert.fail(Assert.java:86)
> 	at org.junit.Assert.assertTrue(Assert.java:41)
> 	at org.junit.Assert.assertFalse(Assert.java:64)
> 	at org.junit.Assert.assertFalse(Assert.java:74)
> 	at org.apache.phoenix.end2end.SequenceIT.assertSequenceValuesForSingleRow(SequenceIT.java:88)
> 	at org.apache.phoenix.end2end.SequenceIT.testSequenceDefault(SequenceIT.java:73)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)