phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4197) Issue with creating multiple sequences
Date Wed, 13 Sep 2017 23:08:00 GMT

    [ 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)

Mime
View raw message