You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Edward Capriolo (JIRA)" <ji...@apache.org> on 2012/11/14 06:00:12 UTC
[jira] [Created] (CASSANDRA-4961) CQL3 accepts TTL on collection
types but does nothing
Edward Capriolo created CASSANDRA-4961:
------------------------------------------
Summary: CQL3 accepts TTL on collection types but does nothing
Key: CASSANDRA-4961
URL: https://issues.apache.org/jira/browse/CASSANDRA-4961
Project: Cassandra
Issue Type: Bug
Reporter: Edward Capriolo
It seems like CQL will accept a TTL on a collection column but do nothing with it. Am I using the syntax wrong?
{quote}
cqlsh:movies> INSERT INTO VIDEOS (videoid, videoname, tagasset) values ('99051fe9-6a9c-46c2-b949-38ef78858dd0','My funny cat',{'piano'}) USING TIMESTAMP 11 AND TTL 1;
cqlsh:movies> select * from videos;
videoid | videoname | description | tagasset | tags | upload_date | username
--------------------------------------+--------------+-------------------------------------------+----------+----------------+--------------------------+----------
99051fe9-6a9c-46c2-b949-38ef78858dd0 | My funny cat | My cat likes to play the piano! So funny. | {piano} | cats,piano,lol | 2012-06-01 08:00:00+0000 | ctodd
cqlsh:movies> select * from videos;
videoid | videoname | description | tagasset | tags | upload_date | username
--------------------------------------+--------------+-------------------------------------------+----------+----------------+--------------------------+----------
99051fe9-6a9c-46c2-b949-38ef78858dd0 | My funny cat | My cat likes to play the piano! So funny. | {piano} | cats,piano,lol | 2012-06-01 08:00:00+0000 | ctodd
{quote}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (CASSANDRA-4961) CQL3 accepts TTL on collection
types but does nothing
Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brandon Williams reassigned CASSANDRA-4961:
-------------------------------------------
Assignee: Sylvain Lebresne
> CQL3 accepts TTL on collection types but does nothing
> -----------------------------------------------------
>
> Key: CASSANDRA-4961
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4961
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0 beta 2
> Reporter: Edward Capriolo
> Assignee: Sylvain Lebresne
>
> It seems like CQL will accept a TTL on a collection column but do nothing with it. Am I using the syntax wrong?
> {quote}
> cqlsh:movies> INSERT INTO VIDEOS (videoid, videoname, tagasset) values ('99051fe9-6a9c-46c2-b949-38ef78858dd0','My funny cat',{'piano'}) USING TIMESTAMP 11 AND TTL 1;
> cqlsh:movies> select * from videos;
> videoid | videoname | description | tagasset | tags | upload_date | username
> --------------------------------------+--------------+-------------------------------------------+----------+----------------+--------------------------+----------
> 99051fe9-6a9c-46c2-b949-38ef78858dd0 | My funny cat | My cat likes to play the piano! So funny. | {piano} | cats,piano,lol | 2012-06-01 08:00:00+0000 | ctodd
> cqlsh:movies> select * from videos;
> videoid | videoname | description | tagasset | tags | upload_date | username
> --------------------------------------+--------------+-------------------------------------------+----------+----------------+--------------------------+----------
> 99051fe9-6a9c-46c2-b949-38ef78858dd0 | My funny cat | My cat likes to play the piano! So funny. | {piano} | cats,piano,lol | 2012-06-01 08:00:00+0000 | ctodd
> {quote}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-4961) CQL3 accepts TTL on collection
types but does nothing
Posted by "Edward Capriolo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Capriolo updated CASSANDRA-4961:
---------------------------------------
Affects Version/s: 1.2.0 beta 2
> CQL3 accepts TTL on collection types but does nothing
> -----------------------------------------------------
>
> Key: CASSANDRA-4961
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4961
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0 beta 2
> Reporter: Edward Capriolo
>
> It seems like CQL will accept a TTL on a collection column but do nothing with it. Am I using the syntax wrong?
> {quote}
> cqlsh:movies> INSERT INTO VIDEOS (videoid, videoname, tagasset) values ('99051fe9-6a9c-46c2-b949-38ef78858dd0','My funny cat',{'piano'}) USING TIMESTAMP 11 AND TTL 1;
> cqlsh:movies> select * from videos;
> videoid | videoname | description | tagasset | tags | upload_date | username
> --------------------------------------+--------------+-------------------------------------------+----------+----------------+--------------------------+----------
> 99051fe9-6a9c-46c2-b949-38ef78858dd0 | My funny cat | My cat likes to play the piano! So funny. | {piano} | cats,piano,lol | 2012-06-01 08:00:00+0000 | ctodd
> cqlsh:movies> select * from videos;
> videoid | videoname | description | tagasset | tags | upload_date | username
> --------------------------------------+--------------+-------------------------------------------+----------+----------------+--------------------------+----------
> 99051fe9-6a9c-46c2-b949-38ef78858dd0 | My funny cat | My cat likes to play the piano! So funny. | {piano} | cats,piano,lol | 2012-06-01 08:00:00+0000 | ctodd
> {quote}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (CASSANDRA-4961) CQL3 accepts TTL on collection
types but does nothing
Posted by "Edward Capriolo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Capriolo resolved CASSANDRA-4961.
----------------------------------------
Resolution: Won't Fix
My mistake. It works fine.
> CQL3 accepts TTL on collection types but does nothing
> -----------------------------------------------------
>
> Key: CASSANDRA-4961
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4961
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0 beta 2
> Reporter: Edward Capriolo
>
> It seems like CQL will accept a TTL on a collection column but do nothing with it. Am I using the syntax wrong?
> {quote}
> cqlsh:movies> INSERT INTO VIDEOS (videoid, videoname, tagasset) values ('99051fe9-6a9c-46c2-b949-38ef78858dd0','My funny cat',{'piano'}) USING TIMESTAMP 11 AND TTL 1;
> cqlsh:movies> select * from videos;
> videoid | videoname | description | tagasset | tags | upload_date | username
> --------------------------------------+--------------+-------------------------------------------+----------+----------------+--------------------------+----------
> 99051fe9-6a9c-46c2-b949-38ef78858dd0 | My funny cat | My cat likes to play the piano! So funny. | {piano} | cats,piano,lol | 2012-06-01 08:00:00+0000 | ctodd
> cqlsh:movies> select * from videos;
> videoid | videoname | description | tagasset | tags | upload_date | username
> --------------------------------------+--------------+-------------------------------------------+----------+----------------+--------------------------+----------
> 99051fe9-6a9c-46c2-b949-38ef78858dd0 | My funny cat | My cat likes to play the piano! So funny. | {piano} | cats,piano,lol | 2012-06-01 08:00:00+0000 | ctodd
> {quote}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (CASSANDRA-4961) CQL3 accepts TTL on collection
types but does nothing
Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brandon Williams reassigned CASSANDRA-4961:
-------------------------------------------
Assignee: (was: Sylvain Lebresne)
> CQL3 accepts TTL on collection types but does nothing
> -----------------------------------------------------
>
> Key: CASSANDRA-4961
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4961
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0 beta 2
> Reporter: Edward Capriolo
>
> It seems like CQL will accept a TTL on a collection column but do nothing with it. Am I using the syntax wrong?
> {quote}
> cqlsh:movies> INSERT INTO VIDEOS (videoid, videoname, tagasset) values ('99051fe9-6a9c-46c2-b949-38ef78858dd0','My funny cat',{'piano'}) USING TIMESTAMP 11 AND TTL 1;
> cqlsh:movies> select * from videos;
> videoid | videoname | description | tagasset | tags | upload_date | username
> --------------------------------------+--------------+-------------------------------------------+----------+----------------+--------------------------+----------
> 99051fe9-6a9c-46c2-b949-38ef78858dd0 | My funny cat | My cat likes to play the piano! So funny. | {piano} | cats,piano,lol | 2012-06-01 08:00:00+0000 | ctodd
> cqlsh:movies> select * from videos;
> videoid | videoname | description | tagasset | tags | upload_date | username
> --------------------------------------+--------------+-------------------------------------------+----------+----------------+--------------------------+----------
> 99051fe9-6a9c-46c2-b949-38ef78858dd0 | My funny cat | My cat likes to play the piano! So funny. | {piano} | cats,piano,lol | 2012-06-01 08:00:00+0000 | ctodd
> {quote}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira