[MDEV-6758] include SHOW COLUMNS - comment column (mysql bud 27661) Created: 2014-09-18  Updated: 2014-10-09  Resolved: 2014-10-09

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: N/A

Type: Task Priority: Trivial
Reporter: roberto spadim Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None


 Description   
Field Type Null Key Default Extra
emitente_tipo enum('f','j') NO PRI f  

include the comment column (maybe others columns?)

Field Type Null Key Default Extra Comment
emitente_tipo enum('f','j') NO PRI f   hello!

http://bugs.mysql.com/bug.php?id=27661&thanks=2&notify=215

 Comments   
Comment by Sergei Golubchik [ 2014-10-09 ]

I don't think so. SHOW commands are like easy-to-use aliases for INFORMATION_SCHEMA tables — short to type and return less columns to fit nicely on the screen (with some historical exceptions).

SHOW COLUMNS is good as it is, if we start adding more columns to it, it will be too wide and might start wrapping around in the terminal. Use INFORMATION_SCHEMA.COLUMNS to get column metadata that are not shown by SHOW COLUMNS.

Comment by roberto spadim [ 2014-10-09 ]

nice =] just to have a position about mysql bug thanks sergey! i will link it with mysql bug if something changes there we know about this one

Generated at Thu Feb 08 07:14:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.