← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mariadb-5.5/trusty-proposed

« back to all changes in this revision

Viewing changes to storage/tokudb/mysql-test/tokudb/r/ext_key_2_tokudb.result

  • Committer: Package Import Robot
  • Author(s): James Page, Otto Kekäläinen
  • Date: 2014-02-17 16:51:52 UTC
  • mfrom: (2.1.1 sid)
  • Revision ID: package-import@ubuntu.com-20140217165152-k315d3175g865kkx
Tags: 5.5.35-1
http://bugs.debian.org/737597
http://bugs.debian.org/733002
http://bugs.debian.org/734426
http://bugs.debian.org/735284
http://bugs.debian.org/736480
http://bugs.debian.org/732967
[ Otto Kekäläinen ]
* New upstream release, fixing the following security issues:
  - Buffer overflow in client/mysql.cc (Closes: #737597).
    - CVE-2014-0001
  - http://www.oracle.com/technetwork/topics/security/cpujan2014-1972949.html
    - CVE-2013-5891
    - CVE-2013-5908
    - CVE-2014-0386
    - CVE-2014-0393
    - CVE-2014-0401
    - CVE-2014-0402
    - CVE-2014-0412
    - CVE-2014-0420
    - CVE-2014-0437
* Upstream https://mariadb.atlassian.net/browse/MDEV-4902
  fixes compatibility with Bison 3.0 (Closes: #733002)
* Updated Russian debconf translation (Closes: #734426)
* Updated Japanese debconf translation (Closes: #735284)
* Updated French debconf translation (Closes: #736480)
* Renamed SONAME properly (Closes: #732967)

Show diffs side-by-side

added added

removed removed

Lines of Context:
storage/tokudb/mysql-test/tokudb/r/ext_key_2_tokudb.result
 
1
drop table if exists t;
 
2
set session optimizer_switch='extended_keys=on';
 
3
select @@optimizer_switch;
 
4
@@optimizer_switch
 
5
index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on
 
6
create table t (a int not null, b int not null, c int not null, d int not null, primary key(a,b), key(c,a)) engine=tokudb;
 
7
insert into t values (0,0,0,0),(0,1,0,1);
 
8
explain select c,a,b from t where c=0 and a=0 and b=1;
 
9
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
 
10
1       SIMPLE  t       const   PRIMARY,c       PRIMARY 8       const,const     1       
 
11
flush status;
 
12
select c,a,b from t where c=0 and a=0 and b=1;
 
13
c       a       b
 
14
0       0       1
 
15
show status like 'handler_read%';
 
16
Variable_name   Value
 
17
Handler_read_first      0
 
18
Handler_read_key        1
 
19
Handler_read_last       0
 
20
Handler_read_next       0
 
21
Handler_read_prev       0
 
22
Handler_read_rnd        0
 
23
Handler_read_rnd_deleted        0
 
24
Handler_read_rnd_next   0
 
25
explain select c,a,b from t force index (c) where c=0 and a=0 and b=1;
 
26
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
 
27
1       SIMPLE  t       const   c       c       12      const,const,const       1       Using index
 
28
flush status;
 
29
select c,a,b from t force index (c) where c=0 and a=0 and b=1;
 
30
c       a       b
 
31
0       0       1
 
32
show status like 'handler_read%';
 
33
Variable_name   Value
 
34
Handler_read_first      0
 
35
Handler_read_key        1
 
36
Handler_read_last       0
 
37
Handler_read_next       0
 
38
Handler_read_prev       0
 
39
Handler_read_rnd        0
 
40
Handler_read_rnd_deleted        0
 
41
Handler_read_rnd_next   0
 
42
drop table t;