summaryrefslogtreecommitdiff
path: root/mysql-test/t/ndb_alter_table.test
diff options
context:
space:
mode:
authorunknown <tomas@poseidon.ndb.mysql.com>2004-09-24 16:58:25 +0000
committerunknown <tomas@poseidon.ndb.mysql.com>2004-09-24 16:58:25 +0000
commitd6c1a39a1523999ec0bc170a54257104f2ad5528 (patch)
tree4171316b3f027de3e55247678c0813da444bef34 /mysql-test/t/ndb_alter_table.test
parent5ef32b5826eec955da526b06152ff0aa414e3740 (diff)
downloadmariadb-git-d6c1a39a1523999ec0bc170a54257104f2ad5528.tar.gz
fix for invalidating table if mismatch with frm
removed debug printout new test in alter table for dictionay update test with multiple connections added coice of setting MaxNoOfOrderedIndexes added option to run "--small-bench" mysql-test/mysql-test-run.sh: added option to run "--small-bench" mysql-test/ndb/ndb_config_2_node.ini: added coice of setting MaxNoOfOrderedIndexes mysql-test/ndb/ndbcluster.sh: added coice of setting MaxNoOfOrderedIndexes mysql-test/r/ndb_alter_table.result: new test in alter table for dictionay update test with multiple connections mysql-test/t/ndb_alter_table.test: new test in alter table for dictionay update test with multiple connections ndb/src/ndbapi/DictCache.cpp: removed debug printout sql/ha_ndbcluster.cc: fix for invalidating table if mismatch with frm
Diffstat (limited to 'mysql-test/t/ndb_alter_table.test')
-rw-r--r--mysql-test/t/ndb_alter_table.test31
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_alter_table.test b/mysql-test/t/ndb_alter_table.test
index 3cdddfa8dce..96270d94dcb 100644
--- a/mysql-test/t/ndb_alter_table.test
+++ b/mysql-test/t/ndb_alter_table.test
@@ -49,6 +49,37 @@ show table status;
select * from t1 order by col1;
drop table t1;
+
+#
+# Check that invalidating dictionary cache works
+#
+
+CREATE TABLE t1 (
+ a INT NOT NULL,
+ b INT NOT NULL
+) ENGINE=ndbcluster;
+
+INSERT INTO t1 VALUES (9410,9412);
+
+connect (con1,localhost,,,test);
+connect (con2,localhost,,,test);
+
+connection con1;
+ALTER TABLE t1 ADD COLUMN c int not null;
+select * from t1;
+
+connection con2;
+select * from t1;
+alter table t1 drop c;
+
+connection con1;
+select * from t1;
+drop table t1;
+
+connection con2;
+--error 1146
+select * from t1;
+
#--disable_warnings
#DROP TABLE IF EXISTS t2;
#--enable_warnings