[CASSANDRA-15075] SELECT JSON generates invalid JSON for the duration type

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.11.6, 4.0-alpha3, 4.0
• Component/s: CQL/Syntax
• Bug Category: Correctness
• Severity: Normal
• Complexity: Low Hanging Fruit
• Discovered By: User Report
• Since Version: 3.11.0

Source Control Link

https://github.com/apache/cassandra/commit/5d930cc9db6cdb29c2f7f1dec5a03c5b30ab66a7

Test and Documentation Plan

add new test

• Assignee: Pekka Enberg Assign to me
• Reporter: Pekka Enberg

Authors

Pekka Enberg

Reviewers

Marcus Eriksson

• Created: 03/Apr/19 12:38
• Updated: 15/May/20 08:38
• Resolved: 28/Nov/19 07:59

Description

Currently, Apache Cassandra generates invalid JSON for the "duration" type.

cqlsh> CREATE KEYSPACE ks1 WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
cqlsh> CREATE TABLE ks1.data (id int, d duration, PRIMARY KEY (id));

cqlsh> INSERT INTO ks1.data (id, d) VALUES (1, 6h40m);
cqlsh> SELECT JSON d FROM ks1.data WHERE id = 1;

[json]
--------------
{"d": 6h40m}

That is, the duration is not quoted and is therefore invalid according to https://jsonlint.com/, for example.

 

Fix the problem by quoting the formatted duration type properly:

cqlsh> INSERT INTO ks1.data (id, d) VALUES (1, 6h40m);
cqlsh> SELECT JSON d FROM ks1.data WHERE id = 1;

[json]
----------------
{"d": "6h40m"}

(1 rows)

 

The problem is fixed by the following patch:

0001-Fix-SELECT-JSON-formatting-for-the-duration-type.patch