diff options
| author | Georgi Kodinov <kgeorge@mysql.com> | 2008-10-07 18:19:32 +0300 |
|---|---|---|
| committer | Georgi Kodinov <kgeorge@mysql.com> | 2008-10-07 18:19:32 +0300 |
| commit | 7831b221e0575e822422d6ba4c8472842386ec9c (patch) | |
| tree | 89ad7298ca98cf76588844984f9c72516a2e891b /mysql-test/t/partition.test | |
| parent | 68fa4edc84c9beca00b5813621159561f9006b1d (diff) | |
| parent | b4c5cafeb01adb9f8303520342ff0621d41cf8f8 (diff) | |
| download | mariadb-git-7831b221e0575e822422d6ba4c8472842386ec9c.tar.gz | |
merged 5.1-5.1.29-rc -> 5.1-bugteam
Diffstat (limited to 'mysql-test/t/partition.test')
| -rw-r--r-- | mysql-test/t/partition.test | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/mysql-test/t/partition.test b/mysql-test/t/partition.test index 3323e4f9bcd..83e0cde8991 100644 --- a/mysql-test/t/partition.test +++ b/mysql-test/t/partition.test @@ -1816,4 +1816,53 @@ SET SQL_MODE= @orig_sql_mode; +# +# Bug #38005 Partitions: error with insert select +# + +create table t1 (s1 int) partition by hash(s1) partitions 2; +create index i on t1 (s1); +insert into t1 values (1); +insert into t1 select s1 from t1; +insert into t1 select s1 from t1; +insert into t1 select s1 from t1 order by s1 desc; +select * from t1; +drop table t1; + +create table t1 (s1 int) partition by range(s1) + (partition pa1 values less than (10), + partition pa2 values less than MAXVALUE); +create index i on t1 (s1); +insert into t1 values (1); +insert into t1 select s1 from t1; +insert into t1 select s1 from t1; +insert into t1 select s1 from t1 order by s1 desc; +select * from t1; +drop table t1; + +create table t1 (s1 int) partition by range(s1) + (partition pa1 values less than (10), + partition pa2 values less than MAXVALUE); +create index i on t1 (s1); +insert into t1 values (20); +insert into t1 select s1 from t1; +insert into t1 select s1 from t1; +insert into t1 select s1 from t1 order by s1 desc; +select * from t1; +drop table t1; + +create table t1 (s1 int) partition by range(s1) + (partition pa1 values less than (10), + partition pa2 values less than MAXVALUE); +create index i on t1 (s1); +insert into t1 values (1), (2), (3), (4), (5), (6), (7), (8); +insert into t1 select s1 from t1; +insert into t1 select s1 from t1; +insert into t1 select s1 from t1; +insert into t1 select s1 from t1; +insert into t1 select s1 from t1 order by s1 desc; +insert into t1 select s1 from t1 where s1=3; +select count(*) from t1; +drop table t1; + --echo End of 5.1 tests |