Bug #2815 Example in "13.1.8.8 Subqueries in the FROM clause" doesn't work
Submitted: 15 Feb 2004 21:51 Modified: 16 Feb 2004 0:51
Reporter: Alex Abyzov Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:Your MySQL connection id is 14 to server OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[15 Feb 2004 21:51] Alex Abyzov 
Description:
The example first example in chapter "13.1.8.8 Subqueries in the FROM clause" doesn't work.
I have version 4.0.18-standard running on linux RedHat and the given example doesn't work. The mysql says 
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT s1 AS sb1, s2 AS sb2, s3*2 AS sb3 FROM t1) AS sb
 WHERE

How to repeat:
Just follow the example.

Suggested fix:
No ideas. But the feature would be very usefull for me.
[15 Feb 2004 23:17] Apachez 
You need 4.1 or newer (higher versionnumber) in order to be able to use subqueries.
[15 Feb 2004 23:31] Alex Abyzov 
OK. I was just confused since all the other examples with subqueries were all right but the most useful for was not. As soon as 4.1 will be recommended for use I'll try it.
[16 Feb 2004 0:51] Alexander Keremidarski 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php