Bug #5299 Remove SHOW COLUMN TYPES
| Submitted: | 30 Aug 2004 20:15 | Modified: | 12 Nov 2009 18:29 |
|---|---|---|---|
| Reporter: | Trudy Pelzer | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 4.1.4-gamma (ndb),5.0.37 | OS: | Any |
| Assigned to: | Sergei Glukhov | CPU Architecture: | Any |
[30 Aug 2004 20:15]
Trudy Pelzer
[31 Aug 2004 5:30]
MySQL Verification Team
Than you for the bug report. I was able to repeat.
[23 Sep 2006 21:23]
Andris Kardos
Would be a very nice addition to the information schema tables!
[2 May 2007 0:56]
Todd Farmer
What should be done with this? The problem remains in 5.0.37:
mysql> show column types\G
*************************** 1. row ***************************
Type: tinyint
Size: 1
Min_Value: -128
Max_Value: 127
Prec: 0
Scale: 0
Nullable: YES
Auto_Increment: YES
Unsigned: NO
Zerofill: YES
Searchable: YES
Case_Sensitive: NO
Default: NULL,0
Comment: A very small integer
*************************** 2. row ***************************
Type: tinyint unsigned
Size: 1
Min_Value: 0
Max_Value: 255
Prec: 0
Scale: 0
Nullable: YES
Auto_Increment: YES
Unsigned: YES
Zerofill: YES
Searchable: YES
Case_Sensitive: NO
Default: NULL,0
Comment: A very small integer
2 rows in set (0.00 sec)
mysql>
There is no online documentation for this command, nor is there anything HELP:
mysql> help show column types;
Nothing found
Please try to run 'help contents' for a list of all accessible topics
[2 May 2007 20:23]
Timothy Smith
The agreement seems to be to remove this statement. It's never been documented nor complete.
[2 May 2007 21:03]
Jim Winstead
if we're to have a proper implementation of SQLGetTypeInfo() in the ODBC driver, we need some way of getting real info about the server's types. (whether a SHOW statement or an INFORMATION_SCHEMA table.) see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlgettypein...
[28 Mar 2008 10:01]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/44565 ChangeSet@1.2602, 2008-03-28 13:52:18+04:00, gluh@mysql.com +8 -0 Bug#5299 Remove SHOW COLUMN TYPES Removed 'SHOW COLUMN TYPES' command
[19 Apr 2008 13:53]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/45652 ChangeSet@1.2608, 2008-04-19 18:50:22+05:00, gluh@mysql.com +1 -0 Bug#5299 Remove SHOW COLUMN TYPES added 'deprecated' warning for SHOW COLUMN TYPES command, this command will be removed in 6.0 version
[19 Apr 2008 14:54]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/45655 ChangeSet@1.2620, 2008-04-19 19:52:10+05:00, gluh@mysql.com +10 -0 Bug#5299 Remove SHOW COLUMN TYPES Removed 'SHOW COLUMN TYPES' command
[19 Apr 2008 17:23]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/45661 ChangeSet@1.2609, 2008-04-19 22:21:51+05:00, gluh@mysql.com +1 -0 Bug#5299 Remove SHOW COLUMN TYPES result fix
[28 May 2008 10:02]
Bugs System
Pushed into 6.0.6-alpha
[29 May 2008 3:22]
Paul DuBois
Noted in 6.0.6 changelog. The undocumented, deprecated, and not useful SHOW COLUMN TYPES statement has been removed.
[23 Oct 2009 7:19]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/87887 2914 Sergey Glukhov 2009-10-23 Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ mysql-test/r/show_check.result Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ mysql-test/r/signal_code.result Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ mysql-test/r/sp-code.result Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ mysql-test/r/sp.result Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ mysql-test/t/show_check.test Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ mysql-test/t/sp.test Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ sql/mysqld.cc Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ sql/sp_head.cc Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ sql/sql_lex.h Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ sql/sql_parse.cc Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ sql/sql_prepare.cc Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ sql/sql_show.cc Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony @ sql/sql_yacc.yy Bug#5299 Remove SHOW COLUMN TYPES, backport to Betony
[31 Oct 2009 8:16]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091031081410-qkxmjsdzjmj840aq) (version source revid:lars-erik.bjork@sun.com-20091023144402-05x9kn8fz878z011) (merge vers: 6.0.14-alpha) (pib:13)
[31 Oct 2009 17:21]
Paul DuBois
Already fixed in 6.0.6. Setting report to NDI pending push to 5.5.x
[12 Nov 2009 8:21]
Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091110093229-0bh5hix780cyeicl) (version source revid:mikael@mysql.com-20091102100915-a2nbfxaqprpgptfw) (merge vers: 5.5.0-beta) (pib:13)
[12 Nov 2009 18:29]
Paul DuBois
Noted in 5.5.0 changelog.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.103 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.