You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Christoffer Hammarström (JIRA)" <ji...@apache.org> on 2005/10/13 14:40:04 UTC
[jira] Created: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
I want to be able to specify the table type/engine when i create tables in mysql.
---------------------------------------------------------------------------------
Key: DDLUTILS-32
URL: http://issues.apache.org/jira/browse/DDLUTILS-32
Project: DdlUtils
Type: New Feature
Reporter: Christoffer Hammarström
Assigned to: Thomas Dudziak
In MySQL, a table type or engine can be specified after the "create table" statement, like so:
CREATE TABLE table
(
column INTEGER
) ENGINE=InnoDB
"TYPE" is a synonym for "ENGINE".
http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Resolved: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=all ]
Thomas Dudziak resolved DDLUTILS-32:
------------------------------------
Resolution: Fixed
I've added this facility, but slightly enhanced. You can also specify for which tables to apply the parameter, and you can state all parameters that MySql supports (there is no check of the validity of the parameter or its value):
<writeSchemaSqlToFile failonerror="false"
alterdatabase="false"
outputfile="test.sql">
<parameter name="ENGINE"
value="INNODB"
platforms="MySql"
tables="test1,test2,test"/>
<parameter name="ENGINE"
value="MEMORY"
platforms="MySql"
table="test3"/>
<parameter name="ROW_FORMAT"
value="COMPRESSED"
platforms="MySql"/>
</writeSchemaSqlToFile>
> I want to be able to specify the table type/engine when i create tables in mysql.
> ---------------------------------------------------------------------------------
>
> Key: DDLUTILS-32
> URL: http://issues.apache.org/jira/browse/DDLUTILS-32
> Project: DdlUtils
> Type: New Feature
> Reporter: Christoffer Hammarström
> Assignee: Thomas Dudziak
> Attachments: DDLUTILS-32.patch
>
> In MySQL, a table type or engine can be specified after the "create table" statement, like so:
> CREATE TABLE table
> (
> column INTEGER
> ) ENGINE=InnoDB
> "TYPE" is a synonym for "ENGINE".
> http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=comments#action_12355950 ]
Thomas Dudziak commented on DDLUTILS-32:
----------------------------------------
Sorry, I was out-of-country for a couple of days.
I think I'll add this in the next days as it is useful for other things as well (eg. switching between unicode and ascii columns for Oracle databases).
> I want to be able to specify the table type/engine when i create tables in mysql.
> ---------------------------------------------------------------------------------
>
> Key: DDLUTILS-32
> URL: http://issues.apache.org/jira/browse/DDLUTILS-32
> Project: DdlUtils
> Type: New Feature
> Reporter: Christoffer Hammarström
> Assignee: Thomas Dudziak
> Attachments: DDLUTILS-32.patch
>
> In MySQL, a table type or engine can be specified after the "create table" statement, like so:
> CREATE TABLE table
> (
> column INTEGER
> ) ENGINE=InnoDB
> "TYPE" is a synonym for "ENGINE".
> http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
Posted by "Christoffer Hammarström (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=comments#action_12358632 ]
Christoffer Hammarström commented on DDLUTILS-32:
-------------------------------------------------
Great, thanks!
> I want to be able to specify the table type/engine when i create tables in mysql.
> ---------------------------------------------------------------------------------
>
> Key: DDLUTILS-32
> URL: http://issues.apache.org/jira/browse/DDLUTILS-32
> Project: DdlUtils
> Type: New Feature
> Reporter: Christoffer Hammarström
> Assignee: Thomas Dudziak
> Attachments: DDLUTILS-32.patch
>
> In MySQL, a table type or engine can be specified after the "create table" statement, like so:
> CREATE TABLE table
> (
> column INTEGER
> ) ENGINE=InnoDB
> "TYPE" is a synonym for "ENGINE".
> http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
Posted by "Christoffer Hammarström (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=comments#action_12331984 ]
Christoffer Hammarström commented on DDLUTILS-32:
-------------------------------------------------
To clarify, this patch allows the following syntax:
<writeschemasqltofile outputfile="ddl.sql">
<parameter name="ENGINE" value="InnoDB"/>
</writeschemasqltofile>
> I want to be able to specify the table type/engine when i create tables in mysql.
> ---------------------------------------------------------------------------------
>
> Key: DDLUTILS-32
> URL: http://issues.apache.org/jira/browse/DDLUTILS-32
> Project: DdlUtils
> Type: New Feature
> Reporter: Christoffer Hammarström
> Assignee: Thomas Dudziak
> Attachments: DDLUTILS-32.patch
>
> In MySQL, a table type or engine can be specified after the "create table" statement, like so:
> CREATE TABLE table
> (
> column INTEGER
> ) ENGINE=InnoDB
> "TYPE" is a synonym for "ENGINE".
> http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
Posted by "Christoffer Hammarström (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=comments#action_12332584 ]
Christoffer Hammarström commented on DDLUTILS-32:
-------------------------------------------------
Any comments on this?
> I want to be able to specify the table type/engine when i create tables in mysql.
> ---------------------------------------------------------------------------------
>
> Key: DDLUTILS-32
> URL: http://issues.apache.org/jira/browse/DDLUTILS-32
> Project: DdlUtils
> Type: New Feature
> Reporter: Christoffer Hammarström
> Assignee: Thomas Dudziak
> Attachments: DDLUTILS-32.patch
>
> In MySQL, a table type or engine can be specified after the "create table" statement, like so:
> CREATE TABLE table
> (
> column INTEGER
> ) ENGINE=InnoDB
> "TYPE" is a synonym for "ENGINE".
> http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
Posted by "Christoffer Hammarström (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=comments#action_12355943 ]
Christoffer Hammarström commented on DDLUTILS-32:
-------------------------------------------------
I don't want to nag, but i'm afraid you might have missed this. :)
Any comments?
> I want to be able to specify the table type/engine when i create tables in mysql.
> ---------------------------------------------------------------------------------
>
> Key: DDLUTILS-32
> URL: http://issues.apache.org/jira/browse/DDLUTILS-32
> Project: DdlUtils
> Type: New Feature
> Reporter: Christoffer Hammarström
> Assignee: Thomas Dudziak
> Attachments: DDLUTILS-32.patch
>
> In MySQL, a table type or engine can be specified after the "create table" statement, like so:
> CREATE TABLE table
> (
> column INTEGER
> ) ENGINE=InnoDB
> "TYPE" is a synonym for "ENGINE".
> http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DDLUTILS-32) I want to be able to specify the
table type/engine when i create tables in mysql.
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=all ]
Thomas Dudziak updated DDLUTILS-32:
-----------------------------------
Component: Core - MySql
> I want to be able to specify the table type/engine when i create tables in mysql.
> ---------------------------------------------------------------------------------
>
> Key: DDLUTILS-32
> URL: http://issues.apache.org/jira/browse/DDLUTILS-32
> Project: DdlUtils
> Type: New Feature
> Components: Core - MySql
> Reporter: Christoffer Hammarström
> Assignee: Thomas Dudziak
> Attachments: DDLUTILS-32.patch
>
> In MySQL, a table type or engine can be specified after the "create table" statement, like so:
> CREATE TABLE table
> (
> column INTEGER
> ) ENGINE=InnoDB
> "TYPE" is a synonym for "ENGINE".
> http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
Posted by "Christoffer Hammarström (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=all ]
Christoffer Hammarström updated DDLUTILS-32:
--------------------------------------------
Attachment: DDLUTILS-32.patch
This patch implements this using the same parameters paradigm as used in DDLUTILS-16
> I want to be able to specify the table type/engine when i create tables in mysql.
> ---------------------------------------------------------------------------------
>
> Key: DDLUTILS-32
> URL: http://issues.apache.org/jira/browse/DDLUTILS-32
> Project: DdlUtils
> Type: New Feature
> Reporter: Christoffer Hammarström
> Assignee: Thomas Dudziak
> Attachments: DDLUTILS-32.patch
>
> In MySQL, a table type or engine can be specified after the "create table" statement, like so:
> CREATE TABLE table
> (
> column INTEGER
> ) ENGINE=InnoDB
> "TYPE" is a synonym for "ENGINE".
> http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira