Function BenchmarkScanner_ComplexQuery

pkg/sql/security/scanner_bench_test.go:159–184

BenchmarkScanner_ComplexQuery benchmarks scanning complex SQL queries

(b *testing.B)

// BenchmarkScanner_ComplexQuery benchmarks scanning complex SQL queries
func BenchmarkScanner_ComplexQuery(b *testing.B) {
	sql := `
		SELECT
			u.id, u.name, u.email,
			o.order_id, o.total,
			p.product_name
		FROM users u
		LEFT JOIN orders o ON u.id = o.user_id
		INNER JOIN products p ON o.product_id = p.id
		WHERE u.active = true
			AND o.order_date > '2023-01-01'
			AND p.category IN ('electronics', 'books')
		ORDER BY o.order_date DESC
		LIMIT 100
	`
	scanner := NewScanner()

	tree := parseSQL(b, sql)
	defer ast.ReleaseAST(tree)

	b.ReportAllocs()
	b.ResetTimer()
	for i := 0; i < b.N; i++ {
		scanner.Scan(tree)
	}
}

// BenchmarkScanner_LargeQuery benchmarks scanning large SQL queries
func BenchmarkScanner_LargeQuery(b *testing.B) {