Bug #41115 Bad error report on a bad sql syntax

• Submitted: 28 Nov 2008 21:25
• Modified: 1 Dec 2008 10:29
• Reporter: sergio tamagno
• Status: Not a Bug
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• Version: 5.0.45-community-nt-log
• OS: Windows (xp)
• CPU Architecture: Any
• Tags: column, inner

[28 Nov 2008 21:25] sergio tamagno

Description:
I´ve executed this select 

SELECT habitacion_dia.id_habitaciondia, disponibles, precio_dia.id_precio_dia 	FROM habitacion_dia INNNER JOIN tipohabitacion ON tipohabitacion.id_tipohabitacion = habitacion_dia.id_tipohabitacion 

and received habitacion_dia.id_habitaciondia column doesn´t exist, but the error is INNNER with 3 N

How to repeat:
create two tables and execute the select..

[1 Dec 2008 10:29] Sveta Smirnova

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

INNNER is not reserved word, so it can be used as alias.

Statement you used is exacly same as SELECT habitacion_dia.id_habitaciondia, disponibles, precio_dia.id_precio_dia 	FROM habitacion_dia as `INNNER` JOIN tipohabitacion ON tipohabitacion.id_tipohabitacion = habitacion_dia.id_tipohabitacion 

So it does not contain syntax error.