Description:
Hello,
When I run the following query:
Select Can as MiCantidad, MiCantidad * 2 from Stocks limit 10
I get the following error:
'The column 'MiCantidad' in field list is unknown'
So, Can I reference to a column by its alias in a
select statement?
Thanks in advance,
Rafa
How-To-Repeat:
Select Can as MiCantidad, MiCantidad * 2 from stocks limit 10
Fix:
-
Synopsis:optimizer bug in the index used by mysql/Innodb in the search
Submitter-Id: <submitter ID>
Originator: Rafa
Organization: Pecomark
MySQL support: none
Severity: non-critical
Priority: medium
Category: mysqld-max-nt
Class: sw-bug
Release: mysqld 4.0.12
Exectutable: mysqld-max-nt
Environment: Pentium III-MMX, 500 MHZ, 540 MB
System: Windows 2000
Compiler: -
Architecture: i
__________________________________________________________________
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380
Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promos=380455
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
