diff options
| author | unknown <ramil@mysql.com> | 2005-03-15 13:32:12 +0400 |
|---|---|---|
| committer | unknown <ramil@mysql.com> | 2005-03-15 13:32:12 +0400 |
| commit | 9c04a77e0c69728941387e88bd118adbc0374c45 (patch) | |
| tree | 41e3f57ec9e5632602bbaf0aeb4a973e7c77dccb /mysql-test/r/heap.result | |
| parent | 2427f3695ccd495eb33ce10c3fb3a636823e8850 (diff) | |
| download | mariadb-git-9c04a77e0c69728941387e88bd118adbc0374c45.tar.gz | |
A fix (bug #8489: Strange auto_increment behaviour with HEAP table).
heap/hp_create.c:
A fix (bug #8489: Strange auto_increment behaviour with HEAP table).
Handle autoincrement keys MyISAM-way.
include/heap.h:
A fix (bug #8489: Strange auto_increment behaviour with HEAP table).
Handle autoincrement keys MyISAM-way.
sql/ha_heap.cc:
A fix (bug #8489: Strange auto_increment behaviour with HEAP table).
Handle autoincrement keys MyISAM-way.
Diffstat (limited to 'mysql-test/r/heap.result')
| -rw-r--r-- | mysql-test/r/heap.result | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result index b1cd17b444c..29207a4ae98 100644 --- a/mysql-test/r/heap.result +++ b/mysql-test/r/heap.result @@ -249,3 +249,45 @@ a 3 2 drop table t1; +create table t1 (a bigint unsigned auto_increment primary key, b int, +key (b, a)) engine=heap; +insert t1 (b) values (1); +insert t1 (b) values (1); +insert t1 (b) values (1); +insert t1 (b) values (1); +insert t1 (b) values (1); +insert t1 (b) values (1); +insert t1 (b) values (1); +insert t1 (b) values (1); +select * from t1; +a b +1 1 +2 1 +3 1 +4 1 +5 1 +6 1 +7 1 +8 1 +drop table t1; +create table t1 (a int not null, b int not null auto_increment, +primary key(a, b), key(b)) engine=heap; +insert t1 (a) values (1); +insert t1 (a) values (1); +insert t1 (a) values (1); +insert t1 (a) values (1); +insert t1 (a) values (1); +insert t1 (a) values (1); +insert t1 (a) values (1); +insert t1 (a) values (1); +select * from t1; +a b +1 1 +1 2 +1 3 +1 4 +1 5 +1 6 +1 7 +1 8 +drop table t1; |