diff options
author | unknown <joreland@mysql.com> | 2005-01-11 13:50:28 +0100 |
---|---|---|
committer | unknown <joreland@mysql.com> | 2005-01-11 13:50:28 +0100 |
commit | f2e368483d2f7aafa983a0395ba9bfe32c674d5d (patch) | |
tree | 1842243da5c3bf7ffe888bbbdddf7af4ea931b24 /mysql-test/t | |
parent | 28f86d8ff1d042a2224c64712e31c65b1d6b7476 (diff) | |
parent | 89866c543058e6c817444f250ee3c65adc2fb971 (diff) | |
download | mariadb-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.test | 18 |
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; |