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
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
