CSC-SQL: Corrective Self-Consistency in Text-to-SQL via Reinforcement Learning