[CASSANDRA-12371] INSERT JSON - numbers not accepted for smallint and tinyint

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.2.8, 3.0.9, 3.8
• Component/s: Legacy/CQL
• Labels: lhf

Environment

Apache Cassandra 3.7 (provisioned by instaclustr.com, running on AWS)

• Severity: Low
• Since Version: 2.2.0 beta 1
• Assignee: Paweł Rychlik
• Reporter: Paweł Rychlik

Authors

Paweł Rychlik

Reviewers

Tom Hobbs

• Created: 03/Aug/16 10:02
• Updated: 16/Apr/19 09:30
• Resolved: 05/Aug/16 21:37

Description

Contrary to what is written down on http://cassandra.apache.org/doc/latest/cql/json.html#json-encoding-of-cassandra-data-types, numbers are not an accepted format for tinyints and smallints.

Steps to reproduce on CQLSH:

> create table default.test(id text PRIMARY KEY, small smallint, tiny tinyint);

> INSERT INTO default.test JSON '

{"id":"123","small":11}

';
InvalidRequest: Error from server: code=2200 [Invalid query] message="Error decoding JSON value for small: Expected a short value, but got a Integer: 11"

> INSERT INTO default.test JSON '

{"id":"123","tiny":11}

';
InvalidRequest: Error from server: code=2200 [Invalid query] message="Error decoding JSON value for tiny: Expected a byte value, but got a Integer: 11"

The good news is that when you wrap the numeric values into strings - it works like a charm.