Exactly, this is the issue. pablo
Douglas Tosi escribió: > 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, > ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
