SHOW CREATE TABLE and auto_increment

[Kathryn Steinbrink]

Hello.
It is documented in the MySQL 5.1 Reference that the SHOW CREATE TABLE
statement can be used to show the statement syntax that was used to create
the specified table.  For the auto_increment table option, the value that
is returned is the 'next value' that will be generated for the
auto_increment column.  Offhand, this seems wrong.  I would have expected
the original auto_increment= value to be displayed that was indeed
specified on the original CREATE TABLE (or ALTER TABLE) statement.  Can you
please comment?

 If a storage engine has access to the original value, is it okay to return
the original value instead of the 'next value'?  (If not, why not?)

Thanks for your help!


Kathy Steinbrink
Dept 45X - DB2 for i5/OS
IBM Rochester: 015-3 B201
507-253-5545