build CTE round trip tests, add mariadb 10.2

Issue #4230 resolved
Michael Bayer
repo owner created an issue

in https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/4/mariadb-102-includes-cte-with-recursive/diff we can see there aren't actually any round trip tests for CTEs, probably should have some. MariaDB 10.2 now supports them also.

Comments (2)

  1. Michael Bayer reporter

    render WITH clause after INSERT for INSERT..SELECT on Oracle, MySQL

    Fixed INSERT FROM SELECT with CTEs for the Oracle and MySQL dialects, where the CTE was being placed above the entire statement as is typical with other databases, however Oracle and MariaDB 10.2 wants the CTE underneath the "INSERT" segment. Note that the Oracle and MySQL dialects don't yet work when a CTE is applied to a subquery inside of an UPDATE or DELETE statement, as the CTE is still applied to the top rather than inside the subquery.

    Also adds test suite support CTEs against backends.

    Change-Id: I8ac337104d5c546dd4f0cd305632ffb56ac8bf90 Fixes: #4275 Fixes: #4230

    → <<cset 3619edcb8aa3>>

  2. Michael Bayer reporter

    render WITH clause after INSERT for INSERT..SELECT on Oracle, MySQL

    Fixed INSERT FROM SELECT with CTEs for the Oracle and MySQL dialects, where the CTE was being placed above the entire statement as is typical with other databases, however Oracle and MariaDB 10.2 wants the CTE underneath the "INSERT" segment. Note that the Oracle and MySQL dialects don't yet work when a CTE is applied to a subquery inside of an UPDATE or DELETE statement, as the CTE is still applied to the top rather than inside the subquery.

    Also adds test suite support CTEs against backends.

    Change-Id: I8ac337104d5c546dd4f0cd305632ffb56ac8bf90 Fixes: #4275 Fixes: #4230 (cherry picked from commit 3619edcb8aa3ceef2a44925b85315fc0e90c5982)

    → <<cset 6529c474af1a>>

  3. Log in to comment