[DB-SIG] Re: May we get an actual ANSWER to the F.A.Q...How c an I construct a dictionary???

Dittmar, Daniel daniel.dittmar at sap.com
Thu Sep 25 10:53:09 EDT 2003

> > - there are those nitpickers who say that column names aren't 
> > necessarily unique and that the uppercase/lowercase issues 
> make it worse
> Heh, that's funny. Never thought of that, but it is 
> certainly true for DB2. I just tried 
> How odd! I had assumed that this would be an error. On the
> other hand, I don't really see why anyone would like to do that

This mostly happens when joining tables and similar named
columns appear in both tables.

SAP DB did complain, but we had
to become more lenient as applications that were
ported from other databases were actually generating
such result sets.

> that, and I could accept that a tuple -> dict tool would
> fail silently on something like this. I haven't tried this
> with db_row etc...

One more implementation defined feature (how to resolve duplicate
column names) probably won't make that much of a difference.


Daniel Dittmar
SAP DB, SAP Labs Berlin
daniel.dittmar at sap.com

More information about the DB-SIG mailing list