SCM

File Release Notes and Changelog

Release Name: Npgsql2.0.8

Release Notes

2009-12-28

    Npgsql 2.0.8
    
    This is a bug fix release.
    
    
    
    Highlights for this release:
        
        Work in progress for the bug reported in message 1005698. Josh is working to provide a much more solid fix for this.
        Josh started to add support for better type handling of Npgsql types and CLR types. This way, Npgsql users will be able to get values in either Npgsql specific types, like NpgsqlTimeTZ, or CLR type, like DateTime.
         
        
        
    
    New Features:
    
        Added support for Snapshot Isolation Level.
        
        Npgsql/NpgsqlDataReader.cs: Support for provider specific types (with compatibility flag on change to NpgsqlInterval). This adds initial support for better datatype handling for Npgsql specific types and CLR types.
        

    Bugs fixed:
    
        Initial support for bug fix reported in message 1005698.  The fix changes valid sql that produced	  incorrect results to sometimes valid sql that produced correct results when valid.	Also contains work in progress to resolve the invalid sql. (Josh Cooley)
        [#1010727] Entity framework exception if null inserted in XML column Changed null handling so that the value is only type cast when used in a select clause.	
        [#1010673] syntax error in queries generated by entity framework 2.0.6 ms.net sp1 Changed the filter handling to better work when subqueries in joins.
        [#1010687] Spelling error in NpgsqlCommand Object command timeout exception.
        Added method AddWithValue and made Add(String, object) obsolete and this was causing ambiguity problems with Add and NpgsqlDbType and DbType. See http://pgfoundry.org/tracker/index.php?func=detail&aid=1010714&group_id=1000140&atid=590 and http://pgfoundry.org/tracker/index.php?func=detail&aid=1010715&group_id=1000140&atid=592 for more details. Thanks Gildas (prime.gildas @nospam@ gmail.com)	  for heads up and discussion about that. Note that the issue of adding a new method which takes a DbType parameter is not finished yet. We should check if this is still needed. Updated documentation to not use DbType in the examples. 
        Bug: Money to Decimal conversion. Fixed problem where negative money values weren't being returned correctly. Thanks Denis Moinel (denis.moinel @nospam@ gmail.com) for heads up and patch. See http://pgfoundry.org/forum/message.php?msg_id=1005647 for more info.
        Fix time zone parsing bug reported in message 1005627.	Now handle negative timezones correctly.
        Fixed a bug where Npgsql wasn't honoring the connectiontimeout on Startup method. See http://pgfoundry.org/forum/message.php?msg_id=1005603 for more info. Thanks chaitra p (cpadsalgi @nospam@ peak6.com) for heads up.


Change Log

2009-12-28 00:41  jbcooley

	* src/: Npgsql/AssemblyInfo.cs, policy.2.0.Npgsql.config: Updated
	  for build 2.0.8

2009-12-27 16:51  jbcooley

	* src/Npgsql/SqlGenerators/: SqlBaseGenerator.cs,
	  SqlDeleteGenerator.cs, SqlInsertGenerator.cs,
	  SqlSelectGenerator.cs, SqlUpdateGenerator.cs,
	  VisitedExpression.cs: Initial support for bug fix reported in
	  message 1005698.  The fix changes valid sql that produced
	  incorrect results to sometimes valid sql that produced correct
	  results when valid.	Also contains work in progress to resolve
	  the invalid sql.

2009-12-27 16:44  jbcooley

	* src/Npgsql/NpgsqlProviderManifest.cs: Initial .NET code

2009-12-21 01:19  jbcooley

	* src/Npgsql/SqlGenerators/: SqlBaseGenerator.cs,
	  SqlSelectGenerator.cs: Fixed two bugs with Entity Framework SQL
	  generation: [#1010727] Entity framework exception if null
	  inserted in XML column Changed null handling so that the value is
	  only type cast when used in a select clause.	[#1010673] syntax
	  error in queries generated by entity framework 2.0.6 ms.net sp1
	  Changed the filter handling to better work when subqueries in
	  joins.

2009-12-20 00:33  fxjr

	* docs/UserManual.html:
	  Fixed manual to show examples using NpgsqlDbType instead of
	  DbType. Using DbType is only provided for backwards
	  compatibility. NpgsqlDbType is the prefered way to specify
	  paramter types.

2009-12-20 00:15  fxjr

	* src/Npgsql/NpgsqlState.resx:
	  [#1010687] Spelling error in NpgsqlCommand Object command timeout
	  exception. Fixed.

2009-12-19 13:30  fxjr

	* src/Npgsql/NpgsqlParameterCollection.cs,
	  testsuite/noninteractive/NUnit20/CommandTests.cs:
	  Added method AddWithValue and made Add(String, object) obsolete
	  and this was causing ambiguity problems with Add and NpgsqlDbType
	  and DbType. See
	  http://pgfoundry.org/tracker/index.php?func=detail&aid=1010714&group_id=1000140&atid=590
	  and
	  http://pgfoundry.org/tracker/index.php?func=detail&aid=1010715&group_id=1000140&atid=592
	  for more details. Thanks Gildas (prime.gildas @nospam@ gmail.com)
	  for heads up and discussion about that. Note that the issue of
	  adding a new method which takes a DbType parameter is not
	  finished yet. We should check if this is still needed.

2009-12-13 22:45  fxjr

	* src/NpgsqlTypes/DateDatatypes.cs:
	  Added support to parse "-infinity" and "infinity" date values.

2009-12-13 01:27  jbcooley

	* src/Npgsql/AssemblyInfo.cs: No longer the 2.0.7 release build.
	  Change version number so that compatibility flag can be used.

2009-12-13 01:26  jbcooley

	* src/Npgsql/NpgsqlTransaction.cs: Support Snapshot Isolation level
	  correctly.

2009-12-13 01:25  jbcooley

	* src/: NpgsqlTypes/NpgsqlTypesHelper.cs,
	  Npgsql/NpgsqlDataReader.cs: Support for provider specific types
	  (with compatibility flag on change to NpgsqlInterval)

2009-12-13 01:23  jbcooley

	* src/NpgsqlTypes/DateDatatypes.cs: Support casting time values to
	  DateTime type

2009-12-13 01:22  jbcooley

	* testsuite/noninteractive/NUnit20/CommandTests.cs: Tests to
	  validate type changes for provider specific type support

2009-12-13 01:17  jbcooley

	* testsuite/noninteractive/NUnit20/TypesTests.cs: Validate time
	  conversion.  Noticed that NpgsqlTimeTZ.LocalTime is really local
	  to timezone specified in value.

2009-12-13 01:16  jbcooley

	* testsuite/noninteractive/NUnit20/DataAdapterTests.cs: Tests from
	  bug report 1010734

2009-12-13 01:14  jbcooley

	* testsuite/noninteractive/NUnit20/ConnectionTests.cs: Tests from
	  bug report

2009-12-11 18:24  fxjr

	* src/NpgsqlTypes/NpgsqlTypeConverters.cs,
	  testsuite/noninteractive/NUnit20/CommandTests.cs:
	  Bug: Money to Decimal conversion. Fixed problem where negative
	  money values weren't being returned correctly. Thanks Denis
	  Moinel (denis.moinel @nospam@ gmail.com) for heads up and patch.
	  See http://pgfoundry.org/forum/message.php?msg_id=1005647 for
	  more info.

	  Also added test case.

2009-12-09 02:17  jbcooley

	* src/NpgsqlTypes/DateDatatypes.cs: Fix time zone parsing bug
	  reported in message 1005627.	Now handle negative timezones
	  correctly.

2009-12-09 02:11  jbcooley

	* testsuite/noninteractive/NUnit20/TypesTests.cs: Test time zone
	  parsing.  Exposes bug reported in message 1005627

2009-12-01 23:50  fxjr

	* src/Npgsql/NpgsqlConnectedState.cs:
	  Fixed a bug where Npgsql wasn't honoring the connectiontimeout on
	  Startup method.

	  See http://pgfoundry.org/forum/message.php?msg_id=1005603 for
	  more info. Thanks chaitra p (cpadsalgi @nospam@ peak6.com) for
	  heads up.
Powered By FusionForge