Same problem has been reported with Oracle 8.1, since it too will return duplicate names. The SQL92 spec is a bit ambiguous about whether all returned column names must be unique. Ross On Tue, Dec 17, 2002 at 01:09:13PM -0500, Adam Manock wrote:
specifically with:
SELECT W1.city, W1.temp_lo AS low, W1.temp_hi AS high, W2.city, W2.temp_lo AS low, W2.temp_hi AS high FROM weather W1, weather W2 WHERE W1.temp_lo < W2.temp_lo AND W1.temp_hi > W2.temp_hi;
Error, exceptions.ValueError: Duplicate column name, city
Traceback (innermost last): Module ZPublisher.Publish, line 98, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module Shared.DC.ZRDB.Connection, line 115, in manage_test Module Shared.DC.ZRDB.Results, line 52, in __init__ ValueError: Duplicate column name, city