|
929.1.4
by Brian Aker
New test case for rr_from_cache |
1 |
create table t1 (a int, b int, x varchar(1024) default 'x'); |
2 |
insert t1 values (rand()*1e9, rand()*1e9, 'x'); |
|
3 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
4 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
5 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
6 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
7 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
8 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
9 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
10 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
11 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
12 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
13 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
14 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
15 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
16 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
17 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
18 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
19 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
20 |
insert t1 select rand()*1e9, rand()*1e9,'x' from t1; |
|
21 |
SELECT CASE WHEN a >0 THEN 'true' ELSE 'false' END from t1 order by a limit 1; |
|
22 |
CASE WHEN a >0 THEN 'true' ELSE 'false' END |
|
23 |
true
|
|
24 |
drop table t1; |