delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects, branch pr/318

Add check for blank string coming from MySQL's enum

2016-10-28T18:17:40+00:00

MySQL's native ENUM type supports any non-valid value being sent, and
in response will return a blank string.  A hardcoded rule to check for
"is returning the blank string" has been added to the  MySQL
implementation for ENUM so that this blank string is returned to the
application rather than being rejected as a non-valid value.  Note that
if your MySQL enum is linking values to objects, you still get the
blank string back.

Change-Id: I61f85c20293a48b0c11a31f2a19f6756c206bd20
Fixes: #3841

Don't set pg autoincrement if type affinity is not Integer

2016-10-20T21:38:22+00:00

Postgresql table reflection will ensure that the
:paramref:`.Column.autoincrement` flag is set to False when reflecting
a primary key column that is not of an :class:`.Integer` datatype,
even if the default is related to an integer-generating sequence.
This can happen if a column is created as SERIAL and the datatype
is changed.  The autoincrement flag can only be True if the datatype
is of integer affinity in the 1.1 series.

This bug is related to a test failure in downstream sqlalchemy_migrate.

Change-Id: I40260e47e1927a1ac940538408983c943bbdba28
Fixes: #3835

spelling: Postgresql -> PostgreSQL

2016-10-08T17:42:50+00:00

Catch DBAPIError instead of ProgrammingError for pyodbc fail

2016-10-07T13:17:46+00:00

Change-Id: Ide9e916d02fbbef549aa2838d1402c2b091e701d
Fixes: #3820

Use schema_name() for SQL Server default schema

2016-10-04T15:32:20+00:00

Changed the query used to get "default schema name", from one that
queries the database principals table to using the
"schema_name()" function, as issues have been reported that the
former system was unavailable on the Azure Data Warehouse edition.
It is hoped that this will finally work across all SQL Server
versions and authentication styles.

Change-Id: Ic11bd4162c0d6a60432ae44876e86512703c1f81
Fixes: #3810

Use SQL Server SERVERPROPERTY for version info w/ pyodbc

2016-10-04T15:17:26+00:00

Updated the server version info scheme for pyodbc to use SQL Server
SERVERPROPERTY(), rather than relying upon pyodbc.SQL_DBMS_VER, which
continues to be unreliable particularly with FreeTDS.

Change-Id: I4ff49ae13c8ff51bd764980131d41c18d73d87ce
Fixes: #3814

Add "eager_parenthesis" late-compilation rule, use w/ PG JSON/HSTORE

2016-10-01T13:46:11+00:00

Added compiler-level flags used by Postgresql to place additional
parenthesis than would normally be generated by precedence rules
around operations involving JSON, HSTORE indexing operators as well as
within their operands since it has been observed that Postgresql's
precedence rules for at least the HSTORE indexing operator is not
consistent between 9.4 and 9.5.

Fixes: #3806
Change-Id: I5899677b330595264543b055abd54f3c76bfabf2

Enable include_table for ON CONFLICT whereclauses

2016-09-28T22:08:30+00:00

Fixed issue in new PG "on conflict" construct where columns including
those of the "excluded" namespace would not be table-qualified
in the WHERE clauses in the statement.

Change-Id: Idfefc93e7e7b0d84805e23d5436d822d606f6a0a
Fixes: #3807

Add exclude_tablespaces argument to Oracle

2016-09-20T17:57:40+00:00

Allows the SYSTEM and SYSAUX tablespaces to be only
conditionally omitted when doing get_table_names()
and get_temp_table_names().

Change-Id: Ie6995873f05163f2ce473a6a9c2d958a30681b44
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/292

Add "message 20017" (unexpected EOF from the server) to mssql.

2016-09-19T16:31:57+00:00

Fixes: #3791
Change-Id: I0dade4fe0ecbb53b4a66881594f362986ba73ae8
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/89