support MSSQL 2000 again, optimization for MSSQL
authorSineSwiper <BBYRD@CPAN.org>
Tue, 5 Jun 2012 01:27:13 +0000 (21:27 -0400)
committerRafael Kitover <rkitover@cpan.org>
Fri, 8 Jun 2012 22:44:16 +0000 (18:44 -0400)
commitb8aba8da5dc212c2d0482a004e198b4a345e246f
tree58d657987c951a3e345dddd0c0917f9c808cefff
parentc819561ab07117cbe62d10cd64988ca811ad9149
support MSSQL 2000 again, optimization for MSSQL

multischema support broke compatibility with SQL Server 2000 in 0.07011,
because system tables were used to find identity columns, and system
tables changed between 2000 and 2005.

We now check the SQL Server version and use a different query for 2000
and later versions.

Also optimize columns_info_for to use one query for the whole table,
instead of doing two separate queries for each column.
Changes
lib/DBIx/Class/Schema/Loader/DBI/MSSQL.pm