MySQL Bugs: #31634: procedure analyse won't work

Bug #31634	procedure analyse won't work
Submitted:	16 Oct 2007 11:55	Modified:	8 Feb 2018 21:54
Reporter:	Susanne Ebrecht	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S3 (Non-critical)
Version:	5.1.21	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Hi,

MySQL-CLI:

mysql> SELECT (12.4767-6)*1000/7.2659 procedure analyse();

ERROR 1064 (42000): Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'procedure analyse()' in Zeile 1

Translation: Error at the SQL syntax. Please look at the handbook for the correct syntax.

How to repeat:
You can use every select, that doesn't have a "from".

Suggested fix:
It seems, that it only occurs, when the select statement has no "from".

mysql> select 23 procedure analyse()\G
ERROR 1064 (42000): 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 'procedure analyse()' at line 1

mysql> select 23 FROM mysql.user procedure analyse()\G
*************************** 1. row ***************************
             Field_name: 23
              Min_value: 23
              Max_value: 23
             Min_length: 2
             Max_length: 2
       Empties_or_zeros: 0
                  Nulls: 0
Avg_value_or_avg_length: 23.0000
                    Std: 0.0000
      Optimal_fieldtype: ENUM('23') NOT NULL
1 row in set (0.00 sec)

Susanne,
I'm curios, are you really using PROCEDURE ANALYSE?

Workaround: Use a from with limit 1 in the select clause

Posted by developer:
 
Will not be fixed since the feature PROCEDURE ANALYSE has been removed in 8.0