diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-04-11 20:09:24 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-04-11 20:09:24 +0300 |
| commit | 3e335144be1af3f7c70a0c385b4e88da2c1e5e94 (patch) | |
| tree | 6d097446e8d8e6493071189f90aafaf9de9bab16 /mysql-test/r/innodb.result | |
| parent | d5f3f5500f078a090bf38bc4c0ab13471e42f4d6 (diff) | |
| download | mariadb-git-3e335144be1af3f7c70a0c385b4e88da2c1e5e94.tar.gz | |
Two bug fixes
mysql-test/r/innodb.result:
Fix for a bug that caused queries with ORDER BY field_in_select_list
to be returned entirely unsorted.
mysql-test/t/innodb.test:
Fix for a bug that caused queries with ORDER BY field_in_select_list
to be returned entirely unsorted.
sql/sql_select.cc:
Fix for a bug that caused queries with ORDER BY field_in_select_list
to be returned entirely unsorted.
sql/sql_update.cc:
Fix for a glitch that caused too many tables to be locked.
Diffstat (limited to 'mysql-test/r/innodb.result')
| -rw-r--r-- | mysql-test/r/innodb.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result index b12466983f8..96bc66222d3 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -1207,6 +1207,16 @@ SET AUTOCOMMIT=0; INSERT INTO t1 ( B_ID ) VALUES ( 1 ); INSERT INTO t2 ( NEXT_T ) VALUES ( 1 ); ROLLBACK; +Warning: Some non-transactional changed tables couldn't be rolled back SELECT * FROM t1; B_ID drop table t1,t2; +create table t1 ( pk int primary key, parent int not null, child int not null, index (parent) ) type = innodb; +insert into t1 values (1,0,4), (2,1,3), (3,2,1), (4,1,2); +select distinct parent,child from t1 order by parent; +parent child +0 4 +1 2 +1 3 +2 1 +drop table t1; |