diff options
| author | unknown <evgen@moonbone.local> | 2005-09-10 02:30:26 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-09-10 02:30:26 +0400 |
| commit | fa13c29b2e36d33fdda46777390aca6df2b0faeb (patch) | |
| tree | a424782c1b618a5f79894e85f22098af9cf4d53b /mysql-test/r/insert_select.result | |
| parent | 4b59ede9c04d8fca8257dbd5136a082d7e25d0aa (diff) | |
| download | mariadb-git-fa13c29b2e36d33fdda46777390aca6df2b0faeb.tar.gz | |
insert_select.result, insert_select.test:
Customer's test case for bug#12695 Item_func_isnull::update_used_tables() did
not update const_item_cache.
mysql-test/t/insert_select.test:
Customer's test case for bug#12695 Item_func_isnull::update_used_tables() did
not update const_item_cache.
mysql-test/r/insert_select.result:
Customer's test case for bug#12695 Item_func_isnull::update_used_tables() did
not update const_item_cache.
Diffstat (limited to 'mysql-test/r/insert_select.result')
| -rw-r--r-- | mysql-test/r/insert_select.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/insert_select.result b/mysql-test/r/insert_select.result index 2ac73fe7662..d4eb4e8b788 100644 --- a/mysql-test/r/insert_select.result +++ b/mysql-test/r/insert_select.result @@ -668,3 +668,13 @@ ERROR 42S02: Unknown table 't2' in field list insert into t1 select t2.a from t2 group by t2.a on duplicate key update a= t1.a + t2.b; ERROR 42S02: Unknown table 't2' in field list drop table t1,t2,t3; +create table t1(f1 varchar(5) key); +insert into t1(f1) select if(max(f1) is null, '2000',max(f1)+1) from t1; +insert into t1(f1) select if(max(f1) is null, '2000',max(f1)+1) from t1; +insert into t1(f1) select if(max(f1) is null, '2000',max(f1)+1) from t1; +select * from t1; +f1 +2000 +2001 +2002 +drop table t1; |