diff options
author | unknown <bell@sanja.is.com.ua> | 2004-09-10 16:28:18 +0300 |
---|---|---|
committer | unknown <bell@sanja.is.com.ua> | 2004-09-10 16:28:18 +0300 |
commit | 32dc386d5e256dea2ef54efcd8de1dadc0328c44 (patch) | |
tree | 573d6d013fae80ebbea92e5e615b4368be394ec1 /mysql-test/r/query_cache.result | |
parent | e2252a49f7393076107ee5e228be79660e7faecb (diff) | |
download | mariadb-git-32dc386d5e256dea2ef54efcd8de1dadc0328c44.tar.gz |
information about different variables agged to query cache (BUG#5515, BUG#5394)
mysql-test/r/query_cache.result:
test of QC with different variables
mysql-test/t/query_cache.test:
test of QC with different variables
sql/mysql_priv.h:
new information for query key calculation
sql/sql_cache.cc:
new information for query key calculation
sql/sql_cache.h:
removed unused definitions
Diffstat (limited to 'mysql-test/r/query_cache.result')
-rw-r--r-- | mysql-test/r/query_cache.result | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result index a93ea1aa7fe..ee4b97b8ea8 100644 --- a/mysql-test/r/query_cache.result +++ b/mysql-test/r/query_cache.result @@ -851,4 +851,60 @@ select @@character_set_results; @@character_set_results NULL set character_set_results=default; +set GLOBAL query_cache_size=1355776; +create table t1 (id int auto_increment primary key, c char(25)); +insert into t1 set c = repeat('x',24); +insert into t1 set c = concat(repeat('x',24),'x'); +insert into t1 set c = concat(repeat('x',24),'w'); +insert into t1 set c = concat(repeat('x',24),'y'); +set max_sort_length=200; +select c from t1 order by c, id; +c +xxxxxxxxxxxxxxxxxxxxxxxx +xxxxxxxxxxxxxxxxxxxxxxxxw +xxxxxxxxxxxxxxxxxxxxxxxxx +xxxxxxxxxxxxxxxxxxxxxxxxy +reset query cache; +set max_sort_length=20; +select c from t1 order by c, id; +c +xxxxxxxxxxxxxxxxxxxxxxxx +xxxxxxxxxxxxxxxxxxxxxxxxx +xxxxxxxxxxxxxxxxxxxxxxxxw +xxxxxxxxxxxxxxxxxxxxxxxxy +set max_sort_length=200; +select c from t1 order by c, id; +c +xxxxxxxxxxxxxxxxxxxxxxxx +xxxxxxxxxxxxxxxxxxxxxxxxw +xxxxxxxxxxxxxxxxxxxxxxxxx +xxxxxxxxxxxxxxxxxxxxxxxxy +set max_sort_length=default; +select '1' || '3' from t1; +'1' || '3' +1 +1 +1 +1 +set SQL_MODE=oracle; +select '1' || '3' from t1; +'1' || '3' +13 +13 +13 +13 +set SQL_MODE=default; +drop table t1; +create table t1 (a varchar(20), b int); +insert into t1 values ('12345678901234567890', 1); +set group_concat_max_len=10; +select group_concat(a) FROM t1 group by b; +group_concat(a) +1234567890 +set group_concat_max_len=1024; +select group_concat(a) FROM t1 group by b; +group_concat(a) +12345678901234567890 +set group_concat_max_len=default; +drop table t1; SET GLOBAL query_cache_size=0; |