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)