delta/python-packages/sqlalchemy.git/test/sql/test_cte.py, branch pr/139

- Fixed bug in CTE where ``literal_binds`` compiler argument would not

2014-08-02T18:42:57+00:00

be always be correctly propagated when one CTE referred to another
aliased CTE in a statement.
Fixes #3154

- update the flake8 rules again

2014-07-18T21:40:58+00:00

- apply autopep8 + manual fixes to most of test/sql/

-Fixed bug in common table expressions whereby positional bound

2014-07-14T22:34:32+00:00

parameters could be expressed in the wrong final order
when CTEs were nested in certain ways.
fixes #3090

- reverse order of columns in sample CTEs as this is a UNION and the cols need to line up

2014-04-02T22:11:11+00:00

- alter this in the unit tests as well as these queries were just copied from the tests
- remove the included_parts.join(parts) from the core CTE doc (also just copied from the
test, where we want to make sure joins don't get screwed up with the CTE) as it doesn't
contribute to the query itself
fixes #3014

Fixed regression dating back to 0.7.9 whereby the name of a CTE might

2013-08-18T18:46:04+00:00

not be properly quoted if it was referred to in multiple FROM clauses.
Also in 0.8.3, 0.7.11. [ticket:2801]

- Fixed bug in common table expression system where if the CTE were

2013-07-31T22:42:58+00:00

used only as an ``alias()`` construct, it would not render using the
WITH keyword.  Also in 0.8.3, 0.7.11.
[ticket:2783]

trying different approaches to test layout. in this one, the testing modules

2012-09-27T06:37:33+00:00

become an externally usable package but still remains within the main sqlalchemy parent package.
in this system, we use kind of an ugly hack to get the noseplugin imported outside of the
"sqlalchemy" package, while still making it available within sqlalchemy for usage by
third party libraries.

- [feature] The before_cursor_execute event

2012-08-23T19:40:09+00:00

    fires off for so-called "_cursor_execute"
    events, which are usually special-case
   executions of primary-key bound sequences
    and default-generation SQL
    phrases that invoke separately when RETURNING
    is not used with INSERT.  [ticket:2459]

- [bug] Fixed more un-intuitivenesses in CTEs

2012-07-10T15:00:49+00:00

    which prevented referring to a CTE in a union
    of itself without it being aliased.
    CTEs now render uniquely
    on name, rendering the outermost CTE of a given
    name only - all other references are rendered
    just as the name.   This even includes other
    CTE/SELECTs that refer to different versions
    of the same CTE object, such as a SELECT
    or a UNION ALL of that SELECT. We are
    somewhat loosening the usual link between object
    identity and lexical identity in this case.
    A true name conflict between two unrelated
    CTEs now raises an error.

- move cte tests into their own test/sql/test_cte.py

2012-06-25T16:42:47+00:00

- rework bindtemplate system of "numbered" params by applying
the numbers last, as we now need to generate these out of order
in some cases
- add positional assertion to assert_compile
- add new cte_positional collection to track bindparams generated
within cte visits; splice this onto the beginning of self.positiontup
at cte render time, [ticket:2521]