delta/python-packages/sqlalchemy.git/test/dialect/mysql, branch pr_github_383

Rename MySQL dml.insert().values to .inserted

2017-09-09T01:41:13+00:00

Changed the name of the ``.values`` attribute of the new MySQL
INSERT..ON DUPLICATE KEY UPDATE construct to ``.inserted``, as
:class:`.Insert` already has a method called :meth:`.Insert.values`.
The ``.inserted`` attribute ultimately renders the MySQL ``VALUES()``
function.

Change-Id: I8da8e30a3077698385a4b77e2c2032e2d1ff10b2
Fixes: #4072

Apply percent sign escaping to literal binds, comments

2017-08-25T20:53:49+00:00

Fixed bug in new percent-sign support (e.g. :ticket:`3740`) where a bound
parameter rendered with literal_binds would fail to escape percent-signs
for relevant dialects.  In addition, ensured new table / column comment
support feature also fully makes use of literal-rendered parameters so that
this percent sign support takes place with table / column comment DDL as
well, allowing percent sign support for the mysql / psycopg2 backends that
require escaping of percent signs.

Change-Id: Ia4136a300933e9bc6a01a7b9afd5c7b9a3fee4e3
Fixes: #4054
Fixes: #4052

- this test doesn't work in strict mode, not that important

2017-08-21T03:11:57+00:00

Change-Id: I3ed361af5c9f0c7acbeb8b534966828949f4958b

Implement MySQL's ON DUPLICATE KEY UPDATE

2017-07-03T18:38:09+00:00

Added support for MySQL's ON DUPLICATE KEY UPDATE
MySQL-specific :class:`.mysql.dml.Insert` object.
Pull request courtesy Michael Doronin.

Co-authored-by: Mike Bayer 
Resolves: #4009
Change-Id: Ic71424f3c88af6082b48a910a2efb7fbfc0a7eb4
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/365

Handle SHOW VARIABLES returning no row

2017-06-16T19:52:46+00:00

MySQL 5.7 has introduced permission limiting for the "SHOW VARIABLES"
command; the MySQL dialect will now handle when SHOW returns no
row, in particular for the initial fetch of SQL_MODE, and will
emit a warning that user permissions should be modified to allow the
row to be present.

Change-Id: I98e7a69230da397b17eae07b7e9d024fa7aeeb26
Fixes: #4007

Allow metadata.reflect() to recover from unreflectable tables

2017-05-22T19:51:07+00:00

Added support for views that are unreflectable due to stale
table definitions, when calling :meth:`.MetaData.reflect`; a warning
is emitted for the table that cannot respond to ``DESCRIBE``
but the operation succeeds.  The MySQL dialect now
raises UnreflectableTableError which is in turn caught by
MetaData.reflect().  Reflecting the view standalone raises
this error directly.

Change-Id: Id8005219d8e073c154cc84a873df911b4a6cf4d6
Fixes: #3871

Remove MySQL UTC_TIMESTAMP rule

2017-04-13T14:11:41+00:00

Removed an ancient and unnecessary intercept of the UTC_TIMESTAMP
MySQL function, which was getting in the way of using it with a
parameter.

Change-Id: I6e6b52c051418bcb9d31987e78299310810cb78d
Fixes: #3966

Consider mysql partition options separately from other table options

2017-04-06T16:12:26+00:00

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

- limit to MySQL dialect

2017-02-13T19:40:55+00:00

Change-Id: I2781e1e2221d89c75dd65ff49490d9c409967930

- pull autocommit suite into the mysql suite as well

2017-02-13T19:33:21+00:00

Change-Id: If1106f7f125739e69ad2482f65b8f37672a76c9e