{"id":"https://openalex.org/W7203633286","doi":"https://doi.org/10.5281/zenodo.21973271","title":"Type Coercion Gaps in Distributed SQL Engines: A Case Study of VARCHAR-to-INTERVAL Casting in Trino","display_name":"Type Coercion Gaps in Distributed SQL Engines: A Case Study of VARCHAR-to-INTERVAL Casting in Trino","publication_year":2026,"publication_date":"2026-08-17","ids":{"openalex":"https://openalex.org/W7203633286","doi":"https://doi.org/10.5281/zenodo.21973271"},"language":"en","primary_location":{"id":"doi:10.5281/zenodo.21973271","doi":"https://doi.org/10.5281/zenodo.21973271","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.21973271","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"volume":null,"type":"preprint","is_traditional":true,"indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.5281/zenodo.21973271","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5140926696","display_name":"Haseeb Mohammed Afsar","orcid":"https://orcid.org/0009-0000-4038-1272","observed_orcids":["https://orcid.org/0009-0000-4038-1272"]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Afsar, Haseeb","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0009-0000-4038-1272","affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5140926696"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9883000254631042,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9883000254631042,"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/T10126","display_name":"Logic, programming, and type systems","score":0.007499999832361937,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T10260","display_name":"Software Engineering Research","score":0.0010000000474974513,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/type-coercion","display_name":"type coercion","score":0.9679999947547913},{"id":"https://openalex.org/keywords/trino","display_name":"Trino","score":0.7630000114440918},{"id":"https://openalex.org/keywords/interchange-format","display_name":"interchange format","score":0.6399999856948853},{"id":"https://openalex.org/keywords/continuous-integration","display_name":"continuous integration","score":0.5040000081062317}],"concepts":[{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.7305999994277954},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7293999791145325},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.5730000138282776},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5720000267028809},{"id":"https://openalex.org/C44779574","wikidata":"https://www.wikidata.org/wiki/Q736866","display_name":"Type safety","level":2,"score":0.47839999198913574},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.45910000801086426},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4146000146865845},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.38960000872612},{"id":"https://openalex.org/C2777299769","wikidata":"https://www.wikidata.org/wiki/Q3707858","display_name":"Type (biology)","level":2,"score":0.38519999384880066},{"id":"https://openalex.org/C129131279","wikidata":"https://www.wikidata.org/wiki/Q1931259","display_name":"Predicative expression","level":2,"score":0.37439998984336853},{"id":"https://openalex.org/C2777188754","wikidata":"https://www.wikidata.org/wiki/Q5140822","display_name":"Coercion (linguistics)","level":2,"score":0.3529999852180481},{"id":"https://openalex.org/C186362262","wikidata":"https://www.wikidata.org/wiki/Q732089","display_name":"Eiffel","level":3,"score":0.35109999775886536},{"id":"https://openalex.org/C2780882242","wikidata":"https://www.wikidata.org/wiki/Q14235582","display_name":"Literal (mathematical logic)","level":2,"score":0.3472000062465668},{"id":"https://openalex.org/C2778514511","wikidata":"https://www.wikidata.org/wiki/Q1374194","display_name":"Programmer","level":2,"score":0.34630000591278076},{"id":"https://openalex.org/C2778067643","wikidata":"https://www.wikidata.org/wiki/Q166507","display_name":"Interval (graph theory)","level":2,"score":0.3447999954223633},{"id":"https://openalex.org/C96865113","wikidata":"https://www.wikidata.org/wiki/Q2946816","display_name":"Certificate","level":2,"score":0.34279999136924744},{"id":"https://openalex.org/C138958017","wikidata":"https://www.wikidata.org/wiki/Q190087","display_name":"Data type","level":2,"score":0.3239000141620636},{"id":"https://openalex.org/C198370458","wikidata":"https://www.wikidata.org/wiki/Q586459","display_name":"Type inference","level":3,"score":0.29809999465942383},{"id":"https://openalex.org/C105888452","wikidata":"https://www.wikidata.org/wiki/Q7565148","display_name":"Source document","level":2,"score":0.28850001096725464},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.28139999508857727},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.27480000257492065},{"id":"https://openalex.org/C175309249","wikidata":"https://www.wikidata.org/wiki/Q725864","display_name":"Pipeline transport","level":2,"score":0.266400009393692},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.2635999917984009},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.2549999952316284}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.5281/zenodo.21973271","doi":"https://doi.org/10.5281/zenodo.21973271","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.21973271","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},{"id":"doi:10.5281/zenodo.21973272","doi":"https://doi.org/10.5281/zenodo.21973272","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.21973272","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"doi:10.5281/zenodo.21973271","doi":"https://doi.org/10.5281/zenodo.21973271","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.21973271","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4409970707","https://openalex.org/W7171507822","https://openalex.org/W6903964017","https://openalex.org/W3133836318","https://openalex.org/W3133777256","https://openalex.org/W7202030007","https://openalex.org/W7164893724","https://openalex.org/W1986050705","https://openalex.org/W6941285122","https://openalex.org/W93333565"],"abstract_inverted_index":{"Distributed":[0],"SQL":[1],"query":[2,147],"engines":[3],"expose":[4],"large,":[5],"federated":[6],"type":[7,23,142],"systems":[8,143],"that":[9,95,110,131],"grow":[10],"incrementally":[11],"over":[12],"years.":[13],"This":[14,35],"makes":[15],"it":[16],"easy":[17],"for":[18,66,138],"individual":[19],"coercions":[20],"in":[21,41,61],"the":[22,30,43,70,81,87,103,141,159],"lattice":[24],"to":[25],"go":[26],"unimplemented":[27],"long":[28],"after":[29],"surrounding":[31],"system":[32],"has":[33],"matured.":[34],"paper":[36],"documents":[37],"a":[38,52,57,108,119,123,154],"concrete":[39],"instance":[40],"Trino:":[42],"absence":[44],"of":[45,107,144],"CAST(VARCHAR":[46],"AS":[47],"INTERVAL":[48,74],"DAY":[49],"TO":[50],"SECOND),":[51],"gap":[53],"first":[54],"reported":[55],"by":[56,127],"Trino":[58,160],"project":[59,161],"founder":[60],"2020":[62],"and":[63,78,105,122],"left":[64],"unresolved":[65],"six":[67],"years":[68],"despite":[69],"reverse":[71],"operation":[72],"(parsing":[73],"literals)":[75],"being":[76],"present":[77],"battle-tested":[79],"since":[80],"engine's":[82],"earliest":[83],"releases.":[84],"We":[85,133],"describe":[86],"gap,":[88],"its":[89],"practical":[90,136],"impact":[91],"on":[92],"data":[93],"pipelines":[94],"move":[96],"interval":[97],"values":[98],"through":[99],"text-based":[100],"interchange":[101],"formats,":[102],"design":[104],"implementation":[106,150],"fix":[109],"reuses":[111],"Trino's":[112],"existing":[113],"literal":[114],"parser":[115],"rather":[116],"than":[117],"introducing":[118],"parallel":[120],"one,":[121],"correctness":[124],"lesson":[125],"surfaced":[126],"continuous":[128],"integration":[129],"during":[130],"work.":[132],"distill":[134],"three":[135],"guidelines":[137],"engineers":[139],"extending":[140],"mature":[145],"distributed":[146],"engines.":[148],"The":[149],"is":[151],"available":[152],"as":[153],"public":[155],"pull":[156],"request":[157],"against":[158],"(github.com/trinodb/trino/pull/30737),":[162],"addressing":[163],"issue":[164],"#4697.":[165]},"counts_by_year":[],"updated_date":"2026-10-07T09:51:55.459714","created_date":"2026-08-18T00:00:00"}