Re: SHOW TABLE STATUS in MySQL 4.1.latest different from 4.1.1 !? - Paul DuBois - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlRe: SHOW TABLE STATUS in MySQL 4.1.la...

From	Sent On	Attachments
Martijn Tonies	28 Jul 2004 05:20
Martijn Tonies	28 Jul 2004 05:36
Dan Nelson	28 Jul 2004 07:42
Paul DuBois	28 Jul 2004 08:28
Martijn Tonies	28 Jul 2004 09:16

Subject:	Re: SHOW TABLE STATUS in MySQL 4.1.latest different from 4.1.1 !?
From:	Paul DuBois (pa...@mysql.com)
Date:	07/28/2004 08:28:01 AM
List:	com.mysql.lists.mysql

At 14:36 +0200 7/28/04, Martijn Tonies wrote:

Hi Jocelyn,

From the MySQL doc :

The ENGINE and TYPE options specify the storage engine for the table. ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the preferred option name as of those versions, and TYPE has become deprecated. TYPE will be supported throughout the 4.x series, but likely will be removed in MySQL 5.1.

So I assume it makes sense to change it also for SHOW TABLE STATUS :)

Well, in that case - the documentation fails to document the behaviour :-)

The latest 4.1 beta does NOT have a "Type" column.

The current manual does document it:

http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html

Remove it in 5 or 5.1, fine - that's a major (and next major minor release). But not in a sub-minor release.

A mistake then?

A decision you disagree with.

It's hard to win on this kind of thing. If we don't make changes, people say development is too slow. If we do, development is said to be arbitrary. Anyway, it's documented now.

With regards,

I just noticed that the MySQL 4.1.latest version handles a SHOW TABLE STATUS different from 4.1.1!

Instead of a field "Type" that holds the table type, it's now "Engine".

Just a quick question: who makes up these changes in a minor minor (x.x.x) release???? What do they expect from third party developers?

In short: this is a stupid change.

With regards,

Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com