{"id":"W4404181435","doi":"10.14778/3685800.3685894","title":"Demonstration of the VeriEQL Equivalence Checker for Complex SQL Queries","year":2024,"lang":"en","type":"article","venue":"Proceedings of the VLDB Endowment","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":true,"ca_institutions":"Simon Fraser University","funders":"","keywords":"Programming language; Computer science; Equivalence (formal languages); SQL; SQL/PSM; Database; Stored procedure; Information retrieval; Query by Example; Mathematics; Discrete mathematics; Web search query","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0002685804,0.0001156749,0.0001514379,0.00003068921,0.0001106586,0.00005174616,0.0006429987,0.00002637685,0.000004150536],"category_scores_gemma":[0.00006518869,0.00006380786,0.0001276012,0.0002914683,0.0001687725,0.0005564349,0.0004232334,0.00006816746,0.000001266221],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00003907612,"about_ca_system_score_gemma":0.00005676467,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0000263266,"about_ca_topic_score_gemma":0.000004879708,"domain_scores_codex":[0.9989875,0.000005882321,0.000300411,0.0002343707,0.000303956,0.0001678786],"domain_scores_gemma":[0.9993716,0.00003865616,0.0001849396,0.0002198788,0.0001607825,0.00002411839],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"bench_or_experimental","study_design_scores_codex":[0.000008390122,0.0000184367,0.0002879103,0.0004338779,0.00002128277,6.441016e-8,0.0007947243,0.0000141442,0.1230991,0.8713035,0.002116105,0.001902471],"study_design_scores_gemma":[0.0002942308,0.0001472094,0.001893094,0.0008149405,0.00003765981,0.00002303442,0.0006186913,0.01374812,0.8686001,0.01249966,0.1011062,0.0002170314],"study_design_candidate":"bench_or_experimental","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.1464201,0.002531834,0.8169294,0.01056995,0.00410506,0.004467458,0.0003750362,0.000416663,0.01418448],"genre_scores_gemma":[0.947389,0.0000283088,0.05182381,0.00007071934,0.00006626411,0.0001114291,0.000001273724,0.000009390393,0.0004997703],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.8588039,"threshold_uncertainty_score":0.2602009,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02881900024655679,"score_gpt":0.2677268580327518,"score_spread":0.238907857786195,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}