delta/python-packages/sqlalchemy.git/test/sql/test_compiler.py, branch pr/320 github.com: zzzeek/sqlalchemy.git Propagate execution_options at compile stage 2016-10-05T20:47:31+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-10-05T17:59:58+00:00 71030d67bd7c7948ef4a4d868821703ef5a57476 Compiler can now set up execution options and additionally will propagate autocommit from embedded CTEs. Change-Id: I19db7b8fe4d84549ea95342e8d2040189fed1bbe Fixes: #3805 
Compiler can now set up execution options and additionally
will propagate autocommit from embedded CTEs.

Change-Id: I19db7b8fe4d84549ea95342e8d2040189fed1bbe
Fixes: #3805
Allow stringify compiler to render unnamed column 2016-09-02T15:48:15+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-09-02T15:48:15+00:00 9a6947427af58eeb6ebf09ec6de2a1b7ec12d828 Stringify of expression with unnamed :class:`.Column` objects, as occurs in lots of situations including ORM error reporting, will now render the name in string context as "<name unknown>" rather than raising a compile error. Change-Id: I76f637c5eb4cfdb1b526964cb001565b97e296da Fixes: #3789 
Stringify of expression with unnamed :class:`.Column` objects, as
occurs in lots of situations including ORM error reporting,
will now render the name in string context as "<name unknown>"
rather than raising a compile error.

Change-Id: I76f637c5eb4cfdb1b526964cb001565b97e296da
Fixes: #3789
Spelling fixes 2016-08-08T13:39:15+00:00 Ville Skyttä ville.skytta@iki.fi 2016-08-08T13:39:15+00:00 fd164a6c849289b81f29059dda822c3d5902e40e 






Don't reorder PrimaryKeyConstraint columns if explicit
2016-06-20T16:52:31+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-06-20T15:39:01+00:00

bf03d4332ae35e2087b175f8a2e0291d2f4c9aa0

Dialed back the "order the primary key columns per auto-increment"
described in :ref:`change_mysql_3216` a bit, so that if the
:class:`.PrimaryKeyConstraint` is explicitly defined, the order
of columns is maintained exactly, allowing control of this behavior
when necessary.

Change-Id: I9e7902c57a96c15968a6abf53e319acf15680da0
Fixes: #3726





Dialed back the "order the primary key columns per auto-increment"
described in :ref:`change_mysql_3216` a bit, so that if the
:class:`.PrimaryKeyConstraint` is explicitly defined, the order
of columns is maintained exactly, allowing control of this behavior
when necessary.

Change-Id: I9e7902c57a96c15968a6abf53e319acf15680da0
Fixes: #3726







Add DDLCompiler.create_table_suffix()
2016-06-16T15:43:02+00:00

Mark Sandan
msandan@utexas.edu

2016-05-24T00:08:36+00:00

d7b8b475f8a5c0ddf955157f89db3d44d0dc0d9a

Allows custom dialects to add keywords after the
CREATE TABLE section.

Change-Id: I6fa66dfcf00ef95122f491a9115410df2746cf88





Allows custom dialects to add keywords after the
CREATE TABLE section.

Change-Id: I6fa66dfcf00ef95122f491a9115410df2746cf88







Support range specification in window function
2016-06-07T19:17:22+00:00

Phillip Cloud
cpcloud@gmail.com

2016-05-02T02:26:10+00:00

d34063aa32211c9c2763fbff753601f6c20b8845

Fixes: #3049
Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Change-Id: Ie572095c3e25f70a1e72e1af6858e5edd89fd25e
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/264





Fixes: #3049
Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Change-Id: Ie572095c3e25f70a1e72e1af6858e5edd89fd25e
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/264







- Added support for rendering "FULL OUTER JOIN" to both Core and ORM.
2016-03-28T15:50:09+00:00

Mike Bayer
mike_mp@zzzcomputing.com

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

d61919118072f4c31ba2ee0bd8c4ac22a92e92f4

Pull request courtesy Stefan Urbanek.  fixes #1957





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

Mike Bayer
mike_mp@zzzcomputing.com

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

07a4b6cbcda6e6ee6e67893c5a5d2fd01e5f125f

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





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

Mike Bayer
mike_mp@zzzcomputing.com

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

6b7c207801d826db872aeda02e7c7b531df68034

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





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







- additional adjustment to the fix made in 8ad968f33100baeb3b13c7e0b724b6b79ab4277f
2016-02-22T03:49:29+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-02-22T03:46:31+00:00

eff7b4f29d2a98ef4ccd95b693c7d653eaa543eb

for ref #3657.  The Oracle dialect makes more use of the "select_wraps_for"
feature than SQL server because Oracle doesn't have "TOP" for a limit-only
select, so tests are showing more happening here.  In the case where
the select() has some dupe columns, these are deduped from the .c collection
so a positional match between the wrapper and original can't use .inner_columns,
because these collections wont match.  Using _columns_plus_names
instead which is the deduped collection that determines the SELECT display,
which definitely have to match up.

(cherry picked from commit aa9ce3f521f254da9879ede011e520ec35b8270e)





for ref #3657.  The Oracle dialect makes more use of the "select_wraps_for"
feature than SQL server because Oracle doesn't have "TOP" for a limit-only
select, so tests are showing more happening here.  In the case where
the select() has some dupe columns, these are deduped from the .c collection
so a positional match between the wrapper and original can't use .inner_columns,
because these collections wont match.  Using _columns_plus_names
instead which is the deduped collection that determines the SELECT display,
which definitely have to match up.

(cherry picked from commit aa9ce3f521f254da9879ede011e520ec35b8270e)