[Zope-dev] dupe column names not supported (Shared.DC.ZRDB) ?

[Ross J. Reedstrom]

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