From: Martijn Tonies
Date: July 28 2004 12:36pm
Subject: Re: SHOW TABLE STATUS in MySQL 4.1.latest different from 4.1.1 !?
List-Archive: http://lists.mysql.com/mysql/169877
Message-Id: <027f01c4749f$8f6f61c0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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.

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?

With regards,

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


> >
> > 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
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
http://lists.mysql.com/mysql?unsub=joc@stripped
> >
> >