arXiv:2601.08778cs.AIcs.DB2026-01被引 14

发现主流Text-to-SQL数据集存在超半数标注错误,严重影响模型性能评估和排名。

Pervasive Annotation Errors Break Text-to-SQL Benchmarks and Leaderboards

  • 分析BIRD与Spider 2.0-Snow数据集,发现标注错误率分别达52.8%和62.8%
  • 修正BIRD开发集后,16个开源模型性能波动达-7%至+31%,排名变动最大9位
  • 原始榜单排名与真实表现相关性弱,错误标注严重误导研究方向与部署决策

研究人员提出了多种Text-to-SQL技术以加速数据分析与数据驱动应用开发。社区依赖公开基准测试和排行榜来比较技术并选择最优方案。由于这些基准在问题构建和答案评估中高度依赖人工标注,标注质量至关重要。本文实证研究了两个广泛使用的Text-to-SQL基准BIRD与Spider 2.0-Snow的标注错误率,并对BIRD开发集的部分样本进行修正,评估标注错误对文本到SQL智能体性能及排行榜的影响。专家分析显示,BIRD Mini-Dev与Spider 2.0-Snow的错误率分别为52.8%与62.8%。我们重新评估了来自BIRD排行榜的16个开源智能体在原始与修正后的BIRD Dev子集上的表现,结果显示性能相对变化范围为-7%至+31%,排名变动范围为-9至+9位。进一步分析表明,未修正子集的排名与完整开发集排名高度相关(Spearman's $r_s$=0.85, $p$=3.26e-5),而与修正后子集的相关性较弱(Spearman's $r_s$=0.32, $p$=0.23)。结果表明,标注错误会显著扭曲报告性能与排名,可能误导研究方向或部署选择。代码与数据已开源于https://github.com/uiuc-kang-lab/text_to_sql_benchmarks。

原文摘要 · Abstract (English)

Researchers have proposed numerous text-to-SQL techniques to streamline data analytics and accelerate the development of data-driven applications. To compare these techniques and select the best one for deployment, the community depends on public benchmarks and their leaderboards. Since these benchmarks heavily rely on human annotations during question construction and answer evaluation, the validity of the annotations is crucial. In this paper, we conduct an empirical study that (i) benchmarks annotation error rates for two widely used text-to-SQL benchmarks, BIRD and Spider 2.0-Snow, and (ii) corrects a subset of the BIRD development (Dev) set to measure the impact of annotation errors on text-to-SQL agent performance and leaderboard rankings. Through expert analysis, we show that BIRD Mini-Dev and Spider 2.0-Snow have error rates of 52.8% and 62.8%, respectively. We re-evaluate all 16 open-source agents from the BIRD leaderboard on both the original and the corrected BIRD Dev subsets. We show that performance changes range from -7% to 31% (in relative terms) and rank changes range from $-9$ to $+9$ positions. We further assess whether these impacts generalize to the full BIRD Dev set. We find that the rankings of agents on the uncorrected subset correlate strongly with those on the full Dev set (Spearman's $r_s$=0.85, $p$=3.26e-5), whereas they correlate weakly with those on the corrected subset (Spearman's $r_s$=0.32, $p$=0.23). These findings show that annotation errors can significantly distort reported performance and rankings, potentially misguiding research directions or deployment choices. Our code and data are available at https://github.com/uiuc-kang-lab/text_to_sql_benchmarks.

Text-to-SQL数据标注基准测试模型评估

Thank you to arXiv for use of its open access interoperability. PaperDance 不是 arXiv 官方产品;中文卡片由大模型生成,请以原文为准。