← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/suite/parts/inc/part_supported_sql_funcs_main.inc

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mfrom: (1.1.5)
  • Revision ID: package-import@ubuntu.com-20120222223355-or06x1euyk8n0ldi
Tags: 5.1.61-0ubuntu0.10.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
* Dropped patches unnecessary with 5.1.61:
  - debian/patches/90_mysql_safer_strmov.dpatch
  - debian/patches/51_ssl_test_certs.dpatch
  - debian/patches/52_CVE-2009-4030.dpatch
  - debian/patches/53_CVE-2009-4484.dpatch
  - debian/patches/54_CVE-2008-7247.dpatch
  - debian/patches/55_CVE-2010-1621.dpatch
  - debian/patches/56_CVE-2010-1850.dpatch
  - debian/patches/57_CVE-2010-1849.dpatch
  - debian/patches/58_CVE-2010-1848.dpatch
  - debian/patches/59_CVE-2010-1626.dpatch
  - debian/patches/60_CVE-2010-2008.dpatch
  - debian/patches/60_CVE-2010-3677.dpatch
  - debian/patches/60_CVE-2010-3678.dpatch
  - debian/patches/60_CVE-2010-3679.dpatch
  - debian/patches/60_CVE-2010-3680.dpatch
  - debian/patches/60_CVE-2010-3681.dpatch
  - debian/patches/60_CVE-2010-3682.dpatch
  - debian/patches/60_CVE-2010-3683.dpatch
  - debian/patches/60_CVE-2010-3833.dpatch
  - debian/patches/60_CVE-2010-3834.dpatch
  - debian/patches/60_CVE-2010-3835.dpatch
  - debian/patches/60_CVE-2010-3836.dpatch
  - debian/patches/60_CVE-2010-3837.dpatch
  - debian/patches/60_CVE-2010-3838.dpatch
  - debian/patches/60_CVE-2010-3839.dpatch
  - debian/patches/60_CVE-2010-3840.dpatch
  - debian/patches/61_disable_longfilename_test.dpatch
  - debian/patches/62_alter_table_fix.dpatch
  - debian/patches/63_cherrypick-upstream-49479.dpatch
  - debian/patches/10_readline_build_fix.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/suite/parts/inc/part_supported_sql_funcs_main.inc
39
39
let $val4 = 15 ;
40
40
--source suite/parts/inc/partition_supported_sql_funcs.inc
41
41
 
42
 
 
43
 
let $sqlfunc = ceiling(col1);
44
 
let $valsqlfunc = ceiling(15);
45
 
let $coltype = float(7,4);
46
 
let $infile = part_supported_sql_funcs_int_float.inc;
47
 
let $val1 =  5.1230;
48
 
let $val2 = 13.345;
49
 
let $val3 = 17.987;
50
 
let $val4 = 15.654 ;
51
 
# DISABLED due to bug 30577
52
 
#--source suite/parts/inc/partition_supported_sql_funcs.inc
53
 
 
54
 
let $sqlfunc = floor(col1);
55
 
let $valsqlfunc = floor(15.123);
56
 
let $coltype = float(7,4);
57
 
let $infile = part_supported_sql_funcs_int_float.inc;
58
 
let $val1 =  5.1230;
59
 
let $val2 = 13.345;
60
 
let $val3 = 17.987;
61
 
let $val4 = 15.654 ;
62
 
# DISABLED due to bug 30577
63
 
#--source suite/parts/inc/partition_supported_sql_funcs.inc
64
 
 
65
42
let $sqlfunc = mod(col1,10);
66
43
let $valsqlfunc = mod(15,10);
67
44
let $coltype = int;
111
88
let $val3 =  '2006-02-25';
112
89
let $val4 =  '2006-02-05';
113
90
--source suite/parts/inc/partition_supported_sql_funcs.inc
114
 
let $coltype = char(30);
115
 
--source suite/parts/inc/partition_supported_sql_funcs.inc
 
91
# Disabled after fixing bug#54483.
 
92
#let $coltype = char(30);
 
93
#--source suite/parts/inc/partition_supported_sql_funcs.inc
116
94
 
117
95
let $sqlfunc = extract(month from col1);
118
96
let $valsqlfunc = extract(year from '1998-11-23');
162
140
let $val3 =  '21:59:22';
163
141
let $val4 =  '10:22:33';
164
142
--source suite/parts/inc/partition_supported_sql_funcs.inc
165
 
let $coltype = char(30);
166
 
--source suite/parts/inc/partition_supported_sql_funcs.inc
 
143
# second(non_time_col) is disabled after bug#54483.
 
144
#let $coltype = char(30);
 
145
#--source suite/parts/inc/partition_supported_sql_funcs.inc
167
146
 
168
147
let $sqlfunc = month(col1);
169
148
let $valsqlfunc = month('2006-10-14');
195
174
let $val4 =  '10:33:11';
196
175
--source suite/parts/inc/partition_supported_sql_funcs.inc
197
176
 
198
 
let $sqlfunc = to_days(col1)-to_days('2006-01-01');
199
 
let $valsqlfunc = to_days('2006-02-02')-to_days('2006-01-01');
200
 
let $coltype = date;
201
 
let $infile = part_supported_sql_funcs_int_date.inc;
202
 
let $val1 =  '2006-02-03';
203
 
let $val2 =  '2006-01-17';
204
 
let $val3 =  '2006-01-25';
205
 
let $val4 =  '2006-02-06';
206
 
--source suite/parts/inc/partition_supported_sql_funcs.inc
 
177
# to_days(non_date_col) is disabled after bug#54483.
 
178
#let $sqlfunc = to_days(col1)-to_days('2006-01-01');
 
179
#let $valsqlfunc = to_days('2006-02-02')-to_days('2006-01-01');
 
180
#let $coltype = date;
 
181
#let $infile = part_supported_sql_funcs_int_date.inc;
 
182
#let $val1 =  '2006-02-03';
 
183
#let $val2 =  '2006-01-17';
 
184
#let $val3 =  '2006-01-25';
 
185
#let $val4 =  '2006-02-06';
 
186
#--source suite/parts/inc/partition_supported_sql_funcs.inc
207
187
 
 
188
# to_days(non_date_col) is disabled after bug#54483.
208
189
# DATEDIFF() is implemented as (TO_DAYS(d1) - TO_DAYS(d2))
209
 
let $sqlfunc = datediff(col1, '2006-01-01');
210
 
let $valsqlfunc = datediff('2006-02-02', '2006-01-01');
211
 
let $coltype = date;
212
 
let $infile = part_supported_sql_funcs_int_date.inc;
213
 
let $val1 =  '2006-02-03';
214
 
let $val2 =  '2006-01-17';
215
 
let $val3 =  '2006-01-25';
216
 
let $val4 =  '2006-02-06';
217
 
--source suite/parts/inc/partition_supported_sql_funcs.inc
 
190
#let $sqlfunc = datediff(col1, '2006-01-01');
 
191
#let $valsqlfunc = datediff('2006-02-02', '2006-01-01');
 
192
#let $coltype = date;
 
193
#let $infile = part_supported_sql_funcs_int_date.inc;
 
194
#let $val1 =  '2006-02-03';
 
195
#let $val2 =  '2006-01-17';
 
196
#let $val3 =  '2006-01-25';
 
197
#let $val4 =  '2006-02-06';
 
198
#--source suite/parts/inc/partition_supported_sql_funcs.inc
218
199
 
219
200
let $sqlfunc = weekday(col1);
220
201
let $valsqlfunc = weekday('2006-10-14');