-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Richard Clarke wrote:
Dan,
According to http://www.mysql.com/doc/en/News-4.1.0.html
"SELECT ... FROM DUAL is an alias for SELECT (To be compatible with
some other databases)."
Your example does work however.
mysql> select * from ( sele
set (0.00 sec)
Richard.
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Richard Clarke" <[EMAIL PROTECTED]>
Cc: "Victoria Reznichenko" <[EMAIL PROTECTED]>; "MySQL"
<[EMAIL PROTECTED]>
Sent: Tuesday, December 24,
In the last episode (Dec 24), Richard Clarke said:
> Victoria,
> I pulled that latest updates to the 4.1 tree to make sure I had the most
> recent version and I still have the same problem. Here is a log of my
> actions.
>
> # cd /usr/local/mysql-4.1
> mysql-4.1 # bin/mysql --defaults-file=etc
;
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 24, 2002 3:55 PM
Subject: re: 4.1 questions: subqueries which use dual
> On Sunday 22 December 2002 08:06, wrote:
> > Mysql,
> > Selecting from `dual` with a simple query works fine,
> >
> > mysql> sel
On Sunday 22 December 2002 08:06, wrote:
> Mysql,
> Selecting from `dual` with a simple query works fine,
>
> mysql> select 1 x from dual;
> +---+
>
> | x |
>
> +---+
>
> | 1 |
>
> +---+
>
> but within a derived table,
>
> mysql> select * from (select 1 x from dual) s;
> ERROR 1146: Table 'tes
Mysql,
Selecting from `dual` with a simple query works fine,
mysql> select 1 x from dual;
+---+
| x |
+---+
| 1 |
+---+
but within a derived table,
mysql> select * from (select 1 x from dual) s;
ERROR 1146: Table 'test.dual' doesn't exist
Is this an oversight or is it purposefully so?
Than
