[Firebird-net-provider] [FB-Tracker] Created: (DNET-618) Select query with a parameter value that is longer than the size of the column results in an exception, only with firebird

[Pantarei A. (JIRA) <tr...@fi...>]

Select query with a parameter value that is longer than the size of the column results in an exception, only with firebird
--------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-618
                 URL: http://tracker.firebirdsql.org/browse/DNET-618
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 2.6
         Environment: Windows
            Reporter: Pantarei Andrea
            Assignee: Jiri Cincura


I upgraded my .Net DataProvider from 2.5.2 to 2.6.5.
A simple select query that ran with no problems using the 2.5.2 version, will now throw an exception when using the 2.6.5 version.

When I execute a query with a (string)parameter value that is longer than the size of the column in the database an IscException occurs.

the error code is: 335544321 and the message is 'Arithmetic overflow or division by zero has occurred. arithmetic exception, numeric overflow, or string truncation. string right truncation.'

If it is possible I would like the behaviour of the 2.5.2 version back, because it makes my code a lot simpler. Otherwise I have to make sure a user can not enter data that will result in an exception.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira