{"id":"https://openalex.org/W4406548522","doi":"https://doi.org/10.48550/arxiv.2501.09310","title":"A Study of In-Context-Learning-Based Text-to-SQL Errors","display_name":"A Study of In-Context-Learning-Based Text-to-SQL Errors","publication_year":2025,"publication_date":"2025-01-16","ids":{"openalex":"https://openalex.org/W4406548522","doi":"https://doi.org/10.48550/arxiv.2501.09310"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2501.09310","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2501.09310","pdf_url":"https://arxiv.org/pdf/2501.09310","source":{"id":"https://openalex.org/S4393918464","display_name":"ArXiv.org","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2501.09310","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5086714131","display_name":"Jiawei Shen","orcid":"https://orcid.org/0000-0001-7048-6665"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Shen, Jiawei","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016446062","display_name":"Chengcheng Wan","orcid":"https://orcid.org/0000-0001-9162-9688"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wan, Chengcheng","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Qiao, Ruoyi","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Qiao, Ruoyi","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050562950","display_name":"Jiazhen Zou","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zou, Jiazhen","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100597609","display_name":"Hang Xu","orcid":"https://orcid.org/0009-0009-4669-6078"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xu, Hang","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065385833","display_name":"Yuchen Shao","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Shao, Yuchen","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086946220","display_name":"Yueling Zhang","orcid":"https://orcid.org/0000-0002-0510-8307"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhang, Yueling","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5107246472","display_name":"Weikai Miao","orcid":"https://orcid.org/0009-0006-2038-439X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Miao, Weikai","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5054490662","display_name":"Geguang Pu","orcid":"https://orcid.org/0000-0001-9750-8334"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Pu, Geguang","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":9,"corresponding_author_ids":["https://openalex.org/A5086714131"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.7148000001907349,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.7148000001907349,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.7010999917984009,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.6510000228881836,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6870889663696289},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.6623736619949341},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6214002370834351},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.36494773626327515},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3513021767139435},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3449190855026245},{"id":"https://openalex.org/keywords/history","display_name":"History","score":0.08072227239608765}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6870889663696289},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.6623736619949341},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6214002370834351},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.36494773626327515},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3513021767139435},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3449190855026245},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.08072227239608765},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2501.09310","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2501.09310","pdf_url":"https://arxiv.org/pdf/2501.09310","source":{"id":"https://openalex.org/S4393918464","display_name":"ArXiv.org","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2501.09310","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2501.09310","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2501.09310","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2501.09310","pdf_url":"https://arxiv.org/pdf/2501.09310","source":{"id":"https://openalex.org/S4393918464","display_name":"ArXiv.org","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W4406548522.pdf"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2003932708","https://openalex.org/W1967424056","https://openalex.org/W2284877871","https://openalex.org/W2138102289","https://openalex.org/W868043274","https://openalex.org/W2513523087","https://openalex.org/W1187916458","https://openalex.org/W2373861055","https://openalex.org/W3204019825","https://openalex.org/W4320802139"],"abstract_inverted_index":{"Large":[0],"language":[1,20,25],"models":[2],"(LLMs)":[3],"have":[4,90],"been":[5],"adopted":[6],"to":[7,17],"perform":[8],"text-to-SQL":[9,49,71,113],"tasks,":[10],"utilizing":[11],"their":[12],"in-context":[13],"learning":[14],"(ICL)":[15],"capability":[16],"translate":[18],"natural":[19],"questions":[21],"into":[22],"structured":[23],"query":[24],"(SQL).":[26],"However,":[27],"such":[28],"a":[29,111],"technique":[30],"faces":[31],"correctness":[32,92],"problems":[33],"and":[34,64,75,116,135],"requires":[35],"efficient":[36],"repairing":[37,60,88,117,128],"solutions.":[38],"In":[39],"this":[40],"paper,":[41],"we":[42,108],"conduct":[43],"the":[44,95,106],"first":[45],"comprehensive":[46],"study":[47,52],"of":[48,80,97],"errors.":[50],"Our":[51],"covers":[53],"four":[54],"representative":[55],"ICL-based":[56],"techniques,":[57],"five":[58],"basic":[59],"methods,":[61],"two":[62,65],"benchmarks,":[63],"LLM":[66],"settings.":[67],"We":[68,83],"find":[69,85],"that":[70,86,122],"errors":[72],"are":[73],"widespread":[74],"summarize":[76],"29":[77],"error":[78,114],"types":[79],"7":[81],"categories.":[82],"also":[84],"existing":[87,125],"attempts":[89],"limited":[91],"improvement":[93],"at":[94],"cost":[96],"high":[98],"computational":[99],"overhead":[100],"with":[101,132],"many":[102],"mis-repairs.":[103],"Based":[104],"on":[105],"findings,":[107],"propose":[109],"MapleRepair,":[110],"novel":[112],"detection":[115],"framework.":[118],"The":[119],"evaluation":[120],"demonstrates":[121],"MapleRepair":[123],"outperforms":[124],"solutions":[126],"by":[127],"13.8%":[129],"more":[130],"queries":[131],"neglectable":[133],"mis-repairs":[134],"67.4%":[136],"less":[137],"overhead.":[138]},"counts_by_year":[],"updated_date":"2026-04-21T08:09:41.155169","created_date":"2025-10-10T00:00:00"}