[jira] [Commented] (CASSANDRA-2409) Add INSERT support to CQL

["Eric Evans (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-2409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13014867#comment-13014867 ] 

Eric Evans commented on CASSANDRA-2409:
---------------------------------------

I don't think this what Jonathan is after, he's looking for the equivalent of SQL's {{INSERT}}. For example:

{code:style=SQL}
INSERT INTO cf (foo, bar, baz) VALUES (1, 20 300) WHERE KEY = fnord;
{code}

> Add INSERT support to CQL
> -------------------------
>
>                 Key: CASSANDRA-2409
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2409
>             Project: Cassandra
>          Issue Type: Bug
>          Components: API
>            Reporter: Jonathan Ellis
>            Assignee: Pavel Yaskevich
>             Fix For: 0.8
>
>         Attachments: CASSANDRA-2409.patch
>
>
> There are two reasons to support INSERT:
> - It helps new users feel comfortable (everyone's first statement will be to try to INSERT something, we should make that a positive experience instead of slapping them)
> - Even though it is synonymous with update it is still useful in your code to have both to help communicate intent, similar to choosing good variable names
> The only downside is explaining how INSERT isn't a "true" insert because it doesn't error out if the row already exists -- but we already have to explain that same concept for UPDATE; the cognitive load is extremely minor.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira