On Tue, Jun 30, 2009 at 8:08 PM,
[email protected]<[email protected]> wrote:
> any updates about this. Do you need me to submit a test case?
I can confirm this is a bug in the provider.
On FbDataReader.cs, line ~377:
for (int i = 0; i < this.fields.Count; i++)
{
columnsIndexes.Add(this.fields[i].Alias.ToUpper(), i);
}
The error shows up when trying to run a sql like:
select table1.field, table2.field
On such cases fields[i].Alias is "field" for both items. This causes
the dictionary columnsIndexes to throw the "duplicate key" error.
Maybe a solution is to concatenate Alias and Relation?
columnsIndexes.Add(this.fields[i].Relation.ToUpper()
+"."+this.fields[i].Alias.ToUpper(), i);
As a side note, ToUpper() can be removed if columnsIndexes is
instantiated using StringComparer.CurrentCultureIgnoreCase.
hth,
--
Douglas Tosi
www.sinatica.com
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
