[Commits] Rev 3532: Check of deleting whole dynamic columns. in file:///home/bell/maria/bzr/work-maria-5.5-cassandra/

sanja at montyprogram.com sanja at montyprogram.com
Sun Sep 30 07:58:02 EEST 2012


At file:///home/bell/maria/bzr/work-maria-5.5-cassandra/

------------------------------------------------------------
revno: 3532
revision-id: sanja at montyprogram.com-20120930045801-0zudojh9sp9j4o45
parent: sanja at montyprogram.com-20120929130124-3ogzmjv0eekfjoml
committer: sanja at montyprogram.com
branch nick: work-maria-5.5-cassandra
timestamp: Sun 2012-09-30 07:58:01 +0300
message:
  Check of deleting whole dynamic columns.
-------------- next part --------------
=== modified file 'mysql-test/t/cassandra.test'
--- a/mysql-test/t/cassandra.test	2012-09-29 13:01:24 +0000
+++ b/mysql-test/t/cassandra.test	2012-09-30 04:58:01 +0000
@@ -644,6 +644,23 @@ insert into t1 values (1, NULL);
 delete from t1;
 DROP TABLE t1;
 
+--echo #
+--echo # strange side effect of Cassandra - remiving all columns of primary
+--echo # key removes all row.
+--echo #
+CREATE TABLE t1 (rowkey int PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) 
+ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cfd2';
+INSERT INTO t1 VALUES(2,column_create("ab","ab"));
+select rowkey, column_json(dyn) from t1;
+UPDATE t1 set dyn=NULL;
+select rowkey, column_json(dyn) from t1;
+INSERT INTO t1 VALUES(2,column_create("ab","ab"));
+select rowkey, column_json(dyn) from t1;
+UPDATE t1 set dyn="";
+select rowkey, column_json(dyn) from t1;
+delete from t1;
+DROP TABLE t1;
+
 
 ############################################################################
 ## Cassandra cleanup



More information about the commits mailing list