json_mergepatch(<j>, <p>)

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.39.0⊘ 2008R2 - 2019⊘ 8.3 - 14⚠ 21cbc⚠ 18c - 19cb⊘ 11gR1 - 12cR2⊘ 8.0.11 - 8.0.30a⊘ 5.0 - 5.7⊘ 10.4 - 10.9.2a⊘ 5.1 - 10.3⊘ 9.7 - 11.5.7⊘ 2.0
  1. Use json_merge_patch instead (note the second underscore)
  2. Improper handling of some non-JSON object arguments
  3. Improper handling of some non-JSON arguments