[
https://issues.apache.org/jira/browse/CASSANDRA-15075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Eriksson updated CASSANDRA-15075:
----------------------------------------
Fix Version/s: (was: 3.11.x)
(was: 4.x)
4.0
3.11.6
Since Version: 3.11.0
Source Control Link:
https://github.com/apache/cassandra/commit/5d930cc9db6cdb29c2f7f1dec5a03c5b30ab66a7
Resolution: Fixed
Status: Resolved (was: Ready to Commit)
And committed, thanks!
> SELECT JSON generates invalid JSON for the duration type
> --------------------------------------------------------
>
> Key: CASSANDRA-15075
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15075
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Syntax
> Reporter: Pekka Enberg
> Assignee: Pekka Enberg
> Priority: Normal
> Fix For: 3.11.6, 4.0
>
> Attachments:
> 0001-Fix-SELECT-JSON-formatting-for-the-duration-type.patch
>
>
> 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]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]