I'm sure either #1 or #3 happens already. I know I've been nagged about ambiguous field names, but I also know that somewhere I've seen _1 or _2 be appended to field names (That might be just the SQL IDE I use doing that).
I can't get on board with #2 because most wrappers only look at the first value, or, would overwrite "SalesTotal" with whatever the last column has the name SalesTotal. The wrapper I use in Delphi uses both named field arrays (IE: tbl.FieldByName['SalesTotal']) as well as field numbers (IE: tbl.FieldByID[1]) but I try to use the field names since the order of the field names COULD change. On Wed, Aug 26, 2015 at 10:12 AM, Domingo Alvarez Duarte < sqlite-mail at dev.dadbiz.es> wrote: > Hello ! > > Three possibilities: > > 1- Show a qualified name to disambiguate. > > 2 - Show duplicated column names. > > 3 - Show error message message about ambiguos column name. > > > > On the case mentioned apply rule 2, like postgresql do. > > Cheers ! > > > > Wed Aug 26 2015 2:35:41 pm CEST CEST from "Simon Slavin" > ><slavins at bigfraud.org> Subject: Re: [sqlite] Why sqlite show qualified > >column names when selecting from views ? > > > > On 26 Aug 2015, at 10:17am, Domingo Alvarez Duarte > ><sqlite-mail at dev.dadbiz.es> wrote: > > > > > >>But like it's already done on several other cases why not fix this issue > >>and > >> wrap this fix with "#ifdef SQLITE_CLEAN_COLUMN_NAMES" that's not defined > >>by > >> default so older code will remain working but new code can enable this > and > >> use it ? > >> > > > With that definition set, suppose you execute the following two > commands: > > > > ATTACH DATABASE 'August' AS salesThisMonth; > > SELECT clientName, salesThisMonth.salesTotal, salesTotal > > FROM sales > > JOIN salesThisMonth ON salesThisMonth.clientId = sales.clientId > > ORDER BY clientName; > > > > What should the name be for the second column ? > > > > Also, with > > > > SELECT a, b, 100*a/b FROM myTable; > > > > What should the name of the third column be ? > > > > Simon. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >