| Bug #55855 | information_schema.parameters.numeric_precision should be bigint | ||
|---|---|---|---|
| Submitted: | 9 Aug 2010 18:42 | Modified: | 21 Mar 2011 19:29 |
| Reporter: | Peter Gulutzan | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
| Version: | 5.6.0-m4 | OS: | Linux (SUSE 64-bit) |
| Assigned to: | Mayank Prasad | CPU Architecture: | Any |
[9 Aug 2010 18:51]
MySQL Verification Team
Thank you for the bug report.
miguel@tikal ~]$ dbs/bf/bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.0-m4-debug Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select table_name, data_type, column_type
-> from information_schema.columns
-> where column_name = 'numeric_precision'
-> and table_schema = 'information_schema';
+------------+-----------+---------------------+
| table_name | data_type | column_type |
+------------+-----------+---------------------+
| COLUMNS | bigint | bigint(21) unsigned |
| PARAMETERS | int | int(21) |
| ROUTINES | int | int(21) |
+------------+-----------+---------------------+
3 rows in set (0.03 sec)
mysql>
[21 Mar 2011 19:29]
Paul DuBois
Code cleanup. No changelog entry needed. CHANGESET - http://lists.mysql.com/commits/132878
Description: In the original specification for the information_schema.parameters table, the request was: NUMERIC_PRECISION same as for COLUMNS But information_schema.columns.numeric_precision is BIGINT UNSIGNED. And information_schema.parameters.numeric_precision is INT. How to repeat: mysql> select table_name, data_type, column_type -> from information_schema.columns -> where column_name = 'numeric_precision' -> and table_schema = 'information_schema'; +------------+-----------+---------------------+ | table_name | data_type | column_type | +------------+-----------+---------------------+ | COLUMNS | bigint | bigint(21) unsigned | | PARAMETERS | int | int(21) | | ROUTINES | int | int(21) | +------------+-----------+---------------------+ 3 rows in set (0.03 sec)