← Back to branch summary

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

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mfrom: (1.2.3)
  • Revision ID: package-import@ubuntu.com-20120222141605-5xu64xtalgrxgoie
Tags: 5.1.61-0ubuntu0.10.10.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
* Dropped patches unnecessary with 5.1.61:
  - debian/patches/61_CVE-2010-3833.dpatch
  - debian/patches/61_CVE-2010-3834.dpatch
  - debian/patches/61_CVE-2010-3835.dpatch
  - debian/patches/61_CVE-2010-3836.dpatch
  - debian/patches/61_CVE-2010-3837.dpatch
  - debian/patches/61_CVE-2010-3838.dpatch
  - debian/patches/61_CVE-2010-3839.dpatch
  - debian/patches/61_CVE-2010-3840.dpatch
  - debian/patches/60_abi-check-include.dpatch
  - debian/patches/62_disable_longfilename_test.dpatch
  - debian/patches/90_fix_testsuite_for_installed_env.dpatch
* debian/mysql-client-5.1.docs: removed EXCEPTIONS-CLIENT file
* debian/mysql-server-5.1.docs,debian/libmysqlclient16.docs,
  debian/libmysqlclient-dev.docs: removed, no longer necessary.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/analyse.result
123
123
ERROR HY000: Incorrect usage of PROCEDURE and non-SELECT
124
124
DROP TABLE t1;
125
125
End of 5.0 tests
 
126
#
 
127
# Bug#11765202: Dbug_violation_helper::~Dbug_violation_helper(): Assertion `!_entered' failed.
 
128
#
 
129
DROP TABLE IF EXISTS t1;
 
130
Warnings:
 
131
Note    1051    Unknown table 't1'
 
132
CREATE TABLE t1 (a VARCHAR(2) CHARSET UTF8 NOT NULL);
 
133
INSERT INTO t1 VALUES ('e'),('e'),('e-');
 
134
SELECT * FROM t1 PROCEDURE ANALYSE();
 
135
Field_name      Min_value       Max_value       Min_length      Max_length      Empties_or_zeros        Nulls   Avg_value_or_avg_length Std     Optimal_fieldtype
 
136
test.t1.a       e       e-      1       2       0       0       1.3333  NULL    ENUM('e','e-') NOT NULL
 
137
DROP TABLE t1;
 
138
#
 
139
# Bug#11756242  48137: PROCEDURE ANALYSE() LEAKS MEMORY WHEN RETURNING NULL
 
140
#
 
141
CREATE TABLE t1(f1 INT) ENGINE=MYISAM;
 
142
CREATE TABLE t2(f2 INT) ENGINE=INNODB;
 
143
INSERT INTO t2 VALUES (1);
 
144
SELECT DISTINCTROW f1 FROM t1 NATURAL RIGHT OUTER JOIN t2 PROCEDURE ANALYSE();
 
145
Field_name      Min_value       Max_value       Min_length      Max_length      Empties_or_zeros        Nulls   Avg_value_or_avg_length Std     Optimal_fieldtype
 
146
test.t1.f1      NULL    NULL    0       0       0       1       0.0     0.0     CHAR(0)
 
147
SELECT * FROM t2 LIMIT 1 PROCEDURE ANALYSE();
 
148
Field_name      Min_value       Max_value       Min_length      Max_length      Empties_or_zeros        Nulls   Avg_value_or_avg_length Std     Optimal_fieldtype
 
149
test.t2.f2      1       1       1       1       0       0       1.0000  0.0000  ENUM('1') NOT NULL
 
150
DROP TABLE t1, t2;
 
151
End of 5.1 tests