incubator-cassandra-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Prendergast ...@andrewprendergast.com>
Subject bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements
Date Sat, 02 Mar 2013 11:11:08 GMT
*DESCRIPTION*

When creating a table in all ANSI-SQL compliant RDBMS' the VARCHAR datatype
takes a numeric parameter, however this parameter is generating errors in
CQL3.

*STEPS TO REPRODUCE*

CREATE TABLE test (id BIGINT PRIMARY KEY, col1 VARCHAR(256)); // emits Bad
Request: line 1:54 mismatched input '(' expecting ')'

CREATE TABLE test (id BIGINT PRIMARY KEY, col1 VARCHAR); // this works

*SUGGESTED RESOLUTION*

The current fail-fast approach does not create the column so that the user
is 100% clear that the length parameter means nothing to NOSQL.

I would like to propose that the column length be allowed in the grammar
(but ignored by cassandra), allowing better ANSI-SQL client compatibility.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message