diff options
| author | Satya B <satya.bn@sun.com> | 2009-11-25 15:29:25 +0530 |
|---|---|---|
| committer | Satya B <satya.bn@sun.com> | 2009-11-25 15:29:25 +0530 |
| commit | 97d74332c2edd81754f3771f4212fa653f8c7864 (patch) | |
| tree | ae3d692cf19b2e418de699173b1d3a92119debd8 /mysql-test/r | |
| parent | 2bf2e8f9dd619ba7ecb635a0eb51a7a4f9db977b (diff) | |
| download | mariadb-git-97d74332c2edd81754f3771f4212fa653f8c7864.tar.gz | |
Applying InnoDB snapshot 5.0-ss6230, part 2. Fixes BUG#46000
BUG#46000 - using index called GEN_CLUST_INDEX crashes server
Detailed revision comments:
r6180 | jyang | 2009-11-17 10:54:57 +0200 (Tue, 17 Nov 2009) | 7 lines
branches/5.0: Merge/Port fix for bug #46000 from branches/5.1
-r5895 to branches/5.0. Disallow creating index with the
name of "GEN_CLUST_INDEX" which is reserved for the default
system primary index. Minor adjusts on table name screening
format for added tests.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/innodb_bug46000.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_bug46000.result b/mysql-test/r/innodb_bug46000.result new file mode 100644 index 00000000000..8a92fa973c0 --- /dev/null +++ b/mysql-test/r/innodb_bug46000.result @@ -0,0 +1,13 @@ +create table bug46000(`id` int,key `GEN_CLUST_INDEX`(`id`))engine=innodb; +ERROR HY000: Can't create table bug46000.frm' (errno: -1) +show warnings; +Level Code Message +Warning 1005 Cannot Create Index with name 'GEN_CLUST_INDEX'. The name is reserved for the system default primary index. +Error 1005 Can't create table bug46000.frm' (errno: -1) +create table bug46000(`id` int, key `GEN_clust_INDEX`(`id`))engine=innodb; +ERROR HY000: Can't create table bug46000.frm' (errno: -1) +create table bug46000(id int) engine=innodb; +create index GEN_CLUST_INDEX on bug46000(id); +ERROR HY000: Can't create table #sql-temporary' (errno: -1) +create index idx on bug46000(id); +drop table bug46000; |