delta/python-packages/sqlalchemy.git/test/sql, branch pr/280

Skip UniqueConstraint marked by unique=True in tometadata

2016-06-02T17:54:07+00:00

Fixes an issue where a Column would be copied with unique=True
and at the same time the UniqueConstraint would also be copied,
leading to duplicate UniqueConstraints in the target table,
when tometadata() is used.   Imitates the same logic used
by index=True/Index to avoid duplicates.  For some reason
a fix was implemented for Index long ago but never for
UniqueConstraint.

Change-Id: Ie622ee912a6fb8bf0ea900a8b09d78c7ebc79fc0
Fixes: #3721

Support "blank" schema when MetaData.schema is set

2016-05-18T15:43:38+00:00

Previously, it was impossible to have a Table that has
None for a schema name when the "schema" parameter on
MetaData was set.  A new symbol sqlalchemy.schema.BLANK_SCHEMA
is added which indicates that the schema name should unconditionally
be set to None.  In particular, this value must be passed within
cross-schema foreign key reflection, so that a Table which
is in the "default" schema can be represented properly.

Fixes: #3716
Change-Id: I3d24f99c22cded206c5379fd32a225e74edb7a8e

Don't double-process ResultMetaData for BufferedColumnResultProxy

2016-04-27T16:37:58+00:00

Fixed a bug in the result proxy used mainly by Oracle when binary and
other LOB types are in play, such that when query / statement caching
were used, the type-level result processors, notably that required by
the binary type itself but also any other processor, would become lost
after the first run of the statement due to it being removed from the
cached result metadata.

Change-Id: I751940866cffb4f48de46edc8137482eab59790c
Fixes: #3699

Fix result set handling for case insensitive dupe cols

2016-04-21T14:36:19+00:00

Fixed bug where when using ``case_sensitive=False`` with an
:class:`.Engine`, the result set would fail to correctly accomodate
for duplicate column names in the result set, causing an error
when the statement is executed in 1.0, and preventing the
"ambiguous column" exception from functioning in 1.1.

Change-Id: If582bb9fdd057e4da3ae42f7180b17d1a1a2d98e
Fixes: #3690

- limit this to sqlite for now

2016-03-30T22:59:01+00:00

- move all resultproxy tests intio test_resultset

2016-03-30T21:36:03+00:00

- Added :meth:`.Select.lateral` and related constructs to allow

2016-03-29T21:56:02+00:00

for the SQL standard LATERAL keyword, currently only supported
by Postgresql.  fixes #2857

- Added support for rendering "FULL OUTER JOIN" to both Core and ORM.

2016-03-28T15:50:09+00:00

Pull request courtesy Stefan Urbanek.  fixes #1957

- Fixed bug where the negation of an EXISTS expression would not

2016-03-21T14:57:40+00:00

be properly typed as boolean in the result, and also would fail to be
anonymously aliased in a SELECT list as is the case with a
non-negated EXISTS construct.
fixes #3682

- move out unconsumed names tests from test_compiler out to test_insert, test_update

2016-03-03T01:24:49+00:00

- establish consistent names between existing unconsumed names tests and new ones
added per ref #3666