[Zope-dev] dupe column names not supported (Shared.DC.ZRDB) ?
Ross J. Reedstrom
reedstrm@rice.edu
Tue, 17 Dec 2002 13:11:33 -0600
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