You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Andrew Efimov (JIRA)" <ji...@apache.org> on 2017/04/05 11:00:46 UTC

[jira] [Created] (CASSANDRA-13411) CQL query using the MAX function returns resultset with Row(null, null ...) if data is not found

Andrew Efimov created CASSANDRA-13411:
-----------------------------------------

             Summary: 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 = "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.




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