Enhanced MERGE statement — F313
BigQuery
Db2 (LUW)
Derby
H2
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
SQLite
2007
2009
2011
2013
2015
2017
2019
2021
2023
⚠ 2008R2 - 2022
a
✓ 15 - 18
c
⚠ 11gR1 - 23.9
a
b
✓ 2.0.202 - 2.4.240
a
⚡ 1.4.198 - 1.4.200
a
✓ 10.15.1.3 - 10.17.1.0
✓ 9.7 - 12.1.2
✓ 2.0
Only a single
update
or
insert
branch
The
on
clause requires parenthesis:
on
(
<condition>
)
Supports i
nsert … on conflict do …