Bug #21330 error in subquery when using ANY OR NOT IN OR IN FUNCTION

• Submitted: 28 Jul 2006 14:40
• Modified: 28 Jul 2006 15:26
• Reporter: Faraz Ahmad
• Status: Not a Bug
• Category: MySQL Server
• Severity: S5 (Performance)
• Version: MySQL 3.23.58
• OS: Linux (LINUX)
• CPU Architecture: Any
• Tags: <>, ANY, NOT IN, SUB QUERY

[28 Jul 2006 14:40] Faraz Ahmad

Description:
system is gibing following error 
"You have an error in your SQL syntax near 'select ROOM_ID from reservation_room where `START_DATE` BETWEEN '2006-07-03' ' at line 1  "
i can't figure out why
SELECT T.TYPE_NAME, R.ROOM_ID, R.ROOM_NUMBER, T.TYPE_FACILITY, T.TYPE_MAX, T.ROOM_TYPE_ID FROM room R, room_type T WHERE R.ROOM_TYPE_ID =T.ROOM_TYPE_ID AND R.ROOM_ID not in (select ROOM_ID FROM room where ROOM_ID=1)

How to repeat:
ITS FIXED IN NEXT VERSION

[28 Jul 2006 15:26] MySQL Verification Team

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Subqueries are supported from version >=4.1.

http://dev.mysql.com/doc/refman/4.1/en/subqueries.html