Small bug in error message with subselect in MySQL-4.1

am 24.11.2002 12:35:04 von Jocelyn Fournier

Hi,

How-to-repeat :

mysql> EXPLAIN SELECT 1 FROM (SELECT 1 as a) HAVING (SELECT a)=1;
ERROR 1054: Unknown column '.a' in 'field list'

=> Why ".a" instead of "a" ?

However :

mysql> EXPLAIN SELECT 1 FROM (SELECT 1) HAVING (SELECT a)=1;
ERROR 1054: Unknown column 'a' in 'field list'

is ok :)

Regards,
Jocelyn

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13095@lists.mysql.com
To unsubscribe, e-mail

Re: Small bug in error message with subselect in MySQL-4.1

am 24.11.2002 20:23:31 von Sanja Byelkin

Hi!

On Mon, Nov 25, 2002 at 11:37:35AM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> mysql> EXPLAIN SELECT 1 FROM (SELECT 1 as a) HAVING (SELECT a)=1;
> ERROR 1054: Unknown column '.a' in 'field list'
>
> => Why ".a" instead of "a" ?

Thank you for bugreport!
There are not error here at all.
I fixed it (pushed & committed).

[skip]

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13099@lists.mysql.com
To unsubscribe, e-mail

Re: Small bug in error message with subselect in MySQL-4.1

am 24.11.2002 21:18:04 von Jocelyn Fournier

Hi,

About what should be considered as an error and what should not, I'm
wondering if :

mysql> SELECT 1 as a FROM (SELECT 1) HAVING (SELECT a)=1;
ERROR 1245: Reference 'a' not supported (forward reference in item list)

is really forbidden (since

SELECT 1 as a FROM (SELECT 1) HAVING a=1;

is working ok :))

Thanks !
Jocelyn

----- Original Message -----
From: "Sanja Byelkin"
To: "Jocelyn Fournier"
Cc:
Sent: Sunday, November 24, 2002 7:23 PM
Subject: Re: Small bug in error message with subselect in MySQL-4.1

> Hi!
>
> On Mon, Nov 25, 2002 at 11:37:35AM -0000, Jocelyn Fournier wrote:
> > Hi,
> >
> > How-to-repeat :
> >
> > mysql> EXPLAIN SELECT 1 FROM (SELECT 1 as a) HAVING (SELECT a)=1;
> > ERROR 1054: Unknown column '.a' in 'field list'
> >
> > => Why ".a" instead of "a" ?
>
> Thank you for bugreport!
> There are not error here at all.
> I fixed it (pushed & committed).
>
> [skip]
>
> --
> For technical support contracts, visit https://order.mysql.com/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
> /_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
> <___/ www.mysql.com
>
>
>

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13101@lists.mysql.com
To unsubscribe, e-mail

Re: Small bug in error message with subselect in MySQL-4.1

am 24.11.2002 21:26:28 von Jocelyn Fournier

Hi,

Here is another similar bug ;)

How-to-repeat :

CREATE TABLE t1 (a int(1));
INSERT INTO t1 VALUES (1);
SELECT 1 FROM (SELECT a FROM t1) HAVING (SELECT a)=1;

ERROR 1054: Unknown column 't1.a' in 'field list'

However :

SELECT 1 FROM (SELECT 1 as a FROM t1) HAVING (SELECT a)=1;

is working

Regards,
Jocelyn

----- Original Message -----
From: "Sanja Byelkin"
To: "Jocelyn Fournier"
Cc:
Sent: Sunday, November 24, 2002 7:23 PM
Subject: Re: Small bug in error message with subselect in MySQL-4.1

> Hi!
>
> On Mon, Nov 25, 2002 at 11:37:35AM -0000, Jocelyn Fournier wrote:
> > Hi,
> >
> > How-to-repeat :
> >
> > mysql> EXPLAIN SELECT 1 FROM (SELECT 1 as a) HAVING (SELECT a)=1;
> > ERROR 1054: Unknown column '.a' in 'field list'
> >
> > => Why ".a" instead of "a" ?
>
> Thank you for bugreport!
> There are not error here at all.
> I fixed it (pushed & committed).
>
> [skip]
>
> --
> For technical support contracts, visit https://order.mysql.com/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
> /_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
> <___/ www.mysql.com
>
>
>

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13102@lists.mysql.com
To unsubscribe, e-mail

Re: Small bug in error message with subselect in MySQL-4.1

am 25.11.2002 00:44:47 von Sanja Byelkin

Hi!

On Mon, Nov 25, 2002 at 08:20:32PM -0000, Jocelyn Fournier wrote:
> Hi,
>
> About what should be considered as an error and what should not, I'm
> wondering if :
>
> mysql> SELECT 1 as a FROM (SELECT 1) HAVING (SELECT a)=1;
> ERROR 1245: Reference 'a' not supported (forward reference in item list)
>
> is really forbidden (since
>
> SELECT 1 as a FROM (SELECT 1) HAVING a=1;
>
> is working ok :))

Thank you for bug report. I fixed that bug (patch is pushed already).

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13103@lists.mysql.com
To unsubscribe, e-mail

Re: Small bug in error message with subselect in MySQL-4.1

am 25.11.2002 00:46:15 von Sanja Byelkin

Hi!

On Mon, Nov 25, 2002 at 08:29:18PM -0000, Jocelyn Fournier wrote:
> Hi,
>
> Here is another similar bug ;)
>
> How-to-repeat :
>
> CREATE TABLE t1 (a int(1));
> INSERT INTO t1 VALUES (1);
> SELECT 1 FROM (SELECT a FROM t1) HAVING (SELECT a)=1;
>
> ERROR 1054: Unknown column 't1.a' in 'field list'
>
> However :
>
> SELECT 1 FROM (SELECT 1 as a FROM t1) HAVING (SELECT a)=1;
>
> is working

Thank you for bug report! This bug is fixed in same cset as previous one.

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13104@lists.mysql.com
To unsubscribe, e-mail