Skip to content

[BUG] JSQLParser Version 4.6 : SQL Server : parsing takes too long #1800

Closed
@E1izabeth

Description

@E1izabeth

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)

Metadata

Metadata

Labels

P1high prioritybug

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions