Function TestParseMergeExtended

pkg/sql/parser/coverage_improvement_test.go:933–948

TestParseMergeExtended targets parseMergeStatement (85.1%) and parseMergeWhenClause (84.4%)

(t *testing.T)

// TestParseMergeExtended targets parseMergeStatement (85.1%) and parseMergeWhenClause (84.4%)
func TestParseMergeExtended(t *testing.T) {
	sqls := []struct {
		name string
		sql  string
	}{
		{"MERGE with DELETE", `MERGE INTO target t USING source s ON t.id = s.id WHEN MATCHED AND s.deleted = true THEN DELETE WHEN MATCHED THEN UPDATE SET t.name = s.name WHEN NOT MATCHED THEN INSERT (id, name) VALUES (s.id, s.name)`},
		{"MERGE multiple MATCHED", `MERGE INTO inventory t USING updates s ON t.product_id = s.product_id WHEN MATCHED AND s.qty = 0 THEN DELETE WHEN MATCHED THEN UPDATE SET t.qty = s.qty WHEN NOT MATCHED THEN INSERT (product_id, qty) VALUES (s.product_id, s.qty)`},
	}

	for _, tt := range sqls {
		t.Run(tt.name, func(t *testing.T) {
			tree := parseSQLHelper(t, tt.sql)
			defer ast.ReleaseAST(tree)
		})
	}
}

// TestParseComparisonExpressionEdgeCases targets parseComparisonExpression (76.4%)
func TestParseComparisonExpressionEdgeCases(t *testing.T) {