Function TestScan_UnionWithNulls

pkg/sql/security/scanner_test.go:229–253

(t *testing.T)

}

func TestScan_UnionWithNulls(t *testing.T) {
	scanner := NewScanner()

	// Create UNION SELECT NULL, NULL, NULL
	setOp := &ast.SetOperation{
		Left: &ast.SelectStatement{
			Columns: []ast.Expression{&ast.Identifier{Name: "id"}},
		},
		Operator: "UNION",
		Right: &ast.SelectStatement{
			Columns: []ast.Expression{
				&ast.Identifier{Name: "NULL"},
				&ast.Identifier{Name: "NULL"},
				&ast.Identifier{Name: "NULL"},
			},
		},
	}

	tree := &ast.AST{Statements: []ast.Statement{setOp}}
	result := scanner.Scan(tree)

	if result.HighCount == 0 {
		t.Error("expected at least one high severity finding for UNION with multiple NULLs")
	}
}

func TestScan_UnionSystemTables(t *testing.T) {
	scanner := NewScanner()