← Back to branch summary

~ubuntu-branches/ubuntu/natty/mysql-5.1/natty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/r/sp_trans.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 08:30:45 UTC
  • mfrom: (1.4.1)
  • Revision ID: package-import@ubuntu.com-20120222083045-2rd53r4bnyx7qus4
Tags: 5.1.61-0ubuntu0.11.04.1
https://launchpad.net/bugs/937869
* SECURITY UPDATE: Update to 5.1.61 to fix multiple security issues
  (LP: #937869)
  - http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html
  - CVE-2011-2262
  - CVE-2012-0075
  - CVE-2012-0112
  - CVE-2012-0113
  - CVE-2012-0114
  - CVE-2012-0115
  - CVE-2012-0116
  - CVE-2012-0117
  - CVE-2012-0118
  - CVE-2012-0119
  - CVE-2012-0120
  - CVE-2012-0484
  - CVE-2012-0485
  - CVE-2012-0486
  - CVE-2012-0487
  - CVE-2012-0488
  - CVE-2012-0489
  - CVE-2012-0490
  - CVE-2012-0491
  - CVE-2012-0492
  - CVE-2012-0493
  - CVE-2012-0494
  - CVE-2012-0495
  - CVE-2012-0496

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/sp_trans.result
556
556
3       ccc
557
557
drop function bug13575|
558
558
drop table t3|
 
559
SELECT @@GLOBAL.storage_engine INTO @old_engine|
 
560
SET @@GLOBAL.storage_engine=InnoDB|
 
561
SET @@SESSION.storage_engine=InnoDB|
 
562
SHOW GLOBAL VARIABLES LIKE 'storage_engine'|
 
563
Variable_name   Value
 
564
storage_engine  InnoDB
 
565
SHOW SESSION VARIABLES LIKE 'storage_engine'|
 
566
Variable_name   Value
 
567
storage_engine  InnoDB
 
568
CREATE PROCEDURE bug11758414()
 
569
BEGIN
 
570
SET @@GLOBAL.storage_engine="MyISAM";
 
571
SET @@SESSION.storage_engine="MyISAM"; 
 
572
# show defaults at execution time / that setting them worked
 
573
SHOW GLOBAL VARIABLES LIKE 'storage_engine';
 
574
SHOW SESSION VARIABLES LIKE 'storage_engine';
 
575
CREATE TABLE t1 (id int);
 
576
CREATE TABLE t2 (id int) ENGINE=InnoDB;
 
577
# show we're heeding the default (at run-time, not parse-time!)
 
578
 SHOW CREATE TABLE t1;
 
579
 # show that we didn't break explicit override with ENGINE=...
 
580
SHOW CREATE TABLE t2;
 
581
END;
 
582
|
 
583
CALL bug11758414|
 
584
Variable_name   Value
 
585
storage_engine  MyISAM
 
586
Variable_name   Value
 
587
storage_engine  MyISAM
 
588
Table   Create Table
 
589
t1      CREATE TABLE `t1` (
 
590
  `id` int(11) DEFAULT NULL
 
591
) ENGINE=MyISAM DEFAULT CHARSET=latin1
 
592
Table   Create Table
 
593
t2      CREATE TABLE `t2` (
 
594
  `id` int(11) DEFAULT NULL
 
595
) ENGINE=InnoDB DEFAULT CHARSET=latin1
 
596
SHOW GLOBAL VARIABLES LIKE 'storage_engine'|
 
597
Variable_name   Value
 
598
storage_engine  MyISAM
 
599
SHOW SESSION VARIABLES LIKE 'storage_engine'|
 
600
Variable_name   Value
 
601
storage_engine  MyISAM
 
602
DROP PROCEDURE bug11758414|
 
603
DROP TABLE t1, t2|
 
604
SET @@GLOBAL.storage_engine=@old_engine|