Bug #34818 --default-table-type option should be removed
Submitted: 25 Feb 2008 20:36 Modified: 12 Nov 2009 18:35
Reporter: Paul DuBois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: Konstantin Osipov CPU Architecture:Any

[25 Feb 2008 20:36] Paul DuBois
Description:
In MySQL 5.1, a bunch of things were deprecated and then removed in 5.2.5. One of these was the table_type system variable (has been superseded by the storage_engine) system variable.

There is a related --default-table-type option, which is deprecated in favor of the --default-storage-engine option.  Given that table_type was removed, I suggest that --default-table-type should be removed as well.

Here's the cset for the removed constructs:

ChangeSet@1.2469.259.1, 2007-05-05 13:03:19-07:00, serg@sergbook.mysql.com +71 -0
  Removing deprecated features:
  --master-XXX command-line options
  log_bin_trust_routine_creators
  table_type
  BACKUP TABLE ...
  RESTORE TABLE ...
  SHOW PLUGIN
  LOAD TABLE ... FROM MASTER
  LOAD DATA FROM MASTER  SHOW INNODB STATUS
  SHOW MUTEX STATUS
  SHOW TABLE TYPES
  ... TIMESTAMP(N)
  ... TYPE=engine

How to repeat:
N/A
[25 Feb 2008 21:26] MySQL Verification Team
Thank you for the bug report.
[2 Oct 2008 15:08] 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/55102

2719 Konstantin Osipov	2008-10-02
      Bug #34818 --default-table-type option should be removed
      Remove the deprecated option.
[2 Oct 2008 15:09] 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/55103

2719 Konstantin Osipov	2008-10-02
      Bug #34818 --default-table-type option should be removed
      Remove the deprecated option.
[2 Oct 2008 15:13] Konstantin Osipov
Queued into 6.0-runtime
[24 Oct 2008 1:18] Bugs System
Pushed into 6.0.8-alpha  (revid:kostja@sun.com-20081002150809-73gt183qvb3ugehs) (version source revid:kostja@sun.com-20081002150809-73gt183qvb3ugehs) (pib:5)
[24 Oct 2008 3:49] Paul DuBois
Noted in 6.0.8 changelog.

The deprecated --default-table-type server option has been removed.
[14 Oct 2009 11:35] Konstantin Osipov
Fixed in 5.5.0.
[14 Oct 2009 11:35] 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/86786

2919 Konstantin Osipov	2009-10-14
      Backport of:
      ----------------------------------------------------------
      revno: 2630.22.31
      committer: Konstantin Osipov <kostja@sun.com>
      branch nick: mysql-6.0-runtime
      timestamp: Thu 2008-10-02 19:08:09 +0400
      message:
        Bug #34818 --default-table-type option should be removed
        Remove the deprecated option.
     @ sql/mysqld.cc
        Remove a deprecated option.
[14 Oct 2009 15:05] Paul DuBois
Noted in 5.5.0 changelog.
[3 Nov 2009 7:17] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091102151658-j9o4wgro47m5v84d) (version source revid:alik@sun.com-20091023064702-2f8jdmny61bdl94u) (merge vers: 6.0.14-alpha) (pib:13)
[3 Nov 2009 15:14] Paul DuBois
Already fixed in earlier 6.0.x release.
[12 Nov 2009 8:22] Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091110093229-0bh5hix780cyeicl) (version source revid:mikael@mysql.com-20091103113702-p61dlwc6ml6fxg18) (merge vers: 5.5.0-beta) (pib:13)