← 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/information_schema.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/information_schema.result
1757
1757
COLUMN_DEFAULT  TABLE_NAME
1758
1758
NULL    variables
1759
1759
DROP TABLE variables;
 
1760
#
 
1761
# Bug #53814: NUMERIC_PRECISION for unsigned bigint field is 19, 
 
1762
# should be 20
 
1763
#
 
1764
CREATE TABLE ubig (a BIGINT, b BIGINT UNSIGNED);
 
1765
SELECT TABLE_NAME, COLUMN_NAME, NUMERIC_PRECISION 
 
1766
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='ubig';
 
1767
TABLE_NAME      COLUMN_NAME     NUMERIC_PRECISION
 
1768
ubig    a       19
 
1769
ubig    b       20
 
1770
INSERT INTO ubig VALUES (0xFFFFFFFFFFFFFFFF,0xFFFFFFFFFFFFFFFF);
 
1771
Warnings:
 
1772
Warning 1264    Out of range value for column 'a' at row 1
 
1773
SELECT length(CAST(b AS CHAR)) FROM ubig;
 
1774
length(CAST(b AS CHAR))
 
1775
20
 
1776
DROP TABLE ubig;
1760
1777
End of 5.1 tests.