Return-Path: X-Original-To: apmail-cassandra-dev-archive@www.apache.org Delivered-To: apmail-cassandra-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C2D6CEBFB for ; Sat, 2 Mar 2013 18:51:20 +0000 (UTC) Received: (qmail 91761 invoked by uid 500); 2 Mar 2013 18:51:19 -0000 Delivered-To: apmail-cassandra-dev-archive@cassandra.apache.org Received: (qmail 91731 invoked by uid 500); 2 Mar 2013 18:51:19 -0000 Mailing-List: contact dev-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list dev@cassandra.apache.org Received: (qmail 91723 invoked by uid 99); 2 Mar 2013 18:51:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Mar 2013 18:51:19 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of edlinuxguru@gmail.com designates 209.85.212.180 as permitted sender) Received: from [209.85.212.180] (HELO mail-wi0-f180.google.com) (209.85.212.180) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Mar 2013 18:51:13 +0000 Received: by mail-wi0-f180.google.com with SMTP id hi8so626081wib.13 for ; Sat, 02 Mar 2013 10:50:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=WrSPOgFKCcGfj1MGyjglljLwj45j6hjD/p+VFlh60Ps=; b=RAjpacfMmb5VbQpKhYgsT2CLxuxy0qksyLIMJ55DdDnp8jw+5WOLwb5ExTAHGkXh/B 9NMqTxvX12Y7uSQqlBpsplXuhhC5jHlJoCRcydyp2TtQ0R2nbjHYHaN+TQWiasOppy7F P4CKuBbF5x2iDLvpJ5jzvxZnnGC3FCyWrBfnsXfOujDH3xxkJeB6myJZr+ILsCGjKheG GoelEl928ElG0nX+yzXnE9CanY/wRoq1j3v1lmnwN4enVhPspsGdpbHMR29BWq0leB9a PbApzKpkXNdKeO9lmbGtXY8qZAH0sNNgo2+VKrzg830W0isLnEtrVP4s4OPitj5XK9j+ Wvsg== MIME-Version: 1.0 X-Received: by 10.194.242.163 with SMTP id wr3mr23798275wjc.35.1362250253092; Sat, 02 Mar 2013 10:50:53 -0800 (PST) Received: by 10.194.61.137 with HTTP; Sat, 2 Mar 2013 10:50:53 -0800 (PST) In-Reply-To: References: Date: Sat, 2 Mar 2013 13:50:53 -0500 Message-ID: Subject: Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements From: Edward Capriolo To: dev@cassandra.apache.org Content-Type: multipart/alternative; boundary=089e013d1da86e4b7004d6f59aa6 X-Virus-Checked: Checked by ClamAV on apache.org --089e013d1da86e4b7004d6f59aa6 Content-Type: text/plain; charset=ISO-8859-1 If the syntax effectively does nothing I do not see the point of adding it. CQL is never going to be 100% compatible ANSI-SQL dialect. On Sat, Mar 2, 2013 at 12:19 PM, Michael Kjellman wrote: > Might want to create a Jira ticket at issues.apache.org instead of > submitting the bug report thru email. > > On Mar 2, 2013, at 3:11 AM, "Andrew Prendergast" > wrote: > > > *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. > > Copy, by Barracuda, helps you store, protect, and share all your amazing > > things. Start today: www.copy.com. > --089e013d1da86e4b7004d6f59aa6--