Function TestScan_DangerousFunction_LoadFile

pkg/sql/security/scanner_test.go:208–227

(t *testing.T)

}

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

	// Create AST with LOAD_FILE function call
	selectStmt := &ast.SelectStatement{
		Columns: []ast.Expression{
			&ast.FunctionCall{
				Name:      "LOAD_FILE",
				Arguments: []ast.Expression{&ast.LiteralValue{Value: "/etc/passwd", Type: "STRING"}},
			},
		},
	}

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

	if result.CriticalCount == 0 {
		t.Error("expected at least one critical finding for LOAD_FILE function")
	}
}

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