1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
# Test case from email from Sergei Golubchik for testing usage of rr cache
create table t1 (a int, b int, x varchar(1024) default 'x');
insert t1 values (rand()*1e9, rand()*1e9, 'x');
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1;
SELECT CASE WHEN a >0 THEN 'true' ELSE 'false' END from t1 order by a limit 1;
drop table t1;
|