← Back to branch summary

~ubuntu-branches/ubuntu/vivid/mariadb-5.5/vivid

« back to all changes in this revision

Viewing changes to storage/tokudb/mysql-test/tokudb_mariadb/r/commit_5396.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_mariadb/r/commit_5396.result
 
1
CREATE TABLE t1 (a VARCHAR(8), INDEX(a)) ENGINE=TokuDB;
 
2
INSERT INTO t1 VALUES ('foo'),('bar');
 
3
CREATE TABLE t2 AS SELECT 'qux' IN (SELECT a FROM t1) AS f1;
 
4
DROP TABLE t1, t2;
 
5
CREATE TABLE t1 (a INT);
 
6
INSERT INTO t1 VALUES (1),(2);
 
7
CREATE TABLE t2 (b INT);
 
8
INSERT INTO t2 VALUES (3),(4);
 
9
CREATE TABLE t3 (c VARCHAR(3), INDEX(c)) ENGINE=TokuDB;
 
10
INSERT INTO t3 VALUES ('foo'),('bar');
 
11
EXPLAIN SELECT * FROM t1 WHERE a IN (SELECT b FROM t2) OR 'qux' IN (SELECT c FROM t3);
 
12
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
 
13
1       PRIMARY t1      ALL     NULL    NULL    NULL    NULL    2       Using where
 
14
3       SUBQUERY        t3      index_subquery  c       c       6       const   0       Using index; Using where
 
15
2       MATERIALIZED    t2      ALL     NULL    NULL    NULL    NULL    2       
 
16
DROP TABLE t1, t2, t3;