Bug #3273 The default_table_type is printed as table_type

• Submitted: 23 Mar 2004 13:13
• Modified: 30 Mar 2004 9:15
• Reporter: Miguel Solorzano
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.1
• OS: Any (Any)
• Assigned to: Paul DuBois
• CPU Architecture: Any

[23 Mar 2004 13:13] Miguel Solorzano

Description:
The show variables command shows the variable name as table_type
which confuses the user. Also the Documentation doesn't shows the
correct variable name: default_table_type.

How to repeat:
See description.

Suggested fix:
Change the printed variable name for the show variables command
and to correct the Manual after the fix.

[23 Mar 2004 13:19] Paul DuBois

There is a --default-table-type server *option*, but
there is no *default_table_type* variable.  The variable
is named table_type.

[23 Mar 2004 13:26] MySQL Verification Team

Yes Paul. But our user looking to table_type variable name
had not source documentation for to set the:

default-table-type=table_type

in his my.cnf file correctly.

[30 Mar 2004 9:15] Paul DuBois

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

If this is getting assigned to me, I assume it's a
documentation issue, because I cannot change the variable
name.  I've indicated in the description for the table_type
variable that you set it from the command line using the
--default-table-type option.

Nevertheless, there are issues I believe should be addressed
relating to system variables.  See dev-public@ for
"Worklog #1160 and the system variable situation",
Mon, 29 Mar 2004 08:50:46 -0600.