You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "paul cannon (Created) (JIRA)" <ji...@apache.org> on 2011/11/17 18:22:51 UTC
[jira] [Created] (CASSANDRA-3500) cqlsh ASSUME doesn't work when
using SELECT keyspace.cfname syntax
cqlsh ASSUME doesn't work when using SELECT keyspace.cfname syntax
------------------------------------------------------------------
Key: CASSANDRA-3500
URL: https://issues.apache.org/jira/browse/CASSANDRA-3500
Project: Cassandra
Issue Type: Bug
Components: Tools
Affects Versions: 1.0.3
Reporter: paul cannon
Assignee: paul cannon
Priority: Minor
Fix For: 1.0.4
After assigning an ASSUME type to some columnfamily CF in keyspace K, if a SELECT is subsequently done on CF while the session is using a different keyspace, the ASSUME does not take effect:
{noformat}
cqlsh> USE ks;
cqlsh:ks> CREATE COLUMNFAMILY cf (key int PRIMARY KEY, col int);
cqlsh:ks> INSERT INTO cf (key, col) VALUES (99, 1633837924);
cqlsh:ks> ASSUME cf(col) VALUES ARE ascii;
cqlsh:ks> SELECT * FROM cf;
KEY | col |
99 | abcd |
cqlsh:ks> USE system;
cqlsh:system> SELECT * FROM ks.cf;
KEY | col |
99 | 1633837924 |
{noformat}
the output from both {{SELECT}}s there should be the same.
--
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-3500) cqlsh ASSUME doesn't work when
using SELECT keyspace.cfname syntax
Posted by "Jonathan Ellis (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-3500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-3500:
--------------------------------------
Reviewer: brandon.williams
Labels: cqlsh (was: )
> cqlsh ASSUME doesn't work when using SELECT keyspace.cfname syntax
> ------------------------------------------------------------------
>
> Key: CASSANDRA-3500
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3500
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.0.3
> Reporter: paul cannon
> Assignee: paul cannon
> Priority: Minor
> Labels: cqlsh
> Fix For: 1.0.4
>
> Attachments: 3500.patch.txt
>
>
> After assigning an ASSUME type to some columnfamily CF in keyspace K, if a SELECT is subsequently done on CF while the session is using a different keyspace, the ASSUME does not take effect:
> {noformat}
> cqlsh> USE ks;
> cqlsh:ks> CREATE COLUMNFAMILY cf (key int PRIMARY KEY, col int);
> cqlsh:ks> INSERT INTO cf (key, col) VALUES (99, 1633837924);
> cqlsh:ks> ASSUME cf(col) VALUES ARE ascii;
> cqlsh:ks> SELECT * FROM cf;
> KEY | col |
> 99 | abcd |
> cqlsh:ks> USE system;
> cqlsh:system> SELECT * FROM ks.cf;
> KEY | col |
> 99 | 1633837924 |
> {noformat}
> the output from both {{SELECT}}s there should be the same.
--
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-3500) cqlsh ASSUME doesn't work when
using SELECT keyspace.cfname syntax
Posted by "paul cannon (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-3500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
paul cannon updated CASSANDRA-3500:
-----------------------------------
Attachment: 3500.patch.txt
> cqlsh ASSUME doesn't work when using SELECT keyspace.cfname syntax
> ------------------------------------------------------------------
>
> Key: CASSANDRA-3500
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3500
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.0.3
> Reporter: paul cannon
> Assignee: paul cannon
> Priority: Minor
> Fix For: 1.0.4
>
> Attachments: 3500.patch.txt
>
>
> After assigning an ASSUME type to some columnfamily CF in keyspace K, if a SELECT is subsequently done on CF while the session is using a different keyspace, the ASSUME does not take effect:
> {noformat}
> cqlsh> USE ks;
> cqlsh:ks> CREATE COLUMNFAMILY cf (key int PRIMARY KEY, col int);
> cqlsh:ks> INSERT INTO cf (key, col) VALUES (99, 1633837924);
> cqlsh:ks> ASSUME cf(col) VALUES ARE ascii;
> cqlsh:ks> SELECT * FROM cf;
> KEY | col |
> 99 | abcd |
> cqlsh:ks> USE system;
> cqlsh:system> SELECT * FROM ks.cf;
> KEY | col |
> 99 | 1633837924 |
> {noformat}
> the output from both {{SELECT}}s there should be the same.
--
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