You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jeremiah Jordan (JIRA)" <ji...@apache.org> on 2012/11/09 21:27:11 UTC

[jira] [Created] (CASSANDRA-4940) Truncate doesn't clear row cache

Jeremiah Jordan created CASSANDRA-4940:
------------------------------------------

             Summary: Truncate doesn't clear row cache
                 Key: CASSANDRA-4940
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4940
             Project: Cassandra
          Issue Type: Bug
          Components: Core
    Affects Versions: 1.1.6
            Reporter: Jeremiah Jordan


Truncate doesn't clear the row cache.  select * from <table> which skips the row cache returns no data, but selecting by key does.

cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
 v1 | v2 | v3
----+----+----
 16 | 17 | 18
 12 | 13 | 14
  8 |  9 | 10

cqlsh:temp> truncate temp2;
cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
 v1 | v2 | v3
----+----+----
 16 | 17 | 18
 12 | 13 | 14
  8 |  9 | 10

cqlsh:temp> select * from temp2;
cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
 v1 | v2 | v3
----+----+----
 16 | 17 | 18
 12 | 13 | 14
  8 |  9 | 10



--
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-4940) Truncate doesn't clear row cache

Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis updated CASSANDRA-4940:
--------------------------------------

    Attachment: 4940.txt

patch attached.
                
> Truncate doesn't clear row cache
> --------------------------------
>
>                 Key: CASSANDRA-4940
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4940
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Jeremiah Jordan
>            Assignee: Jonathan Ellis
>            Priority: Minor
>             Fix For: 1.1.7
>
>         Attachments: 4940.txt
>
>
> Truncate doesn't clear the row cache.  select * from <table> which skips the row cache returns no data, but selecting by key does.
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10
> cqlsh:temp> truncate temp2;
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10
> cqlsh:temp> select * from temp2;
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10

--
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] [Commented] (CASSANDRA-4940) Truncate doesn't clear row cache

Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-4940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13495271#comment-13495271 ] 

Sylvain Lebresne commented on CASSANDRA-4940:
---------------------------------------------

+1 (I've pushed a test in dtest for this)
                
> Truncate doesn't clear row cache
> --------------------------------
>
>                 Key: CASSANDRA-4940
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4940
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Jeremiah Jordan
>            Assignee: Jonathan Ellis
>            Priority: Minor
>             Fix For: 1.1.7
>
>         Attachments: 4940.txt
>
>
> Truncate doesn't clear the row cache.  select * from <table> which skips the row cache returns no data, but selecting by key does.
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10
> cqlsh:temp> truncate temp2;
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10
> cqlsh:temp> select * from temp2;
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10

--
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-4940) Truncate doesn't clear row cache

Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis resolved CASSANDRA-4940.
---------------------------------------

       Resolution: Fixed
    Fix Version/s: 1.2.0 rc1

committed
                
> Truncate doesn't clear row cache
> --------------------------------
>
>                 Key: CASSANDRA-4940
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4940
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Jeremiah Jordan
>            Assignee: Jonathan Ellis
>            Priority: Minor
>             Fix For: 1.1.7, 1.2.0 rc1
>
>         Attachments: 4940.txt
>
>
> Truncate doesn't clear the row cache.  select * from <table> which skips the row cache returns no data, but selecting by key does.
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10
> cqlsh:temp> truncate temp2;
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10
> cqlsh:temp> select * from temp2;
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10

--
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-4940) Truncate doesn't clear row cache

Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis updated CASSANDRA-4940:
--------------------------------------

             Reviewer: slebresne
             Priority: Minor  (was: Major)
    Affects Version/s:     (was: 1.1.6)
        Fix Version/s: 1.1.7
             Assignee: Jonathan Ellis
    
> Truncate doesn't clear row cache
> --------------------------------
>
>                 Key: CASSANDRA-4940
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4940
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Jeremiah Jordan
>            Assignee: Jonathan Ellis
>            Priority: Minor
>             Fix For: 1.1.7
>
>
> Truncate doesn't clear the row cache.  select * from <table> which skips the row cache returns no data, but selecting by key does.
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10
> cqlsh:temp> truncate temp2;
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10
> cqlsh:temp> select * from temp2;
> cqlsh:temp> select v1..v3 from temp2 where k in (3,2,1);
>  v1 | v2 | v3
> ----+----+----
>  16 | 17 | 18
>  12 | 13 | 14
>   8 |  9 | 10

--
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