Skip to content

SQL Formatter Crash #2217

Description

@webloft

Description

The formatter crashes on following wordpress query:

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts  LEFT JOIN wp_postmeta AS sq1 ON ( wp_posts.ID = sq1.post_id AND sq1.meta_key = '_wp_attached_file' ) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_elementor_is_screenshot' ) JOIN wp_icl_translations wpml_translations
							ON wp_posts.ID = wpml_translations.element_id
								AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) 
					 WHERE 1=1  AND (((wp_posts.post_title LIKE '%foo%') OR (wp_posts.post_excerpt LIKE '%foo%') OR (wp_posts.post_content LIKE '%foo%') OR (sq1.meta_value LIKE '%foo%')))  AND ( 
  wp_postmeta.post_id IS NULL
) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status = 'inherit' OR wp_posts.post_status = 'private')) AND wpml_translations.language_code IN ('en','de') 
					 GROUP BY wp_posts.ID
					 ORDER BY wp_posts.post_title LIKE '%foo%' DESC, wp_posts.post_date DESC
					 LIMIT 0, 20

HeidiSQL version

12.11.0.7069

Database server version

Reproduction recipe

Just copy paste the query and run the formatter

Error/Backtrace

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQL

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions