Bug #34818 --default-table-type option should be removed
Submitted: 25 Feb 2008 21:36 Modified: 3 Nov 16:14
Reporter: Paul DuBois
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: Konstantin Osipov Target Version:
Triage: Triaged: D4 (Minor)

[25 Feb 2008 21: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 22:26] Miguel Solorzano 
Thank you for the bug report.
[2 Oct 2008 17: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 17: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 17:13] Konstantin Osipov 
Queued into 6.0-runtime
[24 Oct 2008 3: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 5:49] Paul DuBois 
Noted in 6.0.8 changelog.

The deprecated --default-table-type server option has been removed.
[14 Oct 13:35] Konstantin Osipov 
Fixed in 5.5.0.
[14 Oct 13: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 17:05] Paul DuBois 
Noted in 5.5.0 changelog.
[3 Nov 8: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 16:14] Paul DuBois 
Already fixed in earlier 6.0.x release.