summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorunknown <joreland@mysql.com>2005-01-11 13:50:28 +0100
committerunknown <joreland@mysql.com>2005-01-11 13:50:28 +0100
commitf2e368483d2f7aafa983a0395ba9bfe32c674d5d (patch)
tree1842243da5c3bf7ffe888bbbdddf7af4ea931b24 /mysql-test/t
parent28f86d8ff1d042a2224c64712e31c65b1d6b7476 (diff)
parent89866c543058e6c817444f250ee3c65adc2fb971 (diff)
downloadmariadb-git-f2e368483d2f7aafa983a0395ba9bfe32c674d5d.tar.gz
Merge mysql.com:/home/jonas/src/mysql-4.1
into mysql.com:/home/jonas/src/mysql-5.0 mysql-test/r/ndb_index_ordered.result: Auto merged mysql-test/t/ndb_index_ordered.test: Auto merged ndb/src/kernel/blocks/dbtc/DbtcMain.cpp: Auto merged sql/net_serv.cc: Auto merged sql/sql_class.h: Auto merged
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/ndb_index_ordered.test18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_index_ordered.test b/mysql-test/t/ndb_index_ordered.test
index b7a5b418f44..1e70eac181e 100644
--- a/mysql-test/t/ndb_index_ordered.test
+++ b/mysql-test/t/ndb_index_ordered.test
@@ -267,3 +267,21 @@ select count(*)-5 from t1 use index (ti) where ti < '10:11:11';
select count(*)-6 from t1 use index (ti) where ti <= '10:11:11';
select count(*)-8 from t1 use index (ti) where ti < '23:59:59';
select count(*)-9 from t1 use index (ti) where ti <= '23:59:59';
+
+drop table t1;
+
+# bug#7798
+create table t1(a int primary key, b int not null, index(b));
+insert into t1 values (1,1), (2,2);
+connect (con1,localhost,,,test);
+connect (con2,localhost,,,test);
+connection con1;
+set autocommit=0;
+begin;
+select count(*) from t1;
+connection con2;
+ALTER TABLE t1 ADD COLUMN c int;
+connection con1;
+select a from t1 where b = 2;
+show tables;
+drop table t1;