Function TestScan_TimeBasedFunction

pkg/sql/security/scanner_test.go:176–206

(t *testing.T)

}

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

	// Create AST with SLEEP function call
	selectStmt := &ast.SelectStatement{
		Columns: []ast.Expression{
			&ast.FunctionCall{
				Name:      "SLEEP",
				Arguments: []ast.Expression{&ast.LiteralValue{Value: "5", Type: "INTEGER"}},
			},
		},
	}

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

	if result.HighCount == 0 {
		t.Error("expected at least one high severity finding for SLEEP function")
	}

	found := false
	for _, f := range result.Findings {
		if f.Pattern == PatternTimeBased {
			found = true
			break
		}
	}
	if !found {
		t.Error("expected TIME_BASED pattern to be detected")
	}
}

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