Select query with a parameter value that is longer than the size of the column
results in an exception
------------------------------------------------------------------------------------------------------
Key: DNET-384
URL: http://tracker.firebirdsql.org/browse/DNET-384
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.6
Environment: Windows
Reporter: Ruben Rorije
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
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
