diff options
| author | unknown <sanja@montyprogram.com> | 2012-09-30 07:58:01 +0300 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2012-09-30 07:58:01 +0300 |
| commit | 665c93f8a79a835f3eea642a90cce752ec123bdf (patch) | |
| tree | f03df13d98b790aae5ac33a99a2a4df56fd2bc03 | |
| parent | ce8484548b2a1e55bb6e1f798732f7d3a0e0c30d (diff) | |
| download | mariadb-git-665c93f8a79a835f3eea642a90cce752ec123bdf.tar.gz | |
Check of deleting whole dynamic columns.
| -rw-r--r-- | mysql-test/t/cassandra.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/cassandra.test b/mysql-test/t/cassandra.test index 9ddd6e23d55..cf0783a0ac8 100644 --- a/mysql-test/t/cassandra.test +++ b/mysql-test/t/cassandra.test @@ -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 |