You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "T Jake Luciani (Created) (JIRA)" <ji...@apache.org> on 2012/04/13 16:44:17 UTC
[jira] [Created] (CASSANDRA-4147) cqlsh doesn't accept NULL as
valid input
cqlsh doesn't accept NULL as valid input
----------------------------------------
Key: CASSANDRA-4147
URL: https://issues.apache.org/jira/browse/CASSANDRA-4147
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.0.8
Reporter: T Jake Luciani
Assignee: paul cannon
Priority: Minor
Fix For: 1.0.10
cqlsh:cfs> insert into foo (key,val1,val2)values('row2',NULL,NULL);
Bad Request: unable to make long from 'NULL'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4147) add NULL to CQL3
Posted by "paul cannon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13398636#comment-13398636 ]
paul cannon commented on CASSANDRA-4147:
----------------------------------------
This seems like a dupe of CASSANDRA-3783 then.
> add NULL to CQL3
> ----------------
>
> Key: CASSANDRA-4147
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4147
> Project: Cassandra
> Issue Type: New Feature
> Reporter: T Jake Luciani
> Priority: Minor
> Fix For: 1.1.2
>
>
> cqlsh:cfs> insert into foo (key,val1,val2)values('row2',NULL,NULL);
> Bad Request: unable to make long from 'NULL'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4147) cqlsh doesn't accept NULL as
valid input
Posted by "Jonathan Ellis (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13253445#comment-13253445 ]
Jonathan Ellis commented on CASSANDRA-4147:
-------------------------------------------
Explicitly inserting a null doesn't make much sense either; to Cassandra/CQL, null is the complete absence of a value. So we'll *return* a null if you ask for column {{foo}} and no {{foo}} exists for a given row, but I can't think of why you'd want to explicitly insert one. (And a row consisting entirely of nulls wouldn't exist at all...)
> cqlsh doesn't accept NULL as valid input
> ----------------------------------------
>
> Key: CASSANDRA-4147
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4147
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.0.8
> Reporter: T Jake Luciani
> Assignee: paul cannon
> Priority: Minor
> Fix For: 1.0.10
>
>
> cqlsh:cfs> insert into foo (key,val1,val2)values('row2',NULL,NULL);
> Bad Request: unable to make long from 'NULL'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4147) cqlsh doesn't accept NULL as
valid input
Posted by "paul cannon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13265008#comment-13265008 ]
paul cannon commented on CASSANDRA-4147:
----------------------------------------
So are you proposing to add NULL to the CQL language, or add some more parsing smarts to cqlsh?
> cqlsh doesn't accept NULL as valid input
> ----------------------------------------
>
> Key: CASSANDRA-4147
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4147
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.0.8
> Reporter: T Jake Luciani
> Assignee: paul cannon
> Priority: Minor
> Fix For: 1.0.10
>
>
> cqlsh:cfs> insert into foo (key,val1,val2)values('row2',NULL,NULL);
> Bad Request: unable to make long from 'NULL'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4147) cqlsh doesn't accept NULL as
valid input
Posted by "T Jake Luciani (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13253456#comment-13253456 ]
T Jake Luciani commented on CASSANDRA-4147:
-------------------------------------------
It's really syntactic sugar for people coming from SQL land. Internally it would just ignore it.
> cqlsh doesn't accept NULL as valid input
> ----------------------------------------
>
> Key: CASSANDRA-4147
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4147
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.0.8
> Reporter: T Jake Luciani
> Assignee: paul cannon
> Priority: Minor
> Fix For: 1.0.10
>
>
> cqlsh:cfs> insert into foo (key,val1,val2)values('row2',NULL,NULL);
> Bad Request: unable to make long from 'NULL'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-4147) add NULL to CQL3
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-4147:
--------------------------------------
Affects Version/s: (was: 1.0.8)
Fix Version/s: (was: 1.0.10)
1.1.1
Assignee: (was: paul cannon)
Issue Type: New Feature (was: Bug)
Summary: add NULL to CQL3 (was: cqlsh doesn't accept NULL as valid input)
> add NULL to CQL3
> ----------------
>
> Key: CASSANDRA-4147
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4147
> Project: Cassandra
> Issue Type: New Feature
> Reporter: T Jake Luciani
> Priority: Minor
> Fix For: 1.1.1
>
>
> cqlsh:cfs> insert into foo (key,val1,val2)values('row2',NULL,NULL);
> Bad Request: unable to make long from 'NULL'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4147) cqlsh doesn't accept NULL as
valid input
Posted by "T Jake Luciani (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13265011#comment-13265011 ]
T Jake Luciani commented on CASSANDRA-4147:
-------------------------------------------
I guess it would need to go into cql. since UPDATE table set foo = NULL where KEY = 'bar' would be a delete.
> cqlsh doesn't accept NULL as valid input
> ----------------------------------------
>
> Key: CASSANDRA-4147
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4147
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.0.8
> Reporter: T Jake Luciani
> Assignee: paul cannon
> Priority: Minor
> Fix For: 1.0.10
>
>
> cqlsh:cfs> insert into foo (key,val1,val2)values('row2',NULL,NULL);
> Bad Request: unable to make long from 'NULL'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4147) cqlsh doesn't accept NULL as
valid input
Posted by "Sylvain Lebresne (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13253441#comment-13253441 ]
Sylvain Lebresne commented on CASSANDRA-4147:
---------------------------------------------
I don't think this is specific to cqlsh, it's just that CQL doesn't know about null.
For CQL3, CASSANDRA-3783 has some plan to add some null support. For CQL2, I'm not sure it's worth bothering adding it to the language (adding it to the grammar and adding code to handle it). Unless you have a good reason to?
> cqlsh doesn't accept NULL as valid input
> ----------------------------------------
>
> Key: CASSANDRA-4147
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4147
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.0.8
> Reporter: T Jake Luciani
> Assignee: paul cannon
> Priority: Minor
> Fix For: 1.0.10
>
>
> cqlsh:cfs> insert into foo (key,val1,val2)values('row2',NULL,NULL);
> Bad Request: unable to make long from 'NULL'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (CASSANDRA-4147) add NULL to CQL3
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis resolved CASSANDRA-4147.
---------------------------------------
Resolution: Duplicate
Fix Version/s: (was: 1.1.2)
agreed.
> add NULL to CQL3
> ----------------
>
> Key: CASSANDRA-4147
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4147
> Project: Cassandra
> Issue Type: New Feature
> Reporter: T Jake Luciani
> Priority: Minor
>
> cqlsh:cfs> insert into foo (key,val1,val2)values('row2',NULL,NULL);
> Bad Request: unable to make long from 'NULL'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira