Function BenchmarkMariaDB_ForSystemTime

pkg/sql/parser/mariadb_bench_test.go:82–137

BenchmarkMariaDB_ForSystemTime benchmarks MariaDB temporal table query parsing.

(b *testing.B)

// BenchmarkMariaDB_ForSystemTime benchmarks MariaDB temporal table query parsing.
func BenchmarkMariaDB_ForSystemTime(b *testing.B) {
	benchmarks := []struct {
		name string
		sql  string
	}{
		{
			name: "as_of_timestamp",
			sql:  "SELECT * FROM t FOR SYSTEM_TIME AS OF TIMESTAMP '2024-01-01 00:00:00'",
		},
		{
			name: "all",
			sql:  "SELECT id, name FROM orders FOR SYSTEM_TIME ALL",
		},
		{
			name: "between",
			sql:  "SELECT * FROM t FOR SYSTEM_TIME BETWEEN TIMESTAMP '2023-01-01' AND TIMESTAMP '2023-12-31'",
		},
		{
			name: "from_to",
			sql:  "SELECT * FROM t FOR SYSTEM_TIME FROM TIMESTAMP '2023-01-01' TO TIMESTAMP '2024-01-01'",
		},
		{
			name: "join_with_system_time",
			sql: `SELECT o.id, h.status
				FROM orders o
				JOIN order_history h FOR SYSTEM_TIME AS OF TIMESTAMP '2024-01-01'
				ON o.id = h.order_id`,
		},
	}

	for _, bm := range benchmarks {
		bm := bm
		b.Run(bm.name, func(b *testing.B) {
			tkz := tokenizer.GetTokenizer()
			defer tokenizer.PutTokenizer(tkz)

			tokens, err := tkz.Tokenize([]byte(bm.sql))
			if err != nil {
				b.Fatalf("Tokenize error: %v", err)
			}

			b.ResetTimer()
			b.ReportAllocs()

			for i := 0; i < b.N; i++ {
				p := parser.NewParser(parser.WithDialect(string(keywords.DialectMariaDB)))
				result, err := p.ParseFromModelTokens(tokens)
				if err != nil {
					b.Fatalf("Parse error: %v", err)
				}
				ast.ReleaseAST(result)
				p.Release()
			}
		})
	}
}

// BenchmarkMariaDB_ConnectBy benchmarks MariaDB CONNECT BY hierarchical query parsing.