René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] JSQLParser 5.4-SNAPSHOT : MySQL : PROCEDURE ANALYSE() not supported in SELECT statements","articleBody":"### Failing SQL Feature\nMySQL `PROCEDURE ANALYSE()` clause used in `SELECT` statements.\n\nMySQL (notably in older versions such as 5.5) supports `PROCEDURE ANALYSE()` as a query modifier that analyzes a result set and suggests optimal column types and sizes. It is appended directly to a `SELECT` statement and returns metadata instead of modifying data.\n\nAlthough seems to be deprecated and removed in modern MySQL versions, it is still valid syntax in legacy mysql databases and may appear in migration scenarios or older production systems.\n\n### SQL Example\n```sql\nCREATE TABLE heavy_table (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    col1 INT,\n    col2 VARCHAR(50)\n);\n\nINSERT INTO heavy_table (col1, col2) VALUES\n(10, 'alpha'),\n(20, 'beta'),\n(10, 'gamma');\n\nSELECT col1, col2\nFROM heavy_table\nPROCEDURE ANALYSE(10, 256);\n```\n\n### Parsing error\n`ParseException: Encountered: \u003cS_IDENTIFIER\u003e / \"ANALYSE\", at line 1, column 46, in lexical state DEFAULT.`","author":{"url":"https://github.com/tomershay","@type":"Person","name":"tomershay"},"datePublished":"2026-04-13T18:01:14.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2428/JSqlParser/issues/2428"}