|
929.1.4
by Brian Aker
New test case for rr_from_cache |
1 |
# Test case from email from Sergei Golubchik for testing usage of rr cache
|
2 |
create table t1 (a int, b int, x varchar(1024) default 'x'); |
|
3 |
insert t1 values (rand()*1e9, rand()*1e9, 'x'); |
|
|
1487.1.1
by Brian Aker
There is room for improvement around this. We should be using rows as well |
4 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
5 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
6 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
7 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
8 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
9 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
10 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
11 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
12 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
13 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
14 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
15 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
16 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
17 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
18 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
19 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
20 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
21 |
insert t1 select SQL_BIG_RESULT rand()*1e9, rand()*1e9,'x' from t1; |
|
|
929.1.4
by Brian Aker
New test case for rr_from_cache |
22 |
SELECT CASE WHEN a >0 THEN 'true' ELSE 'false' END from t1 order by a limit 1; |
23 |
drop table t1; |