delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects/mssql, branch pr/320 github.com: zzzeek/sqlalchemy.git Catch DBAPIError instead of ProgrammingError for pyodbc fail 2016-10-07T13:17:46+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-10-07T13:16:22+00:00 ae9300cac0ec398f92d9e523273403126a709134 Change-Id: Ide9e916d02fbbef549aa2838d1402c2b091e701d Fixes: #3820 
Change-Id: Ide9e916d02fbbef549aa2838d1402c2b091e701d
Fixes: #3820
Use schema_name() for SQL Server default schema 2016-10-04T15:32:20+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-10-04T15:32:20+00:00 562e37ee7eaab8b19a9f081d4b170b95fce4f619 Changed the query used to get "default schema name", from one that queries the database principals table to using the "schema_name()" function, as issues have been reported that the former system was unavailable on the Azure Data Warehouse edition. It is hoped that this will finally work across all SQL Server versions and authentication styles. Change-Id: Ic11bd4162c0d6a60432ae44876e86512703c1f81 Fixes: #3810 
Changed the query used to get "default schema name", from one that
queries the database principals table to using the
"schema_name()" function, as issues have been reported that the
former system was unavailable on the Azure Data Warehouse edition.
It is hoped that this will finally work across all SQL Server
versions and authentication styles.

Change-Id: Ic11bd4162c0d6a60432ae44876e86512703c1f81
Fixes: #3810
Use SQL Server SERVERPROPERTY for version info w/ pyodbc 2016-10-04T15:17:26+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-10-04T15:17:26+00:00 f0ea9e37f94bd39fa4f0785dbdcd0ee1759c4a11 Updated the server version info scheme for pyodbc to use SQL Server SERVERPROPERTY(), rather than relying upon pyodbc.SQL_DBMS_VER, which continues to be unreliable particularly with FreeTDS. Change-Id: I4ff49ae13c8ff51bd764980131d41c18d73d87ce Fixes: #3814 
Updated the server version info scheme for pyodbc to use SQL Server
SERVERPROPERTY(), rather than relying upon pyodbc.SQL_DBMS_VER, which
continues to be unreliable particularly with FreeTDS.

Change-Id: I4ff49ae13c8ff51bd764980131d41c18d73d87ce
Fixes: #3814
Add "message 20017" (unexpected EOF from the server) to mssql. 2016-09-19T16:31:57+00:00 Ken Robbins ken@surveymonkey.com 2016-09-14T19:13:30+00:00 881369b949cff44e0017fdc28d9722ef3c26171a Fixes: #3791 Change-Id: I0dade4fe0ecbb53b4a66881594f362986ba73ae8 Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/89 
Fixes: #3791
Change-Id: I0dade4fe0ecbb53b4a66881594f362986ba73ae8
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/89
Spelling fixes 2016-08-08T13:39:15+00:00 Ville Skyttä ville.skytta@iki.fi 2016-08-08T13:39:15+00:00 fd164a6c849289b81f29059dda822c3d5902e40e 






- Document how SQL Server does MAX with VARCHAR, NVARCHAR
2016-07-27T14:04:52+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-07-27T14:04:52+00:00

0d92f79fd86073203a2a956460140c311c85a396

Fixes #3760

Change-Id: I0613eb66bfdc9d7118688c74e29c8da322c3b4db





Fixes #3760

Change-Id: I0613eb66bfdc9d7118688c74e29c8da322c3b4db







Allow creating explicit non-clustered keys and indexes MS SQL.
2016-06-06T18:27:31+00:00

Saulius Žemaitaitis
saulius@zemaitaitis.lt

2016-04-12T03:16:45+00:00

a5f92314edd45a2e411b0f5b3c4d4bec0c7d92f8

mssql_clustered=False on Index, UniqueConstraint,
PrimaryKeyConstraint now renders NONCLUSTERED.
The default of mssql_clustered is now None.

Co-Authored-By: mike bayer <mike_mp@zzzcomputing.com>
Change-Id: Id6b8d840e355be8f8fa72360cb4b6d2617ba72cf
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/252





mssql_clustered=False on Index, UniqueConstraint,
PrimaryKeyConstraint now renders NONCLUSTERED.
The default of mssql_clustered is now None.

Co-Authored-By: mike bayer <mike_mp@zzzcomputing.com>
Change-Id: Id6b8d840e355be8f8fa72360cb4b6d2617ba72cf
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/252







Use new mxODBC 3.3.4 varbinary null symbol
2016-05-31T15:03:34+00:00

Sheila Allen
sallen@zeomega.com

2016-04-11T19:29:03+00:00

3f55039e7f15efafacc3e8e0fbf0ba38fa612b09

Use new mxODBC 3.3.4 varbinary null symbol with VARBINARY
data types when value is None(based on similar change to pyodbc).
Fix a test to pass on mxODBC starting w 3.3.3 version

Change-Id: Id703ecb51ebc5db149c81fef124f673433606c7f
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/58





Use new mxODBC 3.3.4 varbinary null symbol with VARBINARY
data types when value is None(based on similar change to pyodbc).
Fix a test to pass on mxODBC starting w 3.3.3 version

Change-Id: Id703ecb51ebc5db149c81fef124f673433606c7f
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/58







Fix label referencing in SQL Server OFFSET logic
2016-05-10T16:55:23+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-05-10T16:49:56+00:00

0604116814a862d4d9dbc1a8866a2a3b0126caf1

Fixed bug where by ROW_NUMBER OVER clause applied for OFFSET
selects in SQL Server would inappropriately substitute a plain column
from the local statement that overlaps with a label name used by
the ORDER BY criteria of the statement.

Change-Id: Ic2500c886cbfc83a1ad5a2681783f008b9f23838
Fixes: #3711





Fixed bug where by ROW_NUMBER OVER clause applied for OFFSET
selects in SQL Server would inappropriately substitute a plain column
from the local statement that overlaps with a label name used by
the ORDER BY criteria of the statement.

Change-Id: Ic2500c886cbfc83a1ad5a2681783f008b9f23838
Fixes: #3711







Fix pymssql sample URL
2016-04-27T20:09:39+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-04-27T20:08:31+00:00

9a3c9ba7beb18dfd6232deb895528ea8593a12b0

A slash is required before building out the query string portion.

Change-Id: Ie97fd3d07047d78e17cbaffed4ff54960a2b956e
Fixes: #3696
(cherry picked from commit 83a9e6e1fac276090e60136aa4e9234ae23bc25a)





A slash is required before building out the query string portion.

Change-Id: Ie97fd3d07047d78e17cbaffed4ff54960a2b956e
Fixes: #3696
(cherry picked from commit 83a9e6e1fac276090e60136aa4e9234ae23bc25a)