go-zetasqlite icon indicating copy to clipboard operation
go-zetasqlite copied to clipboard

Fixing MERGE to use named paths in table names

Open bony2023 opened this issue 5 months ago • 6 comments

Closes: https://github.com/goccy/bigquery-emulator/issues/299

The sub-actions (INSERT, UPDATE and DELETE) inside the merge statement currently do not work when using BigQuery Emulator, as they are not able to recognize the exact table they need to work upon.

This PR fixes the logic by adding namePath to the source and target table names joined by underscore to work on sqlite tables.

bony2023 avatar Sep 15 '24 23:09 bony2023