phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-922) Support SELECT without a from clause
Date Sat, 04 Jul 2015 21:10:05 GMT

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

Hudson commented on PHOENIX-922:
--------------------------------

FAILURE: Integrated in Phoenix-master #813 (See [https://builds.apache.org/job/Phoenix-master/813/])
PHOENIX-922 Support SELECT without a from clause (maryannxue: rev df42fa13072df8a738e0bf2c2a22b58c512a9dcf)
* phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/ProjectionCompiler.java
* phoenix-core/src/test/java/org/apache/phoenix/compile/QueryCompilerTest.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/TableRef.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/SelectStatement.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/FromCompiler.java
* phoenix-core/src/test/java/org/apache/phoenix/parse/QueryParserTest.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/PTableImpl.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/QueryCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/TupleProjectionCompiler.java
* phoenix-core/src/main/antlr3/PhoenixSQL.g
* phoenix-core/src/main/java/org/apache/phoenix/execute/EmptyTableQueryPlan.java


> Support SELECT without a from clause
> ------------------------------------
>
>                 Key: PHOENIX-922
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-922
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.0.0
>            Reporter: Dan Di Spaltro
>            Assignee: Maryann Xue
>             Fix For: 4.5.0
>
>         Attachments: PHOENIX-922.2.patch, PHOENIX-922.3.patch, PHOENIX-922.patch
>
>
> You should be able to select any "generator" type function from Phoenix without specifying
a table.  For instance a sequence needs an arbitrary potentially unrelated table just to get
the next value.  The fix should enable queries like this:
> {code}
> SELECT NEXT VALUE FOR my_seq
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message