diff options
Diffstat (limited to 'mysql-test/suite/plugins')
| -rw-r--r-- | mysql-test/suite/plugins/r/cassandra.result | 636 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/r/cassandra_qcache.result | 16 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/r/cassandra_reinstall.result | 14 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/r/feedback_plugin_load.result | 12 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/r/feedback_plugin_send.result | 12 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/suite.pm | 9 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/t/cassandra.opt | 1 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/t/cassandra.test | 758 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/t/cassandra_qcache.opt | 1 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/t/cassandra_qcache.test | 59 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/t/cassandra_reinstall.test | 16 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/t/processlist.test | 2 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/t/test_sql_service.test | 1 |
13 files changed, 13 insertions, 1524 deletions
diff --git a/mysql-test/suite/plugins/r/cassandra.result b/mysql-test/suite/plugins/r/cassandra.result deleted file mode 100644 index 67ae2cab708..00000000000 --- a/mysql-test/suite/plugins/r/cassandra.result +++ /dev/null @@ -1,636 +0,0 @@ -drop table if exists t0, t1; -# -# Check variables and status counters -# -show status like 'cassandra%'; -Variable_name Value -Cassandra_row_inserts 0 -Cassandra_row_insert_batches 0 -Cassandra_multiget_keys_scanned 0 -Cassandra_multiget_reads 0 -Cassandra_multiget_rows_read 0 -Cassandra_network_exceptions 0 -Cassandra_timeout_exceptions 0 -Cassandra_unavailable_exceptions 0 -show variables like 'cassandra%'; -Variable_name Value -cassandra_default_thrift_host -cassandra_failure_retries 3 -cassandra_insert_batch_size 100 -cassandra_multiget_batch_size 100 -cassandra_read_consistency ONE -cassandra_rnd_batch_size 10000 -cassandra_write_consistency ONE -# -# Test various errors on table creation. -# -create table t1 (a int) engine=cassandra -thrift_host='localhost' keyspace='foo' column_family='colfam'; -ERROR 42000: This table type requires a primary key -create table t1 (a int primary key, b int) engine=cassandra -thrift_host='localhost' keyspace='foo' column_family='colfam'; -ERROR HY000: Unable to connect to foreign data source: Default TException. [Keyspace foo does not exist] -create table t1 (rowkey char(10) primary key, column1 char(10)) engine=cassandra -thrift_host='127.0.0.2' keyspace='foo' column_family='colfam'; -ERROR HY000: Unable to connect to foreign data source: connect() failed: Connection refused [1] -create table t1 (rowkey char(10) primary key, column1 char(10)) engine=cassandra -thrift_host='localhost' keyspace='no_such_keyspace' column_family='colfam'; -ERROR HY000: Unable to connect to foreign data source: Default TException. [Keyspace no_such_keyspace does not exist] -create table t1 (rowkey char(10) primary key, column1 char(10)) engine=cassandra -thrift_host='localhost' keyspace='no_such_keyspace'; -ERROR HY000: Unable to connect to foreign data source: keyspace and column_family table options must be specified -# Now, create a table for real and insert data -create table t1 (pk varchar(36) primary key, data1 varchar(60), data2 bigint) engine=cassandra -thrift_host='localhost' keyspace='mariadbtest2' column_family='cf1'; -# Just in case there were left-overs from previous: -delete from t1; -select * from t1; -pk data1 data2 -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; -pk data1 data2 -rowkey12 data1-value3 454 -rowkey10 data1-value 123456 -rowkey11 data1-value2 34543 -explain -select * from t1 where pk='rowkey11'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 const PRIMARY PRIMARY 38 const 1 -select * from t1 where pk='rowkey11'; -pk data1 data2 -rowkey11 data1-value2 34543 -delete from t1 where pk='rowkey11'; -select * from t1; -pk data1 data2 -rowkey12 data1-value3 454 -rowkey10 data1-value 123456 -delete from t1; -select * from t1; -pk data1 data2 -# -# A query with filesort (check that table_flags() & HA_REC_NOT_IN_SEQ, -# also check ::rnd_pos() -# -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 order by data2; -pk data1 data2 -rowkey12 data1-value3 454 -rowkey11 data1-value2 34543 -rowkey10 data1-value 123456 -delete from t1; -drop table t1; -# -# MDEV-476: Cassandra: Server crashes in calculate_key_len on DELETE with ORDER BY -# -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; -INSERT INTO t1 VALUES (1,1),(2,2); -DELETE FROM t1 ORDER BY a LIMIT 1; -DROP TABLE t1; -# -# Batched INSERT -# -show variables like 'cassandra_insert_batch_size'; -Variable_name Value -cassandra_insert_batch_size 100 -show status like 'cassandra_row_insert%'; -Variable_name Value -Cassandra_row_inserts 8 -Cassandra_row_insert_batches 7 -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; -delete from t1; -INSERT INTO t1 VALUES (1,1),(2,2); -DELETE FROM t1 ORDER BY a LIMIT 1; -DROP TABLE t1; -show status like 'cassandra_row_insert%'; -Variable_name Value -Cassandra_row_inserts 10 -Cassandra_row_insert_batches 8 -# FLUSH STATUS doesn't work for our variables, just like with InnoDB. -flush status; -show status like 'cassandra_row_insert%'; -Variable_name Value -Cassandra_row_inserts 10 -Cassandra_row_insert_batches 8 -# -# Batched Key Access -# -# Control variable (we are not yet able to make use of MRR's buffer) -show variables like 'cassandra_multi%'; -Variable_name Value -cassandra_multiget_batch_size 100 -# MRR-related status variables: -show status like 'cassandra_multi%'; -Variable_name Value -Cassandra_multiget_keys_scanned 0 -Cassandra_multiget_reads 0 -Cassandra_multiget_rows_read 0 -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; -delete from t1; -INSERT INTO t1 VALUES (0,0),(1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9); -set @tmp_jcl=@@join_cache_level; -set join_cache_level=8; -explain select * from t1 A, t1 B where B.rowkey=A.a; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE A ALL NULL NULL NULL NULL 1000 Using where -1 SIMPLE B eq_ref PRIMARY PRIMARY 8 test.A.a 1 Using join buffer (flat, BKAH join); multiget_slice -select * from t1 A, t1 B where B.rowkey=A.a; -rowkey a rowkey a -0 0 0 0 -1 1 1 1 -2 2 2 2 -3 3 3 3 -4 4 4 4 -5 5 5 5 -6 6 6 6 -7 7 7 7 -8 8 8 8 -9 9 9 9 -show status like 'cassandra_multi%'; -Variable_name Value -Cassandra_multiget_keys_scanned 10 -Cassandra_multiget_reads 1 -Cassandra_multiget_rows_read 10 -insert into t1 values(1, 8); -insert into t1 values(3, 8); -insert into t1 values(5, 8); -insert into t1 values(7, 8); -select * from t1 A, t1 B where B.rowkey=A.a; -rowkey a rowkey a -0 0 0 0 -2 2 2 2 -4 4 4 4 -6 6 6 6 -1 8 8 8 -7 8 8 8 -8 8 8 8 -5 8 8 8 -3 8 8 8 -9 9 9 9 -show status like 'cassandra_multi%'; -Variable_name Value -Cassandra_multiget_keys_scanned 16 -Cassandra_multiget_reads 2 -Cassandra_multiget_rows_read 16 -delete from t1; -drop table t1; -# -# MDEV-480: TRUNCATE TABLE on a Cassandra table does not remove rows -# -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; -INSERT INTO t1 VALUES (0,0),(1,1),(2,2); -truncate table t1; -select * from t1; -rowkey a -drop table t1; -# -# MDEV-494, part #1: phantom row for big full-scan selects -# -create table t0 (a int); -insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; -insert into t1 select A.a + 10 * B.a + 100*C.a, 12345 from t0 A, t0 B, t0 C; -select count(*) from t1; -count(*) -1000 -select count(*) from t1 where a=12345; -count(*) -1000 -delete from t1; -drop table t1; -drop table t0; -# 32-bit INT type support -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, intcol INT) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf3'; -insert into t1 values (10,10); -insert into t1 values (12,12); -delete from t1; -drop table t1; -# -# Try accessing column family w/o explicitly defined columns -# -CREATE TABLE t1 (my_primary_key varchar(10) PRIMARY KEY) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf10'; -ERROR HY000: Internal error: target column family has no key_alias defined, PRIMARY KEY column must be named 'rowkey' -CREATE TABLE t1 (rowkey varchar(10) PRIMARY KEY) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf10'; -DROP TABLE t1; -# -# Timestamp datatype support -# -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, datecol timestamp) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf4'; -delete from t2; -insert into t2 values (1, '2012-08-29 01:23:45'); -select * from t2; -rowkey datecol -1 2012-08-29 01:23:45 -delete from t2; -# MDEV-498: Cassandra: Inserting a timestamp does not work on a 32-bit system -INSERT INTO t2 VALUES (10,'2012-12-12 12:12:12'); -SELECT * FROM t2; -rowkey datecol -10 2012-12-12 12:12:12 -delete from t2; -# -# (no MDEV#) Check that insert counters work correctly -# -create table t0 (a int); -insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); -set cassandra_insert_batch_size=10; -insert into t2 select A.a+10*B.a, now() from t0 A, t0 B; -inserts insert_batches -100 10 -set cassandra_insert_batch_size=1; -insert into t2 select A.a+10*B.a+100, now() from t0 A, t0 B; -inserts insert_batches -100 100 -delete from t2; -drop table t2; -drop table t0; -# -# UUID datatype support -# -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol char(36)) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -delete from t2; -insert into t2 values(1,'9b5658dc-f32f-11e1-94cd-f46d046e9f09'); -insert into t2 values(2,'not-an-uuid'); -ERROR 22003: Out of range value for column 'uuidcol' at row 1 -insert into t2 values(3,'9b5658dc-f32f-11e1=94cd-f46d046e9f09'); -ERROR 22003: Out of range value for column 'uuidcol' at row 1 -insert into t2 values(4,'9b5658dc-fzzf-11e1-94cd-f46d046e9f09'); -ERROR 22003: Out of range value for column 'uuidcol' at row 1 -insert into t2 values -(5,'9b5658dc-f11f-11e1-94cd-f46d046e9f09'), -(6,'9b5658dc-f11f011e1-94cd-f46d046e9f09'); -ERROR 22003: Out of range value for column 'uuidcol' at row 2 -select * from t2; -rowkey uuidcol -1 9b5658dc-f32f-11e1-94cd-f46d046e9f09 -5 9b5658dc-f11f-11e1-94cd-f46d046e9f09 -delete from t2; -drop table t2; -CREATE TABLE t2 (rowkey char(36) PRIMARY KEY, col1 int) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf6'; -delete from t2; -insert into t2 values('9b5658dc-f32f-11e1-94cd-f46d046e9f09', 1234); -insert into t2 values('not-an-uuid', 563); -ERROR 22003: Out of range value for column 'rowkey' at row 1 -select * from t2; -rowkey col1 -9b5658dc-f32f-11e1-94cd-f46d046e9f09 1234 -delete from t2; -drop table t2; -# -# boolean datatype support -# -CREATE TABLE t2 (rowkey int PRIMARY KEY, boolcol bool) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf7'; -insert into t2 values (0, 0); -insert into t2 values (1, 1); -select * from t2; -rowkey boolcol -0 0 -1 1 -delete from t2; -drop table t2; -# -# Counter datatype support (read-only) -# -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, countercol bigint) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf8'; -select * from t2; -rowkey countercol -cnt1 1 -cnt2 100 -drop table t2; -# -# Check that @@cassandra_default_thrift_host works -# -show variables like 'cassandra_default_thrift_host'; -Variable_name Value -cassandra_default_thrift_host -set @tmp=@@cassandra_default_thrift_host; -set cassandra_default_thrift_host='localhost'; -ERROR HY000: Variable 'cassandra_default_thrift_host' is a GLOBAL variable and should be set with SET GLOBAL -set global cassandra_default_thrift_host='localhost'; -# Try creating a table without specifying thrift_host: -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, countercol bigint) ENGINE=CASSANDRA -keyspace='mariadbtest2' column_family = 'cf8'; -select * from t2; -rowkey countercol -cnt1 1 -cnt2 100 -drop table t2; -set global cassandra_default_thrift_host=@tmp; -# -# Consistency settings -# -show variables like 'cassandra_%consistency'; -Variable_name Value -cassandra_read_consistency ONE -cassandra_write_consistency ONE -set @tmp=@@cassandra_write_consistency; -# Unfortunately, there is no easy way to check if setting have the effect.. -set cassandra_write_consistency='ONE'; -set cassandra_write_consistency='QUORUM'; -set cassandra_write_consistency='LOCAL_QUORUM'; -set cassandra_write_consistency='EACH_QUORUM'; -set cassandra_write_consistency='ALL'; -set cassandra_write_consistency='ANY'; -set cassandra_write_consistency='TWO'; -set cassandra_write_consistency='THREE'; -set cassandra_write_consistency=@tmp; -# -# varint datatype support -# -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, varint_col varbinary(32)) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf9'; -select rowkey, hex(varint_col) from t2; -rowkey hex(varint_col) -val-01 01 -val-0x123456 123456 -val-0x12345678 12345678 -drop table t2; -# now, let's check what happens when MariaDB's column is not wide enough: -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, varint_col varbinary(2)) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf9'; -select rowkey, hex(varint_col) from t2; -ERROR HY000: Internal error: Unable to convert value for field `varint_col` from Cassandra's data format. Source data is 4 bytes, 0x12345678 -drop table t2; -# -# Decimal datatype support -# -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, decimal_col varbinary(32)) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf11'; -select rowkey, hex(decimal_col) from t2; -rowkey hex(decimal_col) -val_1.5 000000010F -val_0.5 0000000105 -val_1234 0000000004D2 -drop table t2; -# -# Mapping TIMESTAMP -> int64 -# -set @save_tz= @@time_zone; -set time_zone='UTC'; -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, datecol timestamp) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf4'; -insert into t2 values (1, '2012-08-29 01:23:45'); -INSERT INTO t2 VALUES (10,'2012-08-29 01:23:46'); -drop table t2; -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, datecol bigint) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf4'; -select * from t2; -rowkey datecol -1 1346203425000 -10 1346203426000 -delete from t2; -drop table t2; -set time_zone=@save_tz; -# -# Check whether changing parameters with ALTER TABLE works. -# -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, decimal_col varbinary(32)) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf11'; -drop table t2; -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, decimal_col varbinary(32)) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf11'; -alter table t2 column_family='cf12'; -Writes made during ALTER TABLE -0 -drop table t2; -# -# UPDATE command support -# -create table t1 (pk varchar(36) primary key, data1 varchar(60), data2 bigint) engine=cassandra -thrift_host='localhost' keyspace='mariadbtest2' column_family='cf1'; -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; -pk data1 data2 -rowkey12 data1-value3 454 -rowkey10 data1-value 123456 -rowkey11 data1-value2 34543 -update t1 set data1='updated-1' where pk='rowkey11'; -select * from t1; -pk data1 data2 -rowkey12 data1-value3 454 -rowkey10 data1-value 123456 -rowkey11 updated-1 34543 -update t1 set pk='new-rowkey12' where pk='rowkey12'; -select * from t1; -pk data1 data2 -rowkey10 data1-value 123456 -new-rowkey12 data1-value3 454 -rowkey11 updated-1 34543 -delete from t1; -drop table t1; -# -# Dynamic columns support -# -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol blob DYNAMIC_COLUMN_STORAGE=1) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -drop table t2; -#error: dynamic column is not a blob -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol char(36) DYNAMIC_COLUMN_STORAGE=1) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -ERROR 42000: Incorrect column specifier for column 'uuidcol' -#error: double dynamic column -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol blob DYNAMIC_COLUMN_STORAGE=1, textcol blob DYNAMIC_COLUMN_STORAGE=1) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -ERROR 42000: Incorrect column specifier for column 'textcol' -# -# Dynamic column read -# -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol char(36)) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -delete from t2; -insert into t2 values(1,'9b5658dc-f32f-11e1-94cd-f46d046e9f09'); -insert into t2 values(2,'9b5658dc-f32f-11e1-94cd-f46d046e9f0a'); -drop table t2; -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -select rowkey, column_list(dyn), column_get(dyn, 'uuidcol' as char) from t2; -rowkey column_list(dyn) column_get(dyn, 'uuidcol' as char) -1 `uuidcol` 9b5658dc-f32f-11e1-94cd-f46d046e9f09 -2 `uuidcol` 9b5658dc-f32f-11e1-94cd-f46d046e9f0a -drop table t2; -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol char(36)) ENGINE=CASSANDRA -thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -delete from t2; -drop table t2; -# -# Dynamic column insert -# -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -insert into t2 values (1, column_create("dyn1", 1, "dyn2", "two")); -select rowkey, column_json(dyn) from t2; -rowkey column_json(dyn) -1 {"dyn1":"1","dyn2":"two"} -delete from t2; -drop table t2; -# bigint -CREATE TABLE t1 (rowkey bigint PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; -insert into t1 values (1, column_create("dyn1", 1, "dyn2", "two", 'a', 254324)); -insert into t1 values (2, column_create("dyn1", 1, "dyn2", "two", 'a', 2543)); -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"a":254324,"dyn1":"1","dyn2":"two"} -2 {"a":2543,"dyn1":"1","dyn2":"two"} -delete from t1; -drop table t1; -# int -CREATE TABLE t1 (rowkey bigint PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf3'; -insert into t1 values (1, column_create("dyn1", 1, "dyn2", "two", 'intcol', 254324)); -insert into t1 values (2, column_create("dyn1", 1, "dyn2", "two", 'intcol', 2543)); -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"dyn1":"1","dyn2":"two","intcol":254324} -2 {"dyn1":"1","dyn2":"two","intcol":2543} -delete from t1; -drop table t1; -# timestamp -CREATE TABLE t1 (rowkey bigint PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf4'; -insert into t1 values (1, column_create("dyn1", 1, "dyn2", "two", 'datecol', 254324)); -insert into t1 values (2, column_create("dyn1", 1, "dyn2", "two", 'datecol', 2543)); -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"dyn1":"1","dyn2":"two","datecol":254324} -2 {"dyn1":"1","dyn2":"two","datecol":2543} -delete from t1; -drop table t1; -# boolean -CREATE TABLE t1 (rowkey int PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf7'; -insert into t1 values (1, column_create("dyn1", 1, "dyn2", "two", 'boolcol', 254324)); -insert into t1 values (2, column_create("dyn1", 1, "dyn2", "two", 'boolcol', 0)); -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"dyn1":"1","dyn2":"two","boolcol":1} -2 {"dyn1":"1","dyn2":"two","boolcol":0} -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"dyn1":"1","dyn2":"two","boolcol":1} -2 {"dyn1":"1","dyn2":"two","boolcol":0} -update t1 set dyn=column_add(dyn, "dyn2", null, "dyn3", "3"); -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"dyn1":"1","dyn3":"3","boolcol":1} -2 {"dyn1":"1","dyn3":"3","boolcol":0} -update t1 set dyn=column_add(dyn, "dyn1", null) where rowkey= 1; -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"dyn3":"3","boolcol":1} -2 {"dyn1":"1","dyn3":"3","boolcol":0} -update t1 set dyn=column_add(dyn, "dyn3", null, "a", "ddd"); -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"a":"ddd","boolcol":1} -2 {"a":"ddd","dyn1":"1","boolcol":0} -update t1 set dyn=column_add(dyn, "12345678901234", "ddd"); -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"a":"ddd","boolcol":1,"12345678901234":"ddd"} -2 {"a":"ddd","dyn1":"1","boolcol":0,"12345678901234":"ddd"} -update t1 set dyn=column_add(dyn, "12345678901234", null); -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"a":"ddd","boolcol":1} -2 {"a":"ddd","dyn1":"1","boolcol":0} -update t1 set dyn=column_add(dyn, 'boolcol', null) where rowkey= 2; -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"a":"ddd","boolcol":1} -2 {"a":"ddd","dyn1":"1"} -update t1 set rowkey= 3, dyn=column_add(dyn, "dyn1", null, 'boolcol', 0) where rowkey= 2; -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -1 {"a":"ddd","boolcol":1} -3 {"a":"ddd","boolcol":0} -delete from t1; -drop table t1; -CREATE TABLE t1 (rowkey varchar(10) PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cfd1'; -select * from t1; -ERROR HY000: Internal error: Unable to convert value for field `dyn` from Cassandra's data format. Name length exceed limit of 16383: 'very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_v -drop table t1; -CREATE TABLE t1 (rowkey int PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) -ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cfd2'; -DELETE FROM t1; -insert into t1 values (1, column_create("dyn", 1)); -select rowkey, column_list(dyn) from t1; -rowkey column_list(dyn) -1 `dyn` -delete from t1; -DROP TABLE t1; -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 (1,'9b5658dc-f32f-11e1-94cd-f46d046e9f0a'); -ERROR HY000: Encountered illegal format of dynamic column string -delete from t1; -DROP TABLE t1; -# -# MDEV-565: Server crashes in ha_cassandra::write_row on -# inserting NULL into a dynamic column -# -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 (1, NULL); -delete from t1; -DROP TABLE t1; -# -# strange side effect of Cassandra - remiving all columns of primary -# key removes all row. -# -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; -rowkey column_json(dyn) -2 {"ab":"ab"} -UPDATE t1 set dyn=NULL; -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -INSERT INTO t1 VALUES(2,column_create("ab","ab")); -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -2 {"ab":"ab"} -UPDATE t1 set dyn=""; -select rowkey, column_json(dyn) from t1; -rowkey column_json(dyn) -delete from t1; -DROP TABLE t1; -# -# MDEV-4005 #Server crashes on creating a Cassandra table -# with a mix of static and dynamic columns -# -DROP TABLE IF EXISTS t1, t2; -CREATE TABLE t1 ( -pk int primary key, -col_int int, -dyncol blob DYNAMIC_COLUMN_STORAGE=yes -) ENGINE=cassandra keyspace='bug' thrift_host = '127.0.0.1' column_family='cf1'; -drop table t1; -# -# MDEV-4000: Mapping between Cassandra blob (BytesType) and MySQL BLOB does not work -# -create table t1 (rowkey int primary key, b blob ) ENGINE=CASSANDRA thrift_host = '127.0.0.1' `keyspace`='mariadbtest2' `column_family`='cf13'; -insert into t1 values (1, 'fooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo-bar'); -insert into t1 values (2, 'qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq-baz'); -select * from t1; -rowkey b -1 fooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo-bar -2 qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq-baz -drop table t1; -# -# MDEV-4001: Cassandra: server crashes in ha_cassandra::end_bulk_insert on INSERT .. SELECT with a non-existing column -# -create table t1 (rowkey int primary key, a int) ENGINE=cassandra thrift_host='127.0.0.1' keyspace='mariadbtest2' column_family='cf14'; -insert into t1 (a) select b from t1; -ERROR 42S22: Unknown column 'b' in 'field list' -drop table t1; diff --git a/mysql-test/suite/plugins/r/cassandra_qcache.result b/mysql-test/suite/plugins/r/cassandra_qcache.result deleted file mode 100644 index 32e9db8b817..00000000000 --- a/mysql-test/suite/plugins/r/cassandra_qcache.result +++ /dev/null @@ -1,16 +0,0 @@ -drop table if exists t1, t2; -create table t1 (rowkey int primary key, a int) engine=cassandra -thrift_host='localhost' keyspace='mariadbtest2' column_family='cf1'; -create table t2 like t1; -set global query_cache_size=1024*1024; -select * from t1; -rowkey a -insert into t2 values (1,1); -select * from t1; -rowkey a -1 1 -select sql_no_cache * from t1; -rowkey a -1 1 -drop table t1,t2; -set global QUERY_CACHE_SIZE=0; diff --git a/mysql-test/suite/plugins/r/cassandra_reinstall.result b/mysql-test/suite/plugins/r/cassandra_reinstall.result deleted file mode 100644 index f4874894f70..00000000000 --- a/mysql-test/suite/plugins/r/cassandra_reinstall.result +++ /dev/null @@ -1,14 +0,0 @@ -install soname 'ha_cassandra'; -select plugin_name,plugin_status,plugin_library from information_schema.plugins where plugin_name = 'cassandra'; -plugin_name plugin_status plugin_library -CASSANDRA ACTIVE ha_cassandra.so -uninstall plugin cassandra; -select plugin_name,plugin_status,plugin_library from information_schema.plugins where plugin_name = 'cassandra'; -plugin_name plugin_status plugin_library -install soname 'ha_cassandra'; -select plugin_name,plugin_status,plugin_library from information_schema.plugins where plugin_name = 'cassandra'; -plugin_name plugin_status plugin_library -CASSANDRA ACTIVE ha_cassandra.so -uninstall plugin cassandra; -select plugin_name,plugin_status,plugin_library from information_schema.plugins where plugin_name = 'cassandra'; -plugin_name plugin_status plugin_library diff --git a/mysql-test/suite/plugins/r/feedback_plugin_load.result b/mysql-test/suite/plugins/r/feedback_plugin_load.result index 4323dcce0a6..f31c7325ca1 100644 --- a/mysql-test/suite/plugins/r/feedback_plugin_load.result +++ b/mysql-test/suite/plugins/r/feedback_plugin_load.result @@ -21,22 +21,22 @@ ORDER BY VARIABLE_NAME; VARIABLE_VALUE>0 VARIABLE_NAME 1 Collation used binary 1 Collation used latin1_swedish_ci +1 Collation used utf8mb3_bin +1 Collation used utf8mb3_general_ci 1 Collation used utf8mb4_bin -1 Collation used utf8_bin -1 Collation used utf8_general_ci prepare stmt from "SELECT VARIABLE_VALUE>0, VARIABLE_NAME FROM INFORMATION_SCHEMA.FEEDBACK WHERE VARIABLE_NAME LIKE 'Collation used %' ORDER BY VARIABLE_NAME"; execute stmt; VARIABLE_VALUE>0 VARIABLE_NAME 1 Collation used binary 1 Collation used latin1_swedish_ci +1 Collation used utf8mb3_bin +1 Collation used utf8mb3_general_ci 1 Collation used utf8mb4_bin -1 Collation used utf8_bin -1 Collation used utf8_general_ci execute stmt; VARIABLE_VALUE>0 VARIABLE_NAME 1 Collation used binary 1 Collation used latin1_swedish_ci +1 Collation used utf8mb3_bin +1 Collation used utf8mb3_general_ci 1 Collation used utf8mb4_bin -1 Collation used utf8_bin -1 Collation used utf8_general_ci deallocate prepare stmt; diff --git a/mysql-test/suite/plugins/r/feedback_plugin_send.result b/mysql-test/suite/plugins/r/feedback_plugin_send.result index 69046e16dd9..b10ea915a4f 100644 --- a/mysql-test/suite/plugins/r/feedback_plugin_send.result +++ b/mysql-test/suite/plugins/r/feedback_plugin_send.result @@ -21,24 +21,24 @@ ORDER BY VARIABLE_NAME; VARIABLE_VALUE>0 VARIABLE_NAME 1 Collation used binary 1 Collation used latin1_swedish_ci +1 Collation used utf8mb3_bin +1 Collation used utf8mb3_general_ci 1 Collation used utf8mb4_bin -1 Collation used utf8_bin -1 Collation used utf8_general_ci prepare stmt from "SELECT VARIABLE_VALUE>0, VARIABLE_NAME FROM INFORMATION_SCHEMA.FEEDBACK WHERE VARIABLE_NAME LIKE 'Collation used %' ORDER BY VARIABLE_NAME"; execute stmt; VARIABLE_VALUE>0 VARIABLE_NAME 1 Collation used binary 1 Collation used latin1_swedish_ci +1 Collation used utf8mb3_bin +1 Collation used utf8mb3_general_ci 1 Collation used utf8mb4_bin -1 Collation used utf8_bin -1 Collation used utf8_general_ci execute stmt; VARIABLE_VALUE>0 VARIABLE_NAME 1 Collation used binary 1 Collation used latin1_swedish_ci +1 Collation used utf8mb3_bin +1 Collation used utf8mb3_general_ci 1 Collation used utf8mb4_bin -1 Collation used utf8_bin -1 Collation used utf8_general_ci deallocate prepare stmt; set global sql_mode=ONLY_FULL_GROUP_BY; # restart diff --git a/mysql-test/suite/plugins/suite.pm b/mysql-test/suite/plugins/suite.pm index 359a5409fa3..9f269fdcda0 100644 --- a/mysql-test/suite/plugins/suite.pm +++ b/mysql-test/suite/plugins/suite.pm @@ -11,21 +11,12 @@ if (-d '../sql' && !&::using_extern()) { eval { symlink $src, $dst } or ::copy $src, $dst; } -sub cassandra_running() { - return 0 if IS_WINDOWS; - system 'echo show version | cqlsh -3 2>/dev/null >/dev/null'; - return $? == 0; -} - sub skip_combinations { my %skip; $skip{'t/pam_init.inc'} = 'No pam setup for mtr' unless -e '/etc/pam.d/mariadb_mtr'; $skip{'t/pam_init.inc'} = 'Not run as user owning auth_pam_tool_dir' unless -o $::plugindir . '/auth_pam_tool_dir'; - $skip{'t/cassandra.test'} = 'Cassandra is not running' - unless cassandra_running(); - $skip{'t/cassandra_qcache.test'} = $skip{'t/cassandra.test'}; %skip; } diff --git a/mysql-test/suite/plugins/t/cassandra.opt b/mysql-test/suite/plugins/t/cassandra.opt deleted file mode 100644 index 76639e7d3e2..00000000000 --- a/mysql-test/suite/plugins/t/cassandra.opt +++ /dev/null @@ -1 +0,0 @@ ---plugin-load-add=$HA_CASSANDRA_SO --loose-cassandra=on diff --git a/mysql-test/suite/plugins/t/cassandra.test b/mysql-test/suite/plugins/t/cassandra.test deleted file mode 100644 index b12de78e326..00000000000 --- a/mysql-test/suite/plugins/t/cassandra.test +++ /dev/null @@ -1,758 +0,0 @@ -# -# Tests for cassandra storage engine -# -if (`SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.ENGINES WHERE engine = 'cassandra' AND support IN ('YES', 'DEFAULT', 'ENABLED')`) -{ - --skip Test requires Cassandra. -} - ---disable_warnings -drop table if exists t0, t1; ---enable_warnings - ---echo # ---echo # Check variables and status counters ---echo # -show status like 'cassandra%'; -show variables like 'cassandra%'; - ---echo # ---echo # Test various errors on table creation. ---echo # ---error ER_REQUIRES_PRIMARY_KEY -create table t1 (a int) engine=cassandra - thrift_host='localhost' keyspace='foo' column_family='colfam'; - ---error ER_CONNECT_TO_FOREIGN_DATA_SOURCE -create table t1 (a int primary key, b int) engine=cassandra - thrift_host='localhost' keyspace='foo' column_family='colfam'; - ---error ER_CONNECT_TO_FOREIGN_DATA_SOURCE -create table t1 (rowkey char(10) primary key, column1 char(10)) engine=cassandra - thrift_host='127.0.0.2' keyspace='foo' column_family='colfam'; - ---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' column_family='colfam'; - -# No column family specified ---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'; - -############################################################################ -## Cassandra initialization -############################################################################ - -# Step 1: remove the keyspace that could be left over from the previous test ---remove_files_wildcard $MYSQLTEST_VARDIR cassandra_test_cleanup.cql ---write_file $MYSQLTEST_VARDIR/cassandra_test_cleanup.cql -drop keyspace mariadbtest2; -EOF ---error 0,1,2 ---system cqlsh -3 -f $MYSQLTEST_VARDIR/cassandra_test_cleanup.cql - -# Step 2: create new keyspace and test column families ---remove_files_wildcard $MYSQLTEST_VARDIR cassandra_test_init.cql ---write_file $MYSQLTEST_VARDIR/cassandra_test_init.cql - -CREATE KEYSPACE mariadbtest2 - WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy' - AND strategy_options:replication_factor='1'; - -USE mariadbtest2; -create columnfamily cf1 ( pk varchar primary key, data1 varchar, data2 bigint); - -create columnfamily cf2 (rowkey bigint primary key, a bigint); - -create columnfamily cf3 (rowkey bigint primary key, intcol int); - -create columnfamily cf4 (rowkey bigint primary key, datecol timestamp); - -create columnfamily cf5 (rowkey bigint primary key, uuidcol uuid); - -create columnfamily cf6 (rowkey uuid primary key, col1 int); - -create columnfamily cf7 (rowkey int primary key, boolcol boolean); - -create columnfamily cf8 (rowkey varchar primary key, countercol counter); -update cf8 set countercol=countercol+1 where rowkey='cnt1'; -update cf8 set countercol=countercol+100 where rowkey='cnt2'; - -create columnfamily cf9 (rowkey varchar primary key, varint_col varint); -insert into cf9 (rowkey, varint_col) values ('val-01', 1); -insert into cf9 (rowkey, varint_col) values ('val-0x123456', 1193046); -insert into cf9 (rowkey, varint_col) values ('val-0x12345678', 305419896); - -create columnfamily cf11 (rowkey varchar primary key, decimal_col decimal); -insert into cf11 (rowkey, decimal_col) values ('val_0.5', 0.5); -insert into cf11 (rowkey, decimal_col) values ('val_1.5', 1.5); -insert into cf11 (rowkey, decimal_col) values ('val_1234', 1234); - -create columnfamily cf12 (rowkey varchar primary key, decimal_col decimal); - -create columnfamily cf13 (rowkey int primary key, b blob); - -create columnfamily cf14 ( rowkey int primary key, a int ); - -EOF ---error 0,1,2 ---system cqlsh -3 -f $MYSQLTEST_VARDIR/cassandra_test_init.cql - - -# Step 3: Cassandra's CQL doesn't allow certain kinds of queries. Run them in -# CLI ---remove_files_wildcard $MYSQLTEST_VARDIR cassandra_test_init.cli ---write_file $MYSQLTEST_VARDIR/cassandra_test_init.cli -use mariadbtest2; -CREATE COLUMN FAMILY cf10 - WITH comparator = UTF8Type - AND key_validation_class=UTF8Type - AND default_validation_class = UTF8Type; - -CREATE COLUMN FAMILY cfd1 - WITH comparator = UTF8Type - AND key_validation_class=UTF8Type - AND default_validation_class = UTF8Type; -SET cfd1['1']['very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_very_long_name']='1'; - -CREATE COLUMN FAMILY cfd2 - WITH comparator = UTF8Type - AND key_validation_class=Int32Type - AND default_validation_class = UTF8Type; - -EOF - ---error 0,1,2 ---system cassandra-cli -f $MYSQLTEST_VARDIR/cassandra_test_init.cli - -############################################################################ -## Cassandra initialization ends -############################################################################ - ---echo # Now, create a table for real and insert data -create table t1 (pk varchar(36) primary key, data1 varchar(60), data2 bigint) engine=cassandra - thrift_host='localhost' keyspace='mariadbtest2' column_family='cf1'; - ---echo # Just in case there were left-overs from previous: -delete from t1; -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 pk='rowkey11'; -select * from t1 where pk='rowkey11'; - -# Deletion functions weirdly: it sets all columns to NULL -# but when If I do this in cassandra-cli: -# -# del cf1[ascii('rowkey10')] -# -# Subsequent 'list cf1' command also gives -# -# RowKey: rowkey10 -# -# without any columns. -# -# CQL seems to simply ignore all "incomplete" records. - -delete from t1 where pk='rowkey11'; -select * from t1; - -delete from t1; -select * from t1; - ---echo # ---echo # A query with filesort (check that table_flags() & HA_REC_NOT_IN_SEQ, ---echo # also check ::rnd_pos() ---echo # -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 order by data2; - -delete from t1; -drop table t1; - ---echo # ---echo # MDEV-476: Cassandra: Server crashes in calculate_key_len on DELETE with ORDER BY ---echo # -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; - -INSERT INTO t1 VALUES (1,1),(2,2); -DELETE FROM t1 ORDER BY a LIMIT 1; - -DROP TABLE t1; - ---echo # ---echo # Batched INSERT ---echo # -show variables like 'cassandra_insert_batch_size'; -show status like 'cassandra_row_insert%'; -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; - -delete from t1; -INSERT INTO t1 VALUES (1,1),(2,2); -DELETE FROM t1 ORDER BY a LIMIT 1; - -DROP TABLE t1; -show status like 'cassandra_row_insert%'; - ---echo # FLUSH STATUS doesn't work for our variables, just like with InnoDB. -flush status; -show status like 'cassandra_row_insert%'; - ---echo # ---echo # Batched Key Access ---echo # - ---echo # Control variable (we are not yet able to make use of MRR's buffer) -show variables like 'cassandra_multi%'; - ---echo # MRR-related status variables: -show status like 'cassandra_multi%'; - -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; -delete from t1; -INSERT INTO t1 VALUES (0,0),(1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9); - -set @tmp_jcl=@@join_cache_level; -set join_cache_level=8; -explain select * from t1 A, t1 B where B.rowkey=A.a; - -select * from t1 A, t1 B where B.rowkey=A.a; -show status like 'cassandra_multi%'; - -# The following INSERTs are really UPDATEs -insert into t1 values(1, 8); -insert into t1 values(3, 8); -insert into t1 values(5, 8); -insert into t1 values(7, 8); - -select * from t1 A, t1 B where B.rowkey=A.a; -show status like 'cassandra_multi%'; - -delete from t1; -drop table t1; - ---echo # ---echo # MDEV-480: TRUNCATE TABLE on a Cassandra table does not remove rows ---echo # -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; -INSERT INTO t1 VALUES (0,0),(1,1),(2,2); -truncate table t1; -select * from t1; -drop table t1; - ---echo # ---echo # MDEV-494, part #1: phantom row for big full-scan selects ---echo # -create table t0 (a int); -insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); - -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; - -insert into t1 select A.a + 10 * B.a + 100*C.a, 12345 from t0 A, t0 B, t0 C; - -select count(*) from t1; -select count(*) from t1 where a=12345; - -delete from t1; -drop table t1; -drop table t0; - ---echo # 32-bit INT type support -CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, intcol INT) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf3'; -insert into t1 values (10,10); -insert into t1 values (12,12); -delete from t1; -drop table t1; - ---echo # ---echo # Try accessing column family w/o explicitly defined columns ---echo # ---error ER_INTERNAL_ERROR -CREATE TABLE t1 (my_primary_key varchar(10) PRIMARY KEY) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf10'; - -CREATE TABLE t1 (rowkey varchar(10) PRIMARY KEY) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf10'; - -DROP TABLE t1; - ---echo # ---echo # Timestamp datatype support ---echo # -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, datecol timestamp) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf4'; - -delete from t2; -insert into t2 values (1, '2012-08-29 01:23:45'); -select * from t2; -delete from t2; - ---echo # MDEV-498: Cassandra: Inserting a timestamp does not work on a 32-bit system -INSERT INTO t2 VALUES (10,'2012-12-12 12:12:12'); -SELECT * FROM t2; -delete from t2; - ---echo # ---echo # (no MDEV#) Check that insert counters work correctly ---echo # -create table t0 (a int); -insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); -let $start_inserts=`select variable_value from information_schema.SESSION_STATUS - where variable_name ='Cassandra_row_inserts'`; -let $start_insert_batches=`select variable_value from information_schema.SESSION_STATUS - where variable_name ='Cassandra_row_insert_batches'`; - -set cassandra_insert_batch_size=10; -insert into t2 select A.a+10*B.a, now() from t0 A, t0 B; - ---disable_query_log -eval select - (select variable_value - $start_inserts from information_schema.SESSION_STATUS - where variable_name ='Cassandra_row_inserts') - AS 'inserts', - (select variable_value - $start_insert_batches from information_schema.SESSION_STATUS - where variable_name ='Cassandra_row_insert_batches') - AS 'insert_batches'; ---enable_query_log - -let $start_inserts=`select variable_value from information_schema.SESSION_STATUS - where variable_name ='Cassandra_row_inserts'`; -let $start_insert_batches=`select variable_value from information_schema.SESSION_STATUS - where variable_name ='Cassandra_row_insert_batches'`; - -set cassandra_insert_batch_size=1; -insert into t2 select A.a+10*B.a+100, now() from t0 A, t0 B; - ---disable_query_log -eval select - (select variable_value - $start_inserts from information_schema.SESSION_STATUS - where variable_name ='Cassandra_row_inserts') - AS 'inserts', - (select variable_value - $start_insert_batches from information_schema.SESSION_STATUS - where variable_name ='Cassandra_row_insert_batches') - AS 'insert_batches'; ---enable_query_log - -delete from t2; -drop table t2; -drop table t0; - ---echo # ---echo # UUID datatype support ---echo # -#create columnfamily cf5 (rowkey bigint primary key, uuidcol uuid); -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol char(36)) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -delete from t2; - -insert into t2 values(1,'9b5658dc-f32f-11e1-94cd-f46d046e9f09'); - ---error ER_WARN_DATA_OUT_OF_RANGE -insert into t2 values(2,'not-an-uuid'); - ---error ER_WARN_DATA_OUT_OF_RANGE -insert into t2 values(3,'9b5658dc-f32f-11e1=94cd-f46d046e9f09'); - ---error ER_WARN_DATA_OUT_OF_RANGE -insert into t2 values(4,'9b5658dc-fzzf-11e1-94cd-f46d046e9f09'); - ---error ER_WARN_DATA_OUT_OF_RANGE -insert into t2 values - (5,'9b5658dc-f11f-11e1-94cd-f46d046e9f09'), - (6,'9b5658dc-f11f011e1-94cd-f46d046e9f09'); - -select * from t2; - -delete from t2; -drop table t2; - -# create columnfamily cf6 (rowkey uuid primary key, col1 int); -CREATE TABLE t2 (rowkey char(36) PRIMARY KEY, col1 int) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf6'; -delete from t2; - -insert into t2 values('9b5658dc-f32f-11e1-94cd-f46d046e9f09', 1234); - ---error ER_WARN_DATA_OUT_OF_RANGE -insert into t2 values('not-an-uuid', 563); - -select * from t2; -delete from t2; -drop table t2; - - ---echo # ---echo # boolean datatype support ---echo # -# create columnfamily cf7 (rowkey int primary key, boolcol boolean); -CREATE TABLE t2 (rowkey int PRIMARY KEY, boolcol bool) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf7'; -insert into t2 values (0, 0); -insert into t2 values (1, 1); -select * from t2; -delete from t2; -drop table t2; - - ---echo # ---echo # Counter datatype support (read-only) ---echo # -# create columnfamily cf8 (rowkey int primary key, countercol counter); -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, countercol bigint) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf8'; -select * from t2; -drop table t2; - ---echo # ---echo # Check that @@cassandra_default_thrift_host works ---echo # -show variables like 'cassandra_default_thrift_host'; -set @tmp=@@cassandra_default_thrift_host; ---error ER_GLOBAL_VARIABLE -set cassandra_default_thrift_host='localhost'; -set global cassandra_default_thrift_host='localhost'; - ---echo # Try creating a table without specifying thrift_host: -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, countercol bigint) ENGINE=CASSANDRA - keyspace='mariadbtest2' column_family = 'cf8'; -select * from t2; -drop table t2; - -set global cassandra_default_thrift_host=@tmp; - ---echo # ---echo # Consistency settings ---echo # -show variables like 'cassandra_%consistency'; -set @tmp=@@cassandra_write_consistency; - ---echo # Unfortunately, there is no easy way to check if setting have the effect.. -set cassandra_write_consistency='ONE'; -set cassandra_write_consistency='QUORUM'; -set cassandra_write_consistency='LOCAL_QUORUM'; -set cassandra_write_consistency='EACH_QUORUM'; -set cassandra_write_consistency='ALL'; -set cassandra_write_consistency='ANY'; -set cassandra_write_consistency='TWO'; -set cassandra_write_consistency='THREE'; - -set cassandra_write_consistency=@tmp; - ---echo # ---echo # varint datatype support ---echo # -# create columnfamily cf9 (rowkey varchar primary key, varint_col varint); -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, varint_col varbinary(32)) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf9'; ---sorted_result -select rowkey, hex(varint_col) from t2; -drop table t2; - ---echo # now, let's check what happens when MariaDB's column is not wide enough: -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, varint_col varbinary(2)) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf9'; ---sorted_result ---error ER_INTERNAL_ERROR -select rowkey, hex(varint_col) from t2; -drop table t2; - ---echo # ---echo # Decimal datatype support ---echo # -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, decimal_col varbinary(32)) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf11'; -select rowkey, hex(decimal_col) from t2; -drop table t2; - ---echo # ---echo # Mapping TIMESTAMP -> int64 ---echo # -set @save_tz= @@time_zone; -set time_zone='UTC'; -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, datecol timestamp) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf4'; -insert into t2 values (1, '2012-08-29 01:23:45'); -INSERT INTO t2 VALUES (10,'2012-08-29 01:23:46'); -drop table t2; - -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, datecol bigint) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf4'; -select * from t2; -delete from t2; -drop table t2; -set time_zone=@save_tz; - ---echo # ---echo # Check whether changing parameters with ALTER TABLE works. ---echo # -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, decimal_col varbinary(32)) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf11'; - -#--error ER_INTERNAL_ERROR -#alter table t2 column_family='cf9'; - -drop table t2; - -CREATE TABLE t2 (rowkey varchar(32) PRIMARY KEY, decimal_col varbinary(32)) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf11'; - -let $c1= `select variable_value from information_schema.global_status - where variable_name like 'cassandra_row_inserts'`; -alter table t2 column_family='cf12'; -let $c2= `select variable_value from information_schema.global_status - where variable_name like 'cassandra_row_inserts'`; - ---disable_query_log -eval select ($c2 - $c1) as 'Writes made during ALTER TABLE'; ---enable_query_log - -drop table t2; - ---echo # ---echo # UPDATE command support ---echo # -create table t1 (pk varchar(36) primary key, data1 varchar(60), data2 bigint) engine=cassandra - thrift_host='localhost' keyspace='mariadbtest2' column_family='cf1'; - -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; - -update t1 set data1='updated-1' where pk='rowkey11'; -select * from t1; -update t1 set pk='new-rowkey12' where pk='rowkey12'; -select * from t1; - -delete from t1; -drop table t1; - ---echo # ---echo # Dynamic columns support ---echo # -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol blob DYNAMIC_COLUMN_STORAGE=1) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -drop table t2; - ---echo #error: dynamic column is not a blob ---error ER_WRONG_FIELD_SPEC -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol char(36) DYNAMIC_COLUMN_STORAGE=1) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; - ---echo #error: double dynamic column ---error ER_WRONG_FIELD_SPEC -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol blob DYNAMIC_COLUMN_STORAGE=1, textcol blob DYNAMIC_COLUMN_STORAGE=1) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; - ---echo # ---echo # Dynamic column read ---echo # -#prepare data -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol char(36)) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -delete from t2; -insert into t2 values(1,'9b5658dc-f32f-11e1-94cd-f46d046e9f09'); -insert into t2 values(2,'9b5658dc-f32f-11e1-94cd-f46d046e9f0a'); -drop table t2; - -#test dynamic column read -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -select rowkey, column_list(dyn), column_get(dyn, 'uuidcol' as char) from t2; -drop table t2; - -#cleanup data -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, uuidcol char(36)) ENGINE=CASSANDRA - thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -delete from t2; -drop table t2; - ---echo # ---echo # Dynamic column insert ---echo # -CREATE TABLE t2 (rowkey bigint PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf5'; -insert into t2 values (1, column_create("dyn1", 1, "dyn2", "two")); -select rowkey, column_json(dyn) from t2; -delete from t2; -drop table t2; ---echo # bigint -CREATE TABLE t1 (rowkey bigint PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf2'; -insert into t1 values (1, column_create("dyn1", 1, "dyn2", "two", 'a', 254324)); -insert into t1 values (2, column_create("dyn1", 1, "dyn2", "two", 'a', 2543)); -select rowkey, column_json(dyn) from t1; -delete from t1; -drop table t1; ---echo # int -CREATE TABLE t1 (rowkey bigint PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf3'; -insert into t1 values (1, column_create("dyn1", 1, "dyn2", "two", 'intcol', 254324)); -insert into t1 values (2, column_create("dyn1", 1, "dyn2", "two", 'intcol', 2543)); -select rowkey, column_json(dyn) from t1; -delete from t1; -drop table t1; ---echo # timestamp -CREATE TABLE t1 (rowkey bigint PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf4'; -insert into t1 values (1, column_create("dyn1", 1, "dyn2", "two", 'datecol', 254324)); -insert into t1 values (2, column_create("dyn1", 1, "dyn2", "two", 'datecol', 2543)); -select rowkey, column_json(dyn) from t1; -delete from t1; -drop table t1; ---echo # boolean -CREATE TABLE t1 (rowkey int PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cf7'; -insert into t1 values (1, column_create("dyn1", 1, "dyn2", "two", 'boolcol', 254324)); -insert into t1 values (2, column_create("dyn1", 1, "dyn2", "two", 'boolcol', 0)); -select rowkey, column_json(dyn) from t1; -select rowkey, column_json(dyn) from t1; -update t1 set dyn=column_add(dyn, "dyn2", null, "dyn3", "3"); -select rowkey, column_json(dyn) from t1; -update t1 set dyn=column_add(dyn, "dyn1", null) where rowkey= 1; -select rowkey, column_json(dyn) from t1; -update t1 set dyn=column_add(dyn, "dyn3", null, "a", "ddd"); -select rowkey, column_json(dyn) from t1; -update t1 set dyn=column_add(dyn, "12345678901234", "ddd"); -select rowkey, column_json(dyn) from t1; -update t1 set dyn=column_add(dyn, "12345678901234", null); -select rowkey, column_json(dyn) from t1; -update t1 set dyn=column_add(dyn, 'boolcol', null) where rowkey= 2; -select rowkey, column_json(dyn) from t1; -update t1 set rowkey= 3, dyn=column_add(dyn, "dyn1", null, 'boolcol', 0) where rowkey= 2; -select rowkey, column_json(dyn) from t1; -delete from t1; -drop table t1; - -CREATE TABLE t1 (rowkey varchar(10) PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cfd1'; ---error ER_INTERNAL_ERROR -select * from t1; -drop table t1; - -# MDEV-560 -CREATE TABLE t1 (rowkey int PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) -ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cfd2'; -DELETE FROM t1; -insert into t1 values (1, column_create("dyn", 1)); -select rowkey, column_list(dyn) from t1; -# Cleanup -delete from t1; -DROP TABLE t1; - -# MDEV-561 (incorrect format data to dynamic column) -CREATE TABLE t1 (rowkey int PRIMARY KEY, dyn blob DYNAMIC_COLUMN_STORAGE=yes) -ENGINE=CASSANDRA thrift_host='localhost' keyspace='mariadbtest2' column_family = 'cfd2'; ---error ER_DYN_COL_WRONG_FORMAT -insert into t1 values (1,'9b5658dc-f32f-11e1-94cd-f46d046e9f0a'); -delete from t1; -DROP TABLE t1; - ---echo # ---echo # MDEV-565: Server crashes in ha_cassandra::write_row on ---echo # inserting NULL into a dynamic column ---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 (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; - ---echo # ---echo # MDEV-4005 #Server crashes on creating a Cassandra table ---echo # with a mix of static and dynamic columns ---echo # ---disable_warnings -DROP TABLE IF EXISTS t1, t2; ---enable_warnings - ---remove_files_wildcard $MYSQLTEST_VARDIR cassandra_test_cleanup.cql ---write_file $MYSQLTEST_VARDIR/cassandra_test_cleanup.cql -drop keyspace bug; -EOF ---error 0,1,2 ---system cqlsh -3 -f $MYSQLTEST_VARDIR/cassandra_test_cleanup.cql - ---remove_files_wildcard $MYSQLTEST_VARDIR cassandra_test_init.cql ---write_file $MYSQLTEST_VARDIR/cassandra_test_init.cql - -CREATE KEYSPACE bug - WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy' - AND strategy_options:replication_factor='1'; - -USE bug; -create columnfamily cf1 ( pk int primary key, col_int int, a bigint ); -EOF - ---system cqlsh -3 -f $MYSQLTEST_VARDIR/cassandra_test_init.cql - - -CREATE TABLE t1 ( - pk int primary key, - col_int int, - dyncol blob DYNAMIC_COLUMN_STORAGE=yes -) ENGINE=cassandra keyspace='bug' thrift_host = '127.0.0.1' column_family='cf1'; - -drop table t1; - - ---echo # ---echo # MDEV-4000: Mapping between Cassandra blob (BytesType) and MySQL BLOB does not work ---echo # - -create table t1 (rowkey int primary key, b blob ) ENGINE=CASSANDRA thrift_host = '127.0.0.1' `keyspace`='mariadbtest2' `column_family`='cf13'; - -insert into t1 values (1, 'fooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo-bar'); -insert into t1 values (2, 'qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq-baz'); - -select * from t1; -drop table t1; - ---echo # ---echo # MDEV-4001: Cassandra: server crashes in ha_cassandra::end_bulk_insert on INSERT .. SELECT with a non-existing column ---echo # -create table t1 (rowkey int primary key, a int) ENGINE=cassandra thrift_host='127.0.0.1' keyspace='mariadbtest2' column_family='cf14'; ---error ER_BAD_FIELD_ERROR -insert into t1 (a) select b from t1; -drop table t1; - -############################################################################ -## Cassandra cleanup -############################################################################ ---disable_parsing -drop columnfamily cf1; -drop columnfamily cf2; -drop columnfamily cf3; -drop columnfamily cf4; -drop columnfamily cf5; -drop columnfamily cf6; -drop columnfamily cf7; - -drop columnfamily cf13; -drop columnfamily cf14; ---enable_parsing -############################################################################ -## Cassandra cleanup ends -############################################################################ - diff --git a/mysql-test/suite/plugins/t/cassandra_qcache.opt b/mysql-test/suite/plugins/t/cassandra_qcache.opt deleted file mode 100644 index 76639e7d3e2..00000000000 --- a/mysql-test/suite/plugins/t/cassandra_qcache.opt +++ /dev/null @@ -1 +0,0 @@ ---plugin-load-add=$HA_CASSANDRA_SO --loose-cassandra=on diff --git a/mysql-test/suite/plugins/t/cassandra_qcache.test b/mysql-test/suite/plugins/t/cassandra_qcache.test deleted file mode 100644 index 5ccce461a2f..00000000000 --- a/mysql-test/suite/plugins/t/cassandra_qcache.test +++ /dev/null @@ -1,59 +0,0 @@ -# -# Tests for cassandra storage engine -# --- source include/have_query_cache.inc - -if (`SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.ENGINES WHERE engine = 'cassandra' AND support IN ('YES', 'DEFAULT', 'ENABLED')`) -{ - --skip Test requires Cassandra. -} - ---disable_warnings -drop table if exists t1, t2; ---enable_warnings - -############################################################################ -## Cassandra initialization -############################################################################ - -# Step 1: remove the keyspace that could be left over from the previous test ---remove_files_wildcard $MYSQLTEST_VARDIR cassandra_test_cleanup.cql ---write_file $MYSQLTEST_VARDIR/cassandra_test_cleanup.cql -drop keyspace mariadbtest2; -EOF ---error 0,1,2 ---system cqlsh -3 -f $MYSQLTEST_VARDIR/cassandra_test_cleanup.cql - -# Step 2: create new keyspace and test column families ---remove_files_wildcard $MYSQLTEST_VARDIR cassandra_test_init.cql ---write_file $MYSQLTEST_VARDIR/cassandra_test_init.cql - -CREATE KEYSPACE mariadbtest2 - WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy' - AND strategy_options:replication_factor='1'; - -USE mariadbtest2; -create columnfamily cf1 ( rowkey int primary key, a int ); -EOF - ---error 0,1,2 ---system cqlsh -3 -f $MYSQLTEST_VARDIR/cassandra_test_init.cql - -############################################################################ -## The test itsef: -############################################################################ - -create table t1 (rowkey int primary key, a int) engine=cassandra - thrift_host='localhost' keyspace='mariadbtest2' column_family='cf1'; -create table t2 like t1; - -set global query_cache_size=1024*1024; - -select * from t1; -insert into t2 values (1,1); - -select * from t1; -select sql_no_cache * from t1; - -drop table t1,t2; -set global QUERY_CACHE_SIZE=0; diff --git a/mysql-test/suite/plugins/t/cassandra_reinstall.test b/mysql-test/suite/plugins/t/cassandra_reinstall.test deleted file mode 100644 index 95e4f7b63b6..00000000000 --- a/mysql-test/suite/plugins/t/cassandra_reinstall.test +++ /dev/null @@ -1,16 +0,0 @@ -# -# MDEV-4403 Attempting to use cassandra storage engine causes "service 'my_snprintf_service' interface version mismatch" -# -if (!$HA_CASSANDRA_SO) { - skip No Cassandra engine; -} - -install soname 'ha_cassandra'; -select plugin_name,plugin_status,plugin_library from information_schema.plugins where plugin_name = 'cassandra'; -uninstall plugin cassandra; -select plugin_name,plugin_status,plugin_library from information_schema.plugins where plugin_name = 'cassandra'; -install soname 'ha_cassandra'; -select plugin_name,plugin_status,plugin_library from information_schema.plugins where plugin_name = 'cassandra'; -uninstall plugin cassandra; -select plugin_name,plugin_status,plugin_library from information_schema.plugins where plugin_name = 'cassandra'; - diff --git a/mysql-test/suite/plugins/t/processlist.test b/mysql-test/suite/plugins/t/processlist.test index 39b715b867b..17a51e78141 100644 --- a/mysql-test/suite/plugins/t/processlist.test +++ b/mysql-test/suite/plugins/t/processlist.test @@ -13,7 +13,7 @@ let $wait_condition=select state='' from information_schema.processlist where id replace_regex /\"/-/; #" let s=`show engine innodb status`; disable_query_log; -eval select regexp_replace("$s", '(?s)^.*MySQL thread id $id,.*root([^\n]*)\n.*', '\\\\1') as `state from show engine innodb status, must be empty`; +eval select regexp_replace("$s", '(?s)^.*MariaDB thread id $id,.*root([^\n]*)\n.*', '\\\\1') as `state from show engine innodb status, must be empty`; enable_query_log; disconnect con2; connection default; diff --git a/mysql-test/suite/plugins/t/test_sql_service.test b/mysql-test/suite/plugins/t/test_sql_service.test index 3384b523bda..9b9e29c6913 100644 --- a/mysql-test/suite/plugins/t/test_sql_service.test +++ b/mysql-test/suite/plugins/t/test_sql_service.test @@ -1,4 +1,3 @@ - --source include/not_embedded.inc if (!$TEST_SQL_SERVICE_SO) { |