← 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/type_newdecimal.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/type_newdecimal.result
1549
1549
5.05 / 0.014
1550
1550
360.714286
1551
1551
DROP TABLE t1;
 
1552
#
 
1553
# Bug#12563865
 
1554
# ROUNDED,TMP_BUF,DECIMAL_VALUE STACK CORRUPTION IN ALL VERSIONS >=5.0
 
1555
#
 
1556
SELECT substring(('M') FROM (999999999999999999999999999999999999999999999999999999999999999999999999999999999)) AS foo;
 
1557
foo
 
1558
 
 
1559
Warnings:
 
1560
Error   1292    Truncated incorrect DECIMAL value: ''
 
1561
Error   1292    Truncated incorrect DECIMAL value: ''
 
1562
SELECT min(999999999999999999999999999999999999999999999999999999999999999999999999999999999) AS foo;
 
1563
foo
 
1564
999999999999999999999999999999999999999999999999999999999999999999999999999999999
 
1565
SELECT multipolygonfromtext(('4294967294.1'),(999999999999999999999999999999999999999999999999999999999999999999999999999999999)) AS foo;
 
1566
foo
 
1567
NULL
 
1568
Warnings:
 
1569
Error   1292    Truncated incorrect DECIMAL value: ''
 
1570
SELECT convert((999999999999999999999999999999999999999999999999999999999999999999999999999999999), decimal(30,30)) AS foo;
 
1571
foo
 
1572
0.999999999999999999999999999999
 
1573
Warnings:
 
1574
Error   1264    Out of range value for column 'foo' at row 1
 
1575
SELECT bit_xor(999999999999999999999999999999999999999999999999999999999999999999999999999999999) AS foo;
 
1576
foo
 
1577
9223372036854775807
 
1578
Warnings:
 
1579
Error   1292    Truncated incorrect DECIMAL value: ''
 
1580
SELECT -(999999999999999999999999999999999999999999999999999999999999999999999999999999999) AS foo;
 
1581
foo
 
1582
-999999999999999999999999999999999999999999999999999999999999999999999999999999999
 
1583
SELECT date_sub((999999999999999999999999999999999999999999999999999999999999999999999999999999999),
 
1584
interval ((SELECT date_add((0x77500000),
 
1585
interval ('Oml') second)))
 
1586
day_minute)
 
1587
AS foo;
 
1588
foo
 
1589
NULL
 
1590
Warnings:
 
1591
Error   1292    Truncated incorrect DECIMAL value: ''
 
1592
Warning 1292    Incorrect datetime value: '9223372036854775807'
 
1593
SELECT truncate(999999999999999999999999999999999999999999999999999999999999999999999999999999999, 28) AS foo;
 
1594
foo
 
1595
999999999999999999999999999999999999999999999999999999999999999999999999999999999
1552
1596
End of 5.0 tests
1553
1597
select cast(143.481 as decimal(4,1));
1554
1598
cast(143.481 as decimal(4,1))
1913
1957
mult    v_net_with_discount     v_total
1914
1958
1.0000  27.18   27.180000
1915
1959
DROP TABLE currencies, payments, sub_tasks;
 
1960
#
 
1961
# Bug#55436: buffer overflow in debug binary of dbug_buff in
 
1962
#            Field_new_decimal::store_value
 
1963
#
 
1964
SET SQL_MODE='';
 
1965
CREATE TABLE t1(f1 DECIMAL(44,24)) ENGINE=MYISAM;
 
1966
INSERT INTO t1 SET f1 = -64878E-85;
 
1967
Warnings:
 
1968
Note    1265    Data truncated for column 'f1' at row 1
 
1969
SELECT f1 FROM t1;
 
1970
f1
 
1971
0.000000000000000000000000
 
1972
DROP TABLE IF EXISTS t1;
1916
1973
End of 5.1 tests
 
1974
#
 
1975
# BUG#12911710 - VALGRIND FAILURE IN 
 
1976
# ROW-DEBUG:PERFSCHEMA.SOCKET_SUMMARY_BY_INSTANCE_FUNC 
 
1977
#
 
1978
CREATE TABLE t1(d1 DECIMAL(60,0) NOT NULL,
 
1979
d2 DECIMAL(60,0) NOT NULL);
 
1980
INSERT INTO t1 (d1, d2) VALUES(0.0, 0.0);
 
1981
SELECT d1 * d2 FROM t1;
 
1982
d1 * d2
 
1983
0
 
1984
DROP TABLE t1;