mysql partition options need to be after all the table options

[sqlalchemy-bot]

Migrated issue, originally created by Michael Bayer (@zzzeek)

e.g. https://dev.mysql.com/doc/refman/5.7/en/create-table.html

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

https://gerrit.sqlalchemy.org/376

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

the initial gerrit also adds a space between the table parenthesis and the options, which for some reason was never there, but that's the only thing that makes me nervous about putting this in 1.1.10 in case someone has some regexp rules that would break, but this space fixing should just go somewhere else for now.

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• changed milestone from "1.2" to "1.1"

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

Consider mysql partition options separately from other table options

Move down all the PARTITION, SUBPARTITION options
into a separate segment so that they come out at the
end of CREATE TABLE after the table options.

Change-Id: Iaa1c823848c93680ca22d72bda1b7c49742b9060
Fixes: #3961

→ 93b1190

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• changed status to closed

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

Consider mysql partition options separately from other table options

Move down all the PARTITION, SUBPARTITION options
into a separate segment so that they come out at the
end of CREATE TABLE after the table options.

Change-Id: Iaa1c823848c93680ca22d72bda1b7c49742b9060
Fixes: #3961
(cherry picked from commit 93b1190)

→ f1ffcc7