Function TestIntegration_AllDialects

pkg/sql/integration_test.go:118–214

TestIntegration_AllDialects tests all SQL files across all dialects

(t *testing.T)

// TestIntegration_AllDialects tests all SQL files across all dialects
func TestIntegration_AllDialects(t *testing.T) {
	// Get the project root (go up from pkg/sql to project root)
	projectRoot, err := filepath.Abs(filepath.Join("..", ".."))
	if err != nil {
		t.Fatalf("Failed to determine project root: %v", err)
	}

	files := loadSQLTestFiles(t, projectRoot)

	if len(files) == 0 {
		t.Skip("No SQL test files found - testdata directory may not exist")
	}

	t.Logf("Found %d SQL test files to process", len(files))

	var results []TestResult
	successCount := 0
	failCount := 0

	// Group tests by dialect for better organization
	dialectGroups := make(map[string][]SQLTestFile)
	for _, file := range files {
		dialectGroups[file.Dialect] = append(dialectGroups[file.Dialect], file)
	}

	// Run tests for each dialect
	for dialect, dialectFiles := range dialectGroups {
		t.Run(dialect, func(t *testing.T) {
			dialectSuccess := 0
			dialectFail := 0

			for _, file := range dialectFiles {
				t.Run(file.Name, func(t *testing.T) {
					result := testSQLFile(t, file)
					results = append(results, result)

					if result.Success {
						dialectSuccess++
						successCount++
					} else {
						dialectFail++
						failCount++
						t.Logf("Failed to parse %s: %v", file.Name, result.Error)
					}
				})
			}

			t.Logf("Dialect %s: %d passed, %d failed (%.1f%% success rate)",
				dialect, dialectSuccess, dialectFail,
				100.0*float64(dialectSuccess)/float64(dialectSuccess+dialectFail))
		})
	}

	// Summary statistics
	t.Logf("\n=== Integration Test Summary ===")
	t.Logf("Total files tested: %d", len(files))
	t.Logf("Successful parses: %d", successCount)
	t.Logf("Failed parses: %d", failCount)