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

Spelling fixes

2016-08-08T13:39:15+00:00

Build string/int processors for JSONIndexType, JSONPathType

2016-08-04T16:38:58+00:00

Fixed regression in JSON datatypes where the "literal processor" for
a JSON index value, that needs to take effect for example within DDL,
would not be invoked for the value.  The native String and Integer
datatypes are now called upon from within the JSONIndexType
and JSONPathType.  This is applied to the generic, Postgresql, and
MySQL JSON types.

Change-Id: Ifa5f2acfeee57a79d01d7fc85d265a37bd27c716
Fixes: #3765

Propagate kwargs to all MySQL CAST paths

2016-08-04T16:34:55+00:00

Change-Id: I23a6abb26bbbe3d118887d043ce761fc4572d8d2
Fixes: #3766

- Document how SQL Server does MAX with VARCHAR, NVARCHAR

2016-07-27T14:04:52+00:00

Fixes #3760

Change-Id: I0613eb66bfdc9d7118688c74e29c8da322c3b4db

- MySQL's JSON shared implementation completely w/ sqltypes.JSON;

2016-07-25T03:14:47+00:00

this must have been an oversight.   Leave mysql.JSON in place still
as we might need to add things to it.
- CAST(json, String) still confusing MySQL drivers even mysqlclient.
Since here we're checking for the raw form of the JSON and not a typical
round trip, add a force for unicode

Change-Id: I727f4526a01a0875037cf0dede45cd074da5205a

Adapt "FOR UPDATE OF" with Oracle limit/offset

2016-07-05T22:30:25+00:00

This modifies the Oracle ROWNUM limit/offset approach
to accommodate for the "OF" clause in a "FOR UPDATE"
phrase.  The column expressions must be added to the selected
subquery if necessary and adapted on the outside.

Change-Id: Ia71b5fc4df6d326e73863f8ae9f96e8f1a5acfc1
Fixes: #3741

Repair PG BIGSERIAL w/ TypeDecorator, Variant

2016-07-04T20:54:01+00:00

Some of the dialect impl memoization for TypeDecorator
necessarily keeps the top-level TypeDecorator type
around, since a user-defined type will have bind and result
set processing behavior.  For both TypeDecorator and Variant,
PG dialect needs to ensure it's looking at the SQLAlchemy
type to check for SmallInteger / BigInteger.

Fixes: 3739
Change-Id: I2d45fb997f17c6272d6bb826a77d2dba665adae7
(cherry picked from commit 421fa6b8bf9f0c3c5041579c89ec405ce0f5e0b0)

Disable Enum string validation by default

2016-06-20T15:45:24+00:00

Rolled back the validation rules a bit in :class:`.Enum` to allow
unknown string values to pass through, unless the flag
``validate_string=True`` is passed to the Enum; any other kind of object is
still of course rejected.  While the immediate use
is to allow comparisons to enums with LIKE, the fact that this
use exists indicates there may be more unknown-string-comparsion use
cases than we expected, which hints that perhaps there are some
unknown string-INSERT cases too.

Change-Id: I7d1d79b374a7d47966d410998f77cd19294ab7b0
Fixes: #3725

Add ON CONFLICT support for Postgresql

2016-06-14T19:03:14+00:00

Fixes: #3529
Co-authored-by: Mike Bayer 
Change-Id: Ie3bf6ad70d9be9f0e44938830e922db03573991a
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/258

Support `postgresql_concurrently` on index dropping.

2016-06-08T18:41:05+00:00

Also adds version detection so that DROP INDEX CONCURRENTLY
only renders if the Postgresql version is 9.2 or higher;
for CREATE INDEX CONCURRENTLY, version detection is added
to allow the phrase to omit if the Postgresql version is
less than 8.2.

Co-authored-by: Mike Bayer 
Change-Id: I597287e0ebbbe256c957a3579b58ace6848ab4f4
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/84