MySQL Bugs: #35898: Impossible to use the word 'position' in a procedure

Bug #35898	Impossible to use the word 'position' in a procedure
Submitted:	8 Apr 2008 11:06	Modified:	8 Apr 2008 15:04
Reporter:	moi meme	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.0.16	OS:	Windows
Assigned to:	Sergei Tkachenko	CPU Architecture:	Any
Tags:	position, PROCEDURE

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
If we use the word 'position', and ddl syntax error is generated without reasons.

How to repeat:
create a procedure
set as text:

-- --------------------------------------------------------------------------------
-- Routine DDL
-- --------------------------------------------------------------------------------
DELIMITER //

CREATE PROCEDURE `spot_v4`.`routine1` ()
BEGIN
  SELECT position;
END

Suggested fix:
remove position from keywords list ?!

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.