cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Efimov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-13411) CQL query using the MAX function returns resultset with Row(null, null ...) if data is not found
Date Wed, 05 Apr 2017 11:00:46 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-13411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Andrew Efimov updated CASSANDRA-13411:
--------------------------------------
    Description: 
CQL query using the MAX function returns resultset with rows.size=1 if data is not found.
And Row has only null values.
{{SELECT id, value, MAX(date) FROM table WHERE id = "13411"}}
If table does not have row by {{id = "13411"}} then session returns ResultSet with Rows.size
= 1 and Row(null, null, null).
This is a problem to determine whether or not a data has actually been exist.
I did not check other aggregation functions.


  was:
CQL query using the MAX function returns resultset with rows.size=1 if data is not found.
And Row has only null values.
{{SELECT id, value, MAX(date) FROM table WHERE id = "1"}}
If table does not have row by {{id = "1"}} then session returns ResultSet with Rows.size =
1 and Row(null, null, null).
This is a problem to determine whether or not a data has actually been exist.
I did not check other aggregation functions.



> CQL query using the MAX function returns resultset with Row(null, null ...) if data is
not found
> ------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-13411
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13411
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL
>         Environment: 3.10
>            Reporter: Andrew Efimov
>            Priority: Minor
>
> CQL query using the MAX function returns resultset with rows.size=1 if data is not found.
And Row has only null values.
> {{SELECT id, value, MAX(date) FROM table WHERE id = "13411"}}
> If table does not have row by {{id = "13411"}} then session returns ResultSet with Rows.size
= 1 and Row(null, null, null).
> This is a problem to determine whether or not a data has actually been exist.
> I did not check other aggregation functions.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message