pymssql v2.1.2 Release Notes

Release Date: 2016-02-10 // about 8 years ago
  • ๐Ÿ .. attention:: Windows users: You need to download and install additional DLLs

    pymssql version 2.1.2 includes a change in the official Windows binaries:
    FreeTDS isn't statically linked as it happened up to release 2.1.1, as that
    FreeTDS copy lacked SSL support.
    
    Please see http://pymssql.org/en/latest/freetds.html#windows for futher
    details.
    
    We are trying to find a balance between security and convenience and will
    be evaluating the situation for future releases. Your feedback is greatly
    welcome.
    

    General

    • โฌ‡๏ธ Drop support for Python 2.6.

    • โž• Add support for Python 3.5.

    • โšก๏ธ Update shipped Linux FreeTDS static libs to 0.95

    ๐Ÿ”‹ Features

    • โž• Add ability to set TDS protocol version from pymssql when connecting to SQL Server. For the remaining pymssql 2.1.x releases its default value will be 7.1 (GH-323)

    • โž• Add Dockerfile and a Docker image and instructions on how to use it (GH-258). This could be a convenient way to use pymssql without having to build stuff. See http://pymssql.readthedocs.org/en/latest/intro.html#docker Thanks Marc Abramowitz.

    • Floating point values are now accepted as Stored Procedure arguments (GH-287). Thanks Runzhou Li (Leo) for the report and Bill Adams for the implementation.

    • Send pymssql version in the appname TDS protocol login record field when the application doesn't provide one (GH-354)

    ๐Ÿ› Bug fixes

    • ๐Ÿ›  Fix a couple of very common causes of segmentation faults in presence of network a partition between a pymssql-based app and SQL Server (GH-147, GH-271) Thanks Marc Abramowitz. See also GH-373.

    • ๐Ÿ›  Fix failures and inconsistencies in query parameter interpolation when UTF-8-encoded literals are present (GH-185). Thanks Bill Adams. Also, GH-291.

    • ๐Ÿ›  Fix login_timeout parameter of pymssql.connect() (GH-318)

    • ๐Ÿ›  Fixed some cases of cursor.rowcont having a -1 value after iterating over the value returned by pymssql cursor fetchmany() and fetchone() methods (GH-141)

    • โœ‚ Remove automatic treatment of string literals passed in queries that start with '0x' as hexadecimal values (GH-286)

    • ๐Ÿ›  Fix build fatal error when using Cython >= 0.22 (GH-311)

    ๐Ÿ“š Documentation

    • โž• Add installation instructions. Thanks Marc Abramowitz.

    • Document DB-API-mandated exceptions.

    • โœจ Enhance _mssql.MSSQLStoredProcedure.bind() docs.

    • โœจ Enhance description of Azure connections requirements.

    Internals

    • โž• Add Appveyor hosted CI setup for running tests on Windows (GH-347)

    • โœ… Travis CI: Use newer, faster, container-based infrastructure. Also, test against more than one FreeTDS version.

    • ๐Ÿš€ Make it possible to build official release files (sdist, wheels) on Travis & AppVeyor.