summaryrefslogtreecommitdiff
path: root/test/sql/test_join_rewriting.py
Commit message (Collapse)AuthorAgeFilesLines
* - Fixed bug in SQLite join rewriting where anonymized column namesMike Bayer2014-05-251-1/+44
| | | | | | due to repeats would not correctly be rewritten in subqueries. This would affect SELECT queries with any kind of subquery + join. fixes #3057
* - rename __multiple__ to __backend__, and apply __backend__ to a large ↵Mike Bayer2014-03-241-0/+2
| | | | | | number of tests. - move out logging tests from test_execute to test_logging
* - we're testing a query here with non-standard aliasing which fails on PG ↵Mike Bayer2014-02-241-0/+6
| | | | | | | and MySQL. Leave this test in place as its ultimately a SQLite use case, but only test on SQLite. We perhaps should add another test case that works on all platforms.
* - More fixes to SQLite "join rewriting"; the fix from :ticket:`2967`Mike Bayer2014-02-201-2/+66
| | | | | | | | | | | | | | implemented right before the release of 0.9.3 affected the case where a UNION contained nested joins in it. "Join rewriting" is a feature with a wide range of possibilities and is the first intricate "SQL rewriting" feature we've introduced in years, so we're sort of going through a lot of iterations with it (not unlike eager loading back in the 0.2/0.3 series, polymorphic loading in 0.4/0.5). We should be there soon so thanks for bearing with us :). fixes #2969 re: #2967 - solve the issue of join rewriting inspecting various types of from objects without using isinstance(), by adding some new underscored inspection flags to the FromClause hierarchy.
* skip this on oracleMike Bayer2014-02-191-0/+3
|
* - re: #2967, also fixed a somewhat related issue where join rewriting would failMike Bayer2014-02-191-1/+38
| | | | | on the columns clause of the SELECT statement if the targets were aliased tables, as opposed to individual aliased columns.
* - Fixed bug in SQLite "join rewriting" where usage of an exists() constructMike Bayer2014-02-191-4/+56
| | | | | would fail to be rewritten properly, such as when the exists is mapped to a column_property in an intricate nested-join scenario. #2967
* - Fixed a regression introduced by the join rewriting feature ofMike Bayer2013-11-011-0/+33
| | | | | | | :ticket:`2369` and :ticket:`2587` where a nested join with one side already an aliased select would fail to translate the ON clause on the outside correctly; in the ORM this could be seen when using a SELECT statement as a "secondary" table. [ticket:2858]
* - fix issue in join rewriting whereby we need to ensure the .key and .nameMike Bayer2013-07-271-4/+83
| | | | | | are transferred correctly for when .key is present; tests have been enhanced to test this condition for render, result map construction, statement execution. [ticket:2790]
* - add coverage for result map rewritingMike Bayer2013-06-041-0/+6
| | | | | - fix the result map rewriter for col mismatches, since the rewritten select at the moment typically has more columns than the original
* - if the select() does not have use_labels on, then we just renderMike Bayer2013-06-041-0/+51
| | | | | | the joins as is, regardless of the dialect not supporting it. use_labels=True indicates a higher level of automation and also can maintain the labels between rewritten and not. use_labels=False indicates a manual use case.
* - support for a__b_dc, i.e. two levels of nestingMike Bayer2013-06-041-35/+131
|
* - add a flag to DefaultDialect for this so that people will have someMike Bayer2013-06-041-1/+28
| | | | workaround
* rewriting scheme now works.Mike Bayer2013-06-041-28/+21
|
* capture the really hard one in a test (hooray)Mike Bayer2013-06-041-0/+119