Skip to content

sqlStatement.getTableNames() not returning all tables used if you identify insert statement with nested derived tables #36

@FrankSagt

Description

@FrankSagt

Hi @keif888
When the insert statement is identified, not all tables are returned when a derived-table is used.
I only get two tables back, instead of 4.

I also took the example of Microsoft, with the same effect.
Or show the SQL Script in attachment.
SQLQuery1.sqlSample Insert Into.txt

https://docs.microsoft.com/de-de/sql/t-sql/statements/insert-transact-sql?view=sql-server-2017#v-inserting-data-returned-from-an-output-clause

Where is my mistake? Which classes do I have to use to analyze nested derived tables?

Vielen dank für deine Unterstützung .

Viele Grüße Frank Kreß

Metadata

Metadata

Assignees

Labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions