Excuse me if this has been reported already - but I've recent ran into a query
that the .net provider seems to be choking on - so the questions are - Is it a
known bug? Or is it just my setup?
Maybe use an older .net provider?
Setup:
Running Firebird 2.0.6
.Net Provider 2.6.5.1.
Query used:
select h.h_JobNumber, c.c_LastName, c.c_FirstName ,
case s.s_value when 'Y' then COALESCE(h.h_servicetech, '') else
COALESCE(h.h_representative,'') end as H_BTech,
s.s_value, v.v_year
from Header h
left join systemsetting s on s.s_system_id = 999 and s.s_shopid = h.h_shopid
left outer join Customer c on c.c_Customer_Id = h.h_CustomerId
left outer join vehicle v on v.v_vehicle_id = h.h_vehicleid
where (h.h_ShopId = 100)
Error:
:Error querying database FirebirdSql.Data.FirebirdClient.FbException
(0x80004005): arithmetic exception, numeric overflow, or string truncation --->
arithmetic exception, numeric overflow, or string truncation
at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in
C:\VSNET\FB_Provider_265\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 689
at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in
C:\VSNET\FB_Provider_265\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line
242
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord,
Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
This query works without issue within IBExpert.
Thanks,
Charlie
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
