diff options
author | Philip Stoev <philip.stoev@galeracluster.com> | 2015-06-26 01:30:01 -0700 |
---|---|---|
committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2015-09-09 22:31:06 -0400 |
commit | 5a002adb5fda82df8f6bfe7b4f49f07585e13c39 (patch) | |
tree | adc40c4c394536bf382ae5972eddbc38bc65ed43 /mysql-test/suite/galera/r/galera_prepared_statement.result | |
parent | f1a00ed51447f96c140f594784919800bda750d6 (diff) | |
download | mariadb-git-5a002adb5fda82df8f6bfe7b4f49f07585e13c39.tar.gz |
Galera MTR Tests: various tests and test fixes
Diffstat (limited to 'mysql-test/suite/galera/r/galera_prepared_statement.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_prepared_statement.result | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_prepared_statement.result b/mysql-test/suite/galera/r/galera_prepared_statement.result new file mode 100644 index 00000000000..138d4431e3d --- /dev/null +++ b/mysql-test/suite/galera/r/galera_prepared_statement.result @@ -0,0 +1,33 @@ +CREATE TABLE t1 (f1 CHAR(5)) ENGINE=InnoDB; +CREATE TABLE t2 (f1 CHAR(5)) ENGINE=InnoDB; +CREATE TABLE t3 (f1 CHAR(5)) ENGINE=InnoDB; +CREATE TABLE t4 (f1 CHAR(5)) ENGINE=InnoDB; +SET SESSION sql_mode='STRICT_ALL_TABLES'; +PREPARE st1 FROM 'INSERT INTO t1 VALUES ("abc")'; +PREPARE st2 FROM 'INSERT INTO t2 VALUES ("abc")'; +PREPARE st3 FROM 'INSERT INTO t3 VALUES ("abc")'; +PREPARE st4 FROM 'INSERT INTO t4 VALUES ("abc")'; +EXECUTE st1; +EXECUTE st2; +EXECUTE st3; +EXECUTE st4; +SELECT COUNT(*) = 1 FROM t1; +COUNT(*) = 1 +1 +SELECT COUNT(*) = 1 FROM t2; +COUNT(*) = 1 +1 +SELECT COUNT(*) = 1 FROM t3; +COUNT(*) = 1 +1 +SELECT COUNT(*) = 1 FROM t4; +COUNT(*) = 1 +1 +ALTER TABLE t1 ADD COLUMN f2 INTEGER; +ALTER TABLE t1 DROP COLUMN f1; +EXECUTE st1; +ERROR HY000: Incorrect integer value: 'abc' for column 'f2' at row 1 +DROP TABLE t1; +DROP TABLE t2; +DROP TABLE t3; +DROP TABLE t4; |