create columnfamily cf1 ( pk int primary key, c ascii );

CREATE TABLE t1 ( pk INT PRIMARY KEY, c VARCHAR(8) ) 
ENGINE=Cassandra DEFAULT CHARSET latin1 KEYSPACE='bug' COLUMN_FAMILY='cf1';
INSERT INTO t1 VALUES ( 1, CHAR(127) );
affected rows: 1
INSERT INTO t1 SELECT 2, CHAR(127);
affected rows: 1
info: Records: 1  Duplicates: 0  Warnings: 0
INSERT INTO t1 VALUES ( 3, CHAR(128) );
ERROR HY000: Internal error: 'Default TException. [(Invalid byte for ascii: -128) [bug][cf1][c] failed validation]'
INSERT INTO t1 SELECT 4, CHAR(128);
ERROR HY000: Got error 122 "Internal (unspecified) error in handler" from storage engine

CREATE TABLE t2 ( pk INT PRIMARY KEY, c VARCHAR(8) ) 
ENGINE=MyISAM DEFAULT CHARSET latin1;
affected rows: 0
INSERT INTO t2 VALUES ( 1, CHAR(128) );
affected rows: 1
INSERT INTO t2 SELECT 2, CHAR(128);
affected rows: 1
info: Records: 1  Duplicates: 0  Warnings: 0

--source include/have_cassandra.inc

SET GLOBAL cassandra_default_thrift_host = '127.0.0.1';

--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, c ascii );
EOF

--system cqlsh -3 -f $MYSQLTEST_VARDIR/cassandra_test_init.cql

DROP TABLE IF EXISTS t1, t2;
CREATE TABLE t1 ( pk INT PRIMARY KEY, c VARCHAR(8) ) 
  ENGINE=Cassandra DEFAULT CHARSET latin1 KEYSPACE='bug' COLUMN_FAMILY='cf1';

--disable_abort_on_error

INSERT INTO t1 VALUES ( 1, CHAR(127) );
INSERT INTO t1 SELECT 2, CHAR(127);
INSERT INTO t1 VALUES ( 3, CHAR(128) );
INSERT INTO t1 SELECT 4, CHAR(128);

--enable_abort_on_error