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

  • 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/t/information_schema.test
1455
1455
WHERE INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = 'variables';
1456
1456
DROP TABLE variables;
1457
1457
 
 
1458
--echo #
 
1459
--echo # Bug #53814: NUMERIC_PRECISION for unsigned bigint field is 19, 
 
1460
--echo # should be 20
 
1461
--echo #
 
1462
 
 
1463
CREATE TABLE ubig (a BIGINT, b BIGINT UNSIGNED);
 
1464
 
 
1465
SELECT TABLE_NAME, COLUMN_NAME, NUMERIC_PRECISION 
 
1466
  FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='ubig';
 
1467
 
 
1468
INSERT INTO ubig VALUES (0xFFFFFFFFFFFFFFFF,0xFFFFFFFFFFFFFFFF);
 
1469
SELECT length(CAST(b AS CHAR)) FROM ubig;
 
1470
 
 
1471
DROP TABLE ubig;
 
1472
 
 
1473
 
1458
1474
--echo End of 5.1 tests.
1459
1475
 
1460
1476
# Wait till all disconnects are completed