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:
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.1.21 OS:Any
Assigned to: CPU Architecture:Any

[16 Oct 2007 11:55] Susanne Ebrecht


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".
[16 Oct 2007 12:02] Hartmut Holzgraefe
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)
[19 Oct 2007 20:19] Konstantin Osipov
I'm curios, are you really using PROCEDURE ANALYSE?
[30 Jan 2008 20:05] Omer Barnir
Workaround: Use a from with limit 1 in the select clause
[8 Feb 2018 21:54] Roy Lyseng
Posted by developer:
Will not be fixed since the feature PROCEDURE ANALYSE has been removed in 8.0