[
https://issues.apache.org/jira/browse/PHOENIX-2258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kevin Liew updated PHOENIX-2258:
--------------------------------
Description:
When using Avatica to send a sql query:
{noformat}select now(){noformat}
The results are returned as one column, one row as expected
{noformat}"DATE '292278994-08-17 07:12:55.807'"
2404-04-06{noformat}
However, the column name and row value are always incorrect (and the values
never change).
These functions do work when we select from a table.
ie. this works as expected: {noformat}select now() from test{noformat}
was:
When using Avatica to request sql:
{noformat}select now(){noformat}
The results are returned as one column, one row as expected
{noformat}"DATE '292278994-08-17 07:12:55.807'"
2404-04-06{noformat}
However, the column name and row value are always incorrect (and the values
never change).
These functions do work when we select from a table.
ie. this works as expected: {noformat}select now() from test{noformat}
> Bad return value from now() and current_date()
> ----------------------------------------------
>
> Key: PHOENIX-2258
> URL: https://issues.apache.org/jira/browse/PHOENIX-2258
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.5.0
> Reporter: Kevin Liew
> Labels: queries, query
>
> When using Avatica to send a sql query:
> {noformat}select now(){noformat}
> The results are returned as one column, one row as expected
> {noformat}"DATE '292278994-08-17 07:12:55.807'"
> 2404-04-06{noformat}
> However, the column name and row value are always incorrect (and the values
> never change).
> These functions do work when we select from a table.
> ie. this works as expected: {noformat}select now() from test{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
