Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Thu, 4 Apr 2013 15:01:24 +0000 (UTC)
From: "Aleksey Yeschenko (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12539805.1327517361649.107775.1365087684908@arcas>
In-Reply-To: <JIRA.12539805.1327517361649@arcas>
References: <JIRA.12539805.1327517361649@arcas>
Subject: [jira] [Updated] (CASSANDRA-3783) Add 'null' support to CQL 3.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/CASSANDRA-3783?page=3Dcom.atla=
ssian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aleksey Yeschenko updated CASSANDRA-3783:
-----------------------------------------

    Reviewer: iamaleksey
   =20
> Add 'null' support to CQL 3.0
> -----------------------------
>
>                 Key: CASSANDRA-3783
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3783
>             Project: Cassandra
>          Issue Type: Sub-task
>          Components: API
>            Reporter: Sylvain Lebresne
>            Assignee: Micha=C5=82 Michalski
>            Priority: Minor
>              Labels: cql3
>             Fix For: 1.2.4
>
>         Attachments: 3783-v2.patch, 3783-v3.patch, 3783-v4.txt, 3783-wip-=
v1.patch
>
>
> Dense composite supports adding records where only a prefix of all the co=
mponent specifying the key is defined. In other words, with:
> {noformat}
> CREATE TABLE connections (
>    userid int,
>    ip text,
>    port int,
>    protocol text,
>    time timestamp,
>    PRIMARY KEY (userid, ip, port, protocol)
> ) WITH COMPACT STORAGE
> {noformat}
> you can insert
> {noformat}
> INSERT INTO connections (userid, ip, port, time) VALUES (2, '192.168.0.1'=
, 80, 123456789);
> {noformat}
> You cannot however select that column specifically (i.e, without selectin=
g column (2, '192.168.0.1', 80, 'http') for instance).
> This ticket proposes to allow that though 'null', i.e. to allow
> {noformat}
> SELECT * FROM connections WHERE userid =3D 2 AND ip =3D '192.168.0.1' AND=
 port =3D 80 AND protocol =3D null;
> {noformat}
> It would then also make sense to support:
> {noformat}
> INSERT INTO connections (userid, ip, port, protocol, time) VALUES (2, '19=
2.168.0.1', 80, null, 123456789);
> {noformat}
> as an equivalent to the insert query above.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrato=
rs
For more information on JIRA, see: http://www.atlassian.com/software/jira