delta/python-packages/sqlalchemy.git/lib/sqlalchemy/sql, branch pr/283

Raise error on empty in_

2016-06-05T09:56:25+00:00



I think it would be good idea to add error on empy in_ usage in version 1.1.*
Because current implementation is not fully correct:
Firstly, it's not optimised, because of sequential scan
Secondly, in current implementation null in () will return null, when in sql it should return False, try this:
select null in (select 1 from some_table where false); -> false but not null

I understant that this can break some legacy code, but current implementation is obscure and quite expensive

Add SKIP LOCKED support for Postgresql, Oracle

2016-06-02T21:46:16+00:00

This adds `SELECT ... FOR UPDATE SKIP LOCKED`/
`SELECT ... FOR SHARE SKIP LOCKED` rendering.

Change-Id: Id1dc4f1cafc1de23f397a6f73d54ab2c58d5910d
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/86

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

Merge remote-tracking branch 'origin/pr/270'

2016-05-24T20:29:49+00:00

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

Fix label referencing in SQL Server OFFSET logic

2016-05-10T16:55:23+00:00

Fixed bug where by ROW_NUMBER OVER clause applied for OFFSET
selects in SQL Server would inappropriately substitute a plain column
from the local statement that overlaps with a label name used by
the ORDER BY criteria of the statement.

Change-Id: Ic2500c886cbfc83a1ad5a2681783f008b9f23838
Fixes: #3711

Repair _orm_columns() to accommodate text()

2016-05-05T21:07:40+00:00

Fixed bug whereby passing a :func:`.text` construct to the
:meth:`.Query.group_by` method would raise an error, instead
of intepreting the object as a SQL fragment.

Change-Id: I5fc2f590b76508d52e23b5fa9cf037ddea8080c3
fixes: #3706

Spelling fixes: "an SQL" -> "a SQL", see #266

2016-05-05T06:02:38+00:00

Adds parentheses around prints in documentation

2016-04-27T06:35:55+00:00

This makes the docstring example code compatible with both Python 2 and Python 3.

- 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