# Make sure your cassandra is running,
# and thrift is on LD_LIBRARY_PATH,
# and cqlsh is on the system PATH

--source include/have_cassandra.inc

--remove_files_wildcard $MYSQLTEST_VARDIR test.cql
--write_file $MYSQLTEST_VARDIR/test.cql
DROP KEYSPACE bug_ks;
EOF
--error 0,1,2
--system cqlsh -3 -f $MYSQLTEST_VARDIR/test.cql

--remove_file $MYSQLTEST_VARDIR/test.cql
--write_file $MYSQLTEST_VARDIR/test.cql
CREATE KEYSPACE bug_ks
  WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy'
   AND strategy_options:replication_factor='1';
USE bug_ks;
CREATE COLUMNFAMILY cf1 ( pk bigint primary key, a bigint );
EOF

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

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA
  thrift_host='localhost' keyspace='bug_ks' column_family = 'cf1';

INSERT INTO t1 VALUES (1,1),(2,2);
SELECT * FROM t1;
TRUNCATE TABLE t1;
SELECT * FROM t1;

# Cleanup
DROP TABLE t1;

DROP TABLE IF EXISTS t1;
Warnings:
Note    1051    Unknown table 't1'
CREATE TABLE t1 (rowkey BIGINT PRIMARY KEY, a BIGINT) ENGINE=CASSANDRA
thrift_host='localhost' keyspace='bug_ks' column_family = 'cf1';
INSERT INTO t1 VALUES (1,1),(2,2);
SELECT * FROM t1;
rowkey  a
1       1
2       2
TRUNCATE TABLE t1;
SELECT * FROM t1;
rowkey  a
1       1
2       2
DROP TABLE t1;

revision-id: psergey@askmonty.org-20120823121528-1p4qx0yzc7ktdcc9
date: 2012-08-23 16:15:28 +0400
build-date: 2012-08-24 00:05:46 +0400
revno: 3493