github sqlalchemy/sqlalchemy rel_1_1_11


Released: Monday, June 19, 2017


  • [orm] [bug] Fixed issue with subquery eagerloading which continues on from
    the series of issues fixed in #2699, #3106,
    #3893 involving that the "subquery" contains the correct
    FROM clause when beginning from a joined inheritance subclass
    and then subquery eager loading onto a relationship from
    the base class, while the query also includes criteria against
    the subclass. The fix in the previous tickets did not accommodate
    for additional subqueryload operations loading more deeply from
    the first level, so the fix has been further generalized.

    References: #4011


  • [sql] [bug] Fixed AttributeError which would occur in WithinGroup
    construct during an iteration of the structure.

    References: #4012


  • [postgresql] [bug] Continuing with the fix that correctly handles PostgreSQL
    version string "10devel" released in 1.1.8, an additional regexp
    bump to handle version strings of the form "10beta1". While
    PostgreSQL now offers better ways to get this information, we
    are sticking w/ the regexp at least through 1.1.x for the least
    amount of risk to compatibility w/ older or alternate PostgreSQL

    References: #4005

  • [postgresql] [bug] Fixed bug where using ARRAY with a string type that
    features a collation would fail to produce the correct syntax
    within CREATE TABLE.

    References: #4006


  • [mysql] [bug] MySQL 5.7 has introduced permission limiting for the "SHOW VARIABLES"
    command; the MySQL dialect will now handle when SHOW returns no
    row, in particular for the initial fetch of SQL_MODE, and will
    emit a warning that user permissions should be modified to allow the
    row to be present.

    References: #4007


  • [mssql] [bug] Fixed bug where SQL Server transaction isolation must be fetched
    from a different view when using Azure data warehouse, the query
    is now attempted against both views and then a NotImplemented
    is raised unconditionally if failure continues to provide the
    best resiliency against future arbitrary API changes in new
    SQL Server versions.

    References: #3994

  • [mssql] [bug] Added a placeholder type mssql.XML to the SQL Server
    dialect, so that a reflected table which includes this type can
    be re-rendered as a CREATE TABLE. The type has no special round-trip
    behavior nor does it currently support additional qualifying

    References: #3973


  • [oracle] [bug] Support for two-phase transactions has been removed entirely for
    cx_Oracle when version 6.0b1 or later of the DBAPI is in use. The two-
    phase feature historically has never been usable under cx_Oracle 5.x in
    any case, and cx_Oracle 6.x has removed the connection-level "twophase"
    flag upon which this feature relied.

    References: #3997

latest releases: rel_1_3_20, rel_1_3_19, rel_1_3_18...
14 months ago