db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English <john.fore...@gmail.com>
Subject Re: Column is in more than one table?
Date Tue, 28 Sep 2021 19:12:09 GMT
On Tue, 28 Sep 2021, 17:59 Rick Hillegas, <rick.hillegas@gmail.com> wrote:

> On 9/28/21 4:51 AM, John English wrote:
>
> If I issue the following query:
>
> SELECT t_time,facility FROM system_log,(SELECT time FROM system_log ORDER
> BY facility) AS x WHERE system_log.time=x.time
>
> I get an error: "Column name 'FACILITY' is in more than one table in the
> FROM list."
>
> Why does it consider Facility to be a column in table X? Is this correct
> behaviour, or is it a Derby bug?
>
> This looks like a bug to me, but one with an easy workaround:
>
> SELECT s.time,s.facility FROM system_log s,(SELECT time FROM system_log ORDER BY facility)
AS x WHERE s.time=x.time;
>
> I already worked around it, I just wanted to know if I should submit a bug
report.

>

Mime
View raw message