Function TestHandleValidateSQL_AllDialects

pkg/mcp/tools_test.go:430–454

--------------------------------------------------------------------------- Edge-case tests ---------------------------------------------------------------------------

(t *testing.T)

// ---------------------------------------------------------------------------

func TestHandleValidateSQL_AllDialects(t *testing.T) {
	ctx := context.Background()
	dialects := []string{"generic", "mysql", "postgresql", "sqlite", "sqlserver", "oracle", "snowflake"}

	for _, dialect := range dialects {
		t.Run(dialect, func(t *testing.T) {
			req := makeReq(map[string]any{
				"sql":     "SELECT 1",
				"dialect": dialect,
			})
			res, err := handleValidateSQL(ctx, req)
			if err != nil {
				t.Fatalf("unexpected error for dialect %s: %v", dialect, err)
			}
			data := unmarshalResult(t, res)
			valid, ok := data["valid"].(bool)
			if !ok || !valid {
				t.Errorf("expected valid=true for dialect %s, got %v", dialect, data["valid"])
			}
			if data["dialect"] != dialect {
				t.Errorf("expected dialect=%s, got %v", dialect, data["dialect"])
			}
		})
	}
}

func TestHandleParseSQL_CTE(t *testing.T) {
	ctx := context.Background()