Querying a Cassandra table on a server with query cache enabled is likely to cause problems

cqlsh:manual_test> create columnfamily cf1 ( rowkey int primary key, a int );

drop table if exists t1, t2;

create table t1 (rowkey int primary key, a int) engine=cassandra keyspace='manual_test' column_family='cf1';

create table t2 like t1;

set global query_cache_size=1024*1024;

select * from t1;

# Empty set (0.01 sec)

insert into t2 values (1,1);

select * from t1;

# Empty set (0.00 sec)

select sql_no_cache * from t1;

# +--------+------+

# | rowkey | a    |

# +--------+------+

# |      1 |    1 |

# +--------+------+

# 1 row in set (0.01 sec)

revision-id: psergey@askmonty.org-20121224043622-xn8g8y3vhtu1lb3w

revno: 3459

branch: 10.0-base-cassandra