← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.5/trusty-updates

« back to all changes in this revision

Viewing changes to mysql-test/t/information_schema.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2015-04-20 09:30:47 UTC
  • mfrom: (1.1.22)
  • Revision ID: package-import@ubuntu.com-20150420093047-yd9g5p2hesgvlzwm
Tags: 5.5.43-0ubuntu0.14.04.1
https://launchpad.net/bugs/1444616
* SECURITY UPDATE: Update to 5.5.43 to fix security issues (LP: #1444616)
  - http://www.oracle.com/technetwork/topics/security/cpuapr2015-2365600.html
  - CVE-2015-0433
  - CVE-2015-0441
  - CVE-2015-0499
  - CVE-2015-0501
  - CVE-2015-0505
  - CVE-2015-2568
  - CVE-2015-2571
  - CVE-2015-2573

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/information_schema.test
1782
1782
--echo # Clean-up.
1783
1783
drop database mysqltest;
1784
1784
 
 
1785
--echo #
 
1786
--echo # Test for bug #16869534 - "QUERYING SUBSET OF COLUMNS DOESN'T USE TABLE
 
1787
--echo #                           CACHE; OPENED_TABLES INCREASES"
 
1788
--echo #
 
1789
--disable_result_log
 
1790
SELECT * FROM INFORMATION_SCHEMA.TABLES;
 
1791
--enable_result_log
 
1792
SELECT VARIABLE_VALUE INTO @val1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE
 
1793
  VARIABLE_NAME LIKE 'Opened_tables';
 
1794
--disable_result_log
 
1795
SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES;
 
1796
--enable_result_log
 
1797
--echo # The below SELECT query should give same output as above SELECT query.
 
1798
SELECT VARIABLE_VALUE INTO @val2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE
 
1799
  VARIABLE_NAME LIKE 'Opened_tables';
 
1800
--echo # The below select should return '1'
 
1801
SELECT @val1 = @val2;
1785
1802
 
1786
1803
--echo #
1787
1804
--echo # End of 5.5 tests