diff options
Diffstat (limited to 'mysql-test/t/cassandra.test')
| -rw-r--r-- | mysql-test/t/cassandra.test | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/mysql-test/t/cassandra.test b/mysql-test/t/cassandra.test index 80271e48d3e..0f0a1544af5 100644 --- a/mysql-test/t/cassandra.test +++ b/mysql-test/t/cassandra.test @@ -25,7 +25,7 @@ create table t1 (rowkey char(10) primary key, column1 char(10)) engine=cassandra thrift_host='localhost' keyspace='no_such_keyspace' column_family='colfam'; # No column family specified ---error ER_CANT_CREATE_TABLE +--error ER_CONNECT_TO_FOREIGN_DATA_SOURCE create table t1 (rowkey char(10) primary key, column1 char(10)) engine=cassandra thrift_host='localhost' keyspace='no_such_keyspace'; @@ -49,13 +49,19 @@ create columnfamily cf1 ( pk varchar primary key, data1 varchar, data2 bigint); ############################################################################ # Now, create a table for real and insert data -create table t1 (rowkey char(36) primary key, data1 varchar(60), data2 bigint) engine=cassandra +create table t1 (rowkey varchar(36) primary key, data1 varchar(60), data2 bigint) engine=cassandra thrift_host='localhost' keyspace='mariadbtest2' column_family='cf1'; +select * from t1; insert into t1 values ('rowkey10', 'data1-value', 123456); insert into t1 values ('rowkey11', 'data1-value2', 34543); +insert into t1 values ('rowkey12', 'data1-value3', 454); select * from t1; +explain +select * from t1 where rowkey='rowkey11'; +select * from t1 where rowkey='rowkey11'; + # Check if deletion works delete from t1; select * from t1; |