Closed
Description
Failing SQL Feature:
It takes too long to parse a query with multiple nested subqueries and/or joins with subqueries since 4.6
Can confirm, that 4.5 doesn't have this issue.
SQL Example:
SELECT (SELECT '1.0' AS '@Version', (SELECT 'Test' AS 'name', (SELECT (SELECT DISTINCT 51.64315 AS '@lat', 14.31709 AS '@lon' FOR XML PATH('trkpt'), TYPE) FOR XML PATH(''), ROOT('trkseg'), TYPE) FOR XML PATH('trk'), TYPE) FOR XML PATH('gpx'), TYPE) FOR XML PATH('')
Originally posted here dbeaver/dbeaver#20060
Software Information:
- JSqlParser 4.6
- MS SQL Server, but probably not only (we have an issue about PostgreSQL too, but without example)