Norbert Schultz created CASSANDRA-14245:
-------------------------------------------
Summary: SELECT JSON prints null on empty strings
Key: CASSANDRA-14245
URL: https://issues.apache.org/jira/browse/CASSANDRA-14245
Project: Cassandra
Issue Type: Bug
Components: CQL
Environment: Cassandra 3.11.2, Ubuntu 16.04 LTS
Reporter: Norbert Schultz
SELECT JSON reports an empty string as null.
Example:
{code:java}
cqlsh:unittest> create table test(id INT, name TEXT, PRIMARY KEY(id));
cqlsh:unittest> insert into test (id, name) VALUES (1, 'Foo');
cqlsh:unittest> insert into test (id, name) VALUES (2, '');
cqlsh:unittest> insert into test (id, name) VALUES (3, null);
cqlsh:unittest> select * from test;
id | name
----+------
1 | Foo
2 |
3 | null
(3 rows)
cqlsh:unittest> select JSON * from test;
[json]
--------------------------
{"id": 1, "name": "Foo"}
{"id": 2, "name": null}
{"id": 3, "name": null}
(3 rows){code}
This even happens, if the string is part of the Primary Key, which makes the
generated string not insertable.
{code:java}
cqlsh:unittest> create table test2 (id INT, name TEXT, age INT, PRIMARY KEY(id,
name));
cqlsh:unittest> insert into test2 (id, name, age) VALUES (1, '', 42);
cqlsh:unittest> select JSON * from test2;
[json]
------------------------------------
{"id": 1, "name": null, "age": 42}
(1 rows)
cqlsh:unittest> insert into test2 JSON '{"id": 1, "name": null, "age": 42}';
InvalidRequest: Error from server: code=2200 [Invalid query] message="Invalid
null value in condition for column name"{code}
On an older version of Cassandra (3.0.8) does not have this problem.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
