← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2012-02-14 23:59:22 UTC
  • mfrom: (1.1.2)
  • Revision ID: package-import@ubuntu.com-20120214235922-cux5uek1e5l0hje9
Tags: 5.5.20-0ubuntu1
https://launchpad.net/bugs/688541
https://launchpad.net/bugs/907465
https://launchpad.net/bugs/917542
https://launchpad.net/bugs/912487
http://bugs.debian.org/659566
* New upstream release.
* d/mysql-server-5.5.mysql.upstart: Fix stop on to make sure mysql is
  fully stopped before shutdown commences. (LP: #688541) Also simplify
  start on as it is redundant.
* d/control: Depend on upstart version which has apparmor profile load
  script to prevent failure on upgrade from lucid to precise.
  (LP: #907465)
* d/apparmor-profile: need to allow /run since that is the true path
  of /var/run files. (LP: #917542)
* d/control: mysql-server-5.5 has files in it that used to be owned
  by libmysqlclient-dev, so it must break/replace it. (LP: #912487)
* d/rules, d/control: 5.5.20 Fixes segfault on tests with gcc 4.6,
  change compiler back to system default.
* d/rules: Turn off embedded libedit/readline.(Closes: #659566)

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/type_newdecimal.result
1544
1544
5.05 / 0.014
1545
1545
360.714286
1546
1546
DROP TABLE t1;
 
1547
#
 
1548
# Bug#12563865
 
1549
# ROUNDED,TMP_BUF,DECIMAL_VALUE STACK CORRUPTION IN ALL VERSIONS >=5.0
 
1550
#
 
1551
SELECT substring(('M') FROM (999999999999999999999999999999999999999999999999999999999999999999999999999999999)) AS foo;
 
1552
foo
 
1553
 
 
1554
Warnings:
 
1555
Warning 1292    Truncated incorrect DECIMAL value: ''
 
1556
Warning 1292    Truncated incorrect DECIMAL value: ''
 
1557
SELECT min(999999999999999999999999999999999999999999999999999999999999999999999999999999999) AS foo;
 
1558
foo
 
1559
999999999999999999999999999999999999999999999999999999999999999999999999999999999
 
1560
SELECT multipolygonfromtext(('4294967294.1'),(999999999999999999999999999999999999999999999999999999999999999999999999999999999)) AS foo;
 
1561
foo
 
1562
NULL
 
1563
Warnings:
 
1564
Warning 1292    Truncated incorrect DECIMAL value: ''
 
1565
SELECT convert((999999999999999999999999999999999999999999999999999999999999999999999999999999999), decimal(30,30)) AS foo;
 
1566
foo
 
1567
0.999999999999999999999999999999
 
1568
Warnings:
 
1569
Warning 1264    Out of range value for column 'foo' at row 1
 
1570
SELECT bit_xor(999999999999999999999999999999999999999999999999999999999999999999999999999999999) AS foo;
 
1571
foo
 
1572
9223372036854775807
 
1573
Warnings:
 
1574
Warning 1292    Truncated incorrect DECIMAL value: ''
 
1575
SELECT -(999999999999999999999999999999999999999999999999999999999999999999999999999999999) AS foo;
 
1576
foo
 
1577
-999999999999999999999999999999999999999999999999999999999999999999999999999999999
 
1578
SELECT date_sub((999999999999999999999999999999999999999999999999999999999999999999999999999999999),
 
1579
interval ((SELECT date_add((0x77500000),
 
1580
interval ('Oml') second)))
 
1581
day_minute)
 
1582
AS foo;
 
1583
foo
 
1584
NULL
 
1585
Warnings:
 
1586
Warning 1292    Truncated incorrect DECIMAL value: ''
 
1587
Warning 1292    Incorrect datetime value: '9223372036854775807'
 
1588
SELECT truncate(999999999999999999999999999999999999999999999999999999999999999999999999999999999, 28) AS foo;
 
1589
foo
 
1590
999999999999999999999999999999999999999999999999999999999999999999999999999999999
1547
1591
End of 5.0 tests
1548
1592
select cast(143.481 as decimal(4,1));
1549
1593
cast(143.481 as decimal(4,1))