SHOW tables and SHOW columns don't work as expected

[mauritslamers]

When a SHOW TABLES or SHOW COLUMNS FROM [table] query is performed, the data returning is not in a format that is easy to parse.

When performing SHOW TABLES the field name is undefined, resulting in an object with a series of undefined keys. The values are correct

When performing SHOW COLUMNS FROM [table] the result isn't usable: the contents of results and fields by using sys.inspect:

22 Aug 14:58:28 - results: [ { undefined: 'auto_increment' } ]
22 Aug 14:58:28 - fields: { undefined:
{ length: 39
, received: 39
, number: 7
, type: 4
, catalog: 'def'
, db: '\u0007COLUMNS\u0000\u0005Extra\u0005EXTRA\f\b\u0000\u0014\u0000\u0000\u0000\u00fd\u0001\u0000\u0000\u0000\u0000'
}
}

[felixge]

Duplicate of #5 (which has just been fixed).