# 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 cf (id bigint PRIMARY KEY, t timestamp);
EOF

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

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE t1 (id bigint PRIMARY KEY, t timestamp)
  ENGINE=CASSANDRA DEFAULT CHARSET=latin1
  thrift_host='localhost' keyspace='bug_ks' column_family = 'cf';

INSERT INTO t1 VALUES (1,'2012-12-12 12:12:12');
SELECT * FROM t1;

--echo # Inserting '2012-12-12 12:12:12' into Cassandra through cqlsh
--echo # and checking what we have there
--remove_file $MYSQLTEST_VARDIR/test.cql
--write_file $MYSQLTEST_VARDIR/test.cql
USE bug_ks;
INSERT INTO cf (id,t) VALUES (2,'2012-12-12 12:12:12');
SELECT * FROM cf;
EOF
--system cqlsh -3 -f $MYSQLTEST_VARDIR/test.cql

SELECT * FROM t1;

# Cleanup
DROP TABLE t1;

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (id bigint PRIMARY KEY, t timestamp)
ENGINE=CASSANDRA DEFAULT CHARSET=latin1
thrift_host='localhost' keyspace='bug_ks' column_family = 'cf';
INSERT INTO t1 VALUES (1,'2012-12-12 12:12:12');
SELECT * FROM t1;
id      t
1       1970-01-28 17:33:53
# Inserting '2012-12-12 12:12:12' into Cassandra through cqlsh
# and checking what we have there
 id | t
----+--------------------------
  1 | 1970-01-28 17:33:53+0000
  2 | 2012-12-12 12:12:12+0000

SELECT * FROM t1;
id      t
1       1970-01-28 17:33:53
2       2012-12-12 12:12:12
DROP TABLE t1;

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (id bigint PRIMARY KEY, t timestamp)
ENGINE=CASSANDRA DEFAULT CHARSET=latin1
thrift_host='localhost' keyspace='bug_ks' column_family = 'cf';
INSERT INTO t1 VALUES (1,'2012-12-12 12:12:12');
SELECT * FROM t1;
id      t
1       2012-12-12 12:12:12
# Inserting '2012-12-12 12:12:12' into Cassandra through cqlsh
# and checking what we have there
 id | t
----+--------------------------
  1 | 2012-12-12 12:12:12+0000
  2 | 2012-12-12 12:12:12+0000

SELECT * FROM t1;
id      t
1       2012-12-12 12:12:12
2       2012-12-12 12:12:12
DROP TABLE t1;

revision-id: psergey@askmonty.org-20120829162711-cdqfvic3os2rkd0o
date: 2012-08-29 20:27:11 +0400
build-date: 2012-08-30 04:59:51 +0400
revno: 3503