{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,19]],"date-time":"2026-05-19T07:13:19Z","timestamp":1779174799611,"version":"3.51.4"},"publisher-location":"New York, NY, USA","reference-count":51,"publisher":"ACM","license":[{"start":{"date-parts":[[2024,9,11]],"date-time":"2024-09-11T00:00:00Z","timestamp":1726012800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"name":"NSFC","award":["62272400"],"award-info":[{"award-number":["62272400"]}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2024,9,11]]},"DOI":"10.1145\/3650212.3680317","type":"proceedings-article","created":{"date-parts":[[2024,9,11]],"date-time":"2024-09-11T11:44:25Z","timestamp":1726055065000},"page":"743-754","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":3,"title":["SQLess: Dialect-Agnostic SQL Query Simplification"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0009-0004-9895-8360","authenticated-orcid":false,"given":"Li","family":"Lin","sequence":"first","affiliation":[{"name":"Xiamen Key Laboratory of Intelligent Storage and Computing,  School of Informatics,  Xiamen University, Xiamen, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0004-4158-3326","authenticated-orcid":false,"given":"Zongyin","family":"Hao","sequence":"additional","affiliation":[{"name":"Xiamen Key Laboratory of Intelligent Storage and Computing,  School of Informatics,  Xiamen University, Xiamen, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-0617-5322","authenticated-orcid":false,"given":"Chengpeng","family":"Wang","sequence":"additional","affiliation":[{"name":"Hong Kong University of Science and Technology, Hong Kong, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0004-7628-2208","authenticated-orcid":false,"given":"Zhuangda","family":"Wang","sequence":"additional","affiliation":[{"name":"Xiamen Key Laboratory of Intelligent Storage and Computing,  School of Informatics,  Xiamen University, Xiamen, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-4648-3795","authenticated-orcid":false,"given":"Rongxin","family":"Wu","sequence":"additional","affiliation":[{"name":"Xiamen Key Laboratory of Intelligent Storage and Computing,  School of Informatics,  Xiamen University, Xiamen, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-8633-6036","authenticated-orcid":false,"given":"Gang","family":"Fan","sequence":"additional","affiliation":[{"name":"Ant Group, Shenzhen, China"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2024,9,11]]},"reference":[{"key":"e_1_3_2_1_1_1","volume-title":"Ullman","author":"Aho Alfred V.","year":"2006","unstructured":"Alfred V. Aho, Monica S. Lam, Ravi Sethi, and Jeffrey D. Ullman. 2006. Compilers: Principles, Techniques, and Tools (2nd ed.). Pearson Education."},{"key":"e_1_3_2_1_2_1","volume-title":"The SQL Standard - ISO\/IEC 9075:2023 (ANSI X3.135). https:\/\/blog.ansi.org\/sql-standard-iso-iec-9075-2023-ansi-x3-135\/ [Online","author":"ANSI.","year":"2023","unstructured":"ANSI. 2023. The SQL Standard - ISO\/IEC 9075:2023 (ANSI X3.135). https:\/\/blog.ansi.org\/sql-standard-iso-iec-9075-2023-ansi-x3-135\/ [Online; accessed 12-Dec-2023]"},{"key":"e_1_3_2_1_3_1","volume-title":"Proceedings of the 33rd International Conference on Software Engineering. 1\u201310","author":"Arcuri Andrea","unstructured":"Andrea Arcuri and Lionel C. Briand. 2011. A practical guide for using statistical tests to assess randomized algorithms in software engineering. In Proceedings of the 33rd International Conference on Software Engineering. 1\u201310."},{"key":"e_1_3_2_1_4_1","unstructured":"J Asplund. 2011. Data Science revealed: Data-driven glimpse into the burgeoning new field."},{"key":"e_1_3_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247520"},{"key":"e_1_3_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/3551349.3560431"},{"key":"e_1_3_2_1_7_1","volume-title":"Pinolo: Detecting Logical Bugs in Database Management Systems with Approximate Query Synthesis. In 2023 USENIX Annual Technical Conference. 345\u2013358","author":"Hao Zongyin","year":"2023","unstructured":"Zongyin Hao, Quanfeng Huang, Chengpeng Wang, Jianfeng Wang, Yushan Zhang, Rongxin Wu, and Charles Zhang. 2023. Pinolo: Detecting Logical Bugs in Database Management Systems with Approximate Query Synthesis. In 2023 USENIX Annual Technical Conference. 345\u2013358."},{"key":"e_1_3_2_1_8_1","unstructured":"IEC ISO and N IEC. 2017. ISO\/IEC. IEEE International Standard-Systems and software engineering\u2013Vocabulary 1\u2013541."},{"key":"e_1_3_2_1_9_1","volume-title":"Proceedings of USENIX Security Symposium. 4949\u20134965","author":"Jiang Zu-Ming","year":"2023","unstructured":"Zu-Ming Jiang, Jia-Ju Bai, and Zhendong Su. 2023. DynSQL: Stateful fuzzing for database management systems with complex and valid SQL query generation. In Proceedings of USENIX Security Symposium. 4949\u20134965."},{"key":"e_1_3_2_1_10_1","volume-title":"https:\/\/jsqlparser.github.io\/ [Online","year":"2023","unstructured":"JSQlParser. 2023. JSqlParser. https:\/\/jsqlparser.github.io\/ [Online; accessed 23-Nov-2023]"},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.14778\/3357377.3357382"},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1109\/ISSRE.2005.28"},{"key":"e_1_3_2_1_13_1","volume-title":"31st USENIX Security Symposium. 4309\u20134326","author":"Liang Yu","year":"2022","unstructured":"Yu Liang, Song Liu, and Hong Hu. 2022. Detecting Logical Bugs of $DBMS$ with Coverage-based Guidance. In 31st USENIX Security Symposium. 4309\u20134326."},{"key":"e_1_3_2_1_14_1","volume-title":"libpg_query: PostgreSQL Parser Library. https:\/\/github.com\/pganalyze\/libpg_query [Online","year":"2023","unstructured":"libpgquery. 2023. libpg_query: PostgreSQL Parser Library. https:\/\/github.com\/pganalyze\/libpg_query [Online; accessed 23-Nov-2023]"},{"key":"e_1_3_2_1_15_1","volume-title":"https:\/\/mariadb.org\/ [Online","author":"Database Mariadb","year":"2023","unstructured":"Mariadb. 2023. Mariadb Database. https:\/\/mariadb.org\/ [Online; accessed Dec-2023]"},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/1134285.1134307"},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376668"},{"key":"e_1_3_2_1_18_1","volume-title":"MySQL Bug Reporting Guidelines. https:\/\/bugs.mysql.com\/ [Online","author":"SQL.","year":"2023","unstructured":"MySQL. 2023. MySQL Bug Reporting Guidelines. https:\/\/bugs.mysql.com\/ [Online; accessed Dec-2023]"},{"key":"e_1_3_2_1_19_1","volume-title":"https:\/\/www.mysql.com\/ [Online","author":"Database SQL.","year":"2023","unstructured":"MySQL. 2023. MySQL Database. https:\/\/www.mysql.com\/ [Online; accessed Dec-2023]"},{"key":"e_1_3_2_1_20_1","volume-title":"https:\/\/www.oceanbase.com\/ [Online","author":"Database OceanBase","year":"2023","unstructured":"OceanBase. 2023. OceanBase Database. https:\/\/www.oceanbase.com\/ [Online; accessed Dec-2023]"},{"key":"e_1_3_2_1_21_1","volume-title":"Proceedings of the 2006 international workshop on Dynamic systems analysis. 3\u201310","author":"Orso Alessandro","year":"2006","unstructured":"Alessandro Orso, Shrinivas Joshi, Martin Burger, and Andreas Zeller. 2006. Isolating relevant component interactions with JINSI. In Proceedings of the 2006 international workshop on Dynamic systems analysis. 3\u201310."},{"key":"e_1_3_2_1_22_1","unstructured":"Terence Parr. 2013. The Definitive ANTLR 4 Reference. Pragmatic Bookshelf."},{"key":"e_1_3_2_1_23_1","volume-title":"Parser - A MySQL Compatible SQL Parser. https:\/\/github.com\/pingcap\/tidb\/tree\/master\/parser [Online","year":"2023","unstructured":"pincap. 2023. Parser - A MySQL Compatible SQL Parser. https:\/\/github.com\/pingcap\/tidb\/tree\/master\/parser [Online; accessed January-2023]"},{"key":"e_1_3_2_1_24_1","volume-title":"TiDB Parser: The SQL Parser for TiDB. https:\/\/github.com\/pingcap\/tidb\/tree\/master\/parser [Online","year":"2023","unstructured":"pincap. 2023. TiDB Parser: The SQL Parser for TiDB. https:\/\/github.com\/pingcap\/tidb\/tree\/master\/parser [Online; accessed Nov-2023]"},{"key":"e_1_3_2_1_25_1","volume-title":"PostgreSQL Bug Reporting Guidelines. https:\/\/www.postgresql.org\/list\/pgsql-bugs\/ [Online","author":"SQL.","year":"2023","unstructured":"PostgreSQL. 2023. PostgreSQL Bug Reporting Guidelines. https:\/\/www.postgresql.org\/list\/pgsql-bugs\/ [Online; accessed Dec-2023]"},{"key":"e_1_3_2_1_26_1","volume-title":"https:\/\/www.postgresql.org\/ [Online","author":"Database SQL.","year":"2023","unstructured":"PostgreSQL. 2023. PostgreSQL Database. https:\/\/www.postgresql.org\/ [Online; accessed Dec-2023]"},{"key":"e_1_3_2_1_27_1","volume-title":"PQuery: Multithreaded SQL Tester \/ Reducer. https:\/\/github.com\/Percona-QA\/pquery [Online","year":"2023","unstructured":"pquery. 2023. PQuery: Multithreaded SQL Tester \/ Reducer. https:\/\/github.com\/Percona-QA\/pquery [Online; accessed 23-Nov-2023]"},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/2254064.2254104"},{"key":"e_1_3_2_1_29_1","volume-title":"https:\/\/github.com\/sqlancer\/sqlancer [Online","author":"Rigger Manuel","year":"2023","unstructured":"Manuel Rigger. 2023. SQLancer. https:\/\/github.com\/sqlancer\/sqlancer [Online; accessed 23-Nov-2023]"},{"key":"e_1_3_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/3428279"},{"key":"e_1_3_2_1_31_1","first-page":"618","article-title":"Massive stochastic testing of SQL","volume":"98","author":"Slutz Donald R","year":"1998","unstructured":"Donald R Slutz. 1998. Massive stochastic testing of SQL. In VLDB. 98, 618\u2013622.","journal-title":"VLDB."},{"key":"e_1_3_2_1_32_1","volume-title":"https:\/\/sqlite.org\/ [Online","author":"Database Lite","year":"2023","unstructured":"SQLite. 2023. SQLite Database. https:\/\/sqlite.org\/ [Online; accessed Dec-2023]"},{"key":"e_1_3_2_1_33_1","volume-title":"phpMyAdmin SQL Parser. https:\/\/github.com\/phpmyadmin\/sql-parser [Online","year":"2023","unstructured":"sqlparser. 2023. phpMyAdmin SQL Parser. https:\/\/github.com\/phpmyadmin\/sql-parser [Online; accessed Nov-2023]"},{"key":"e_1_3_2_1_34_1","volume-title":"https:\/\/www.sqlparser.com\/ [Online","year":"2023","unstructured":"SQLParser. 2023. SQLParser. https:\/\/www.sqlparser.com\/ [Online; accessed Nov-2023]"},{"key":"e_1_3_2_1_35_1","volume-title":"https:\/\/github.com\/anse1\/sqlsmith [Online","year":"2023","unstructured":"SQLSmith. 2023. SQLSmith. https:\/\/github.com\/anse1\/sqlsmith [Online; accessed June-2023]"},{"key":"e_1_3_2_1_36_1","volume-title":"https:\/\/www.ANTLR.org\/ [Online","author":"Team ANTLR","year":"2023","unstructured":"ANTLR Team. 2023. ANTLR (ANother Tool for Language Recognition). https:\/\/www.ANTLR.org\/ [Online; accessed 23-Nov-2023]"},{"key":"e_1_3_2_1_37_1","volume-title":"ANTLR DefaultErrorStrategy Class Documentation. https:\/\/www.ANTLR.org\/api\/Java\/org\/ANTLR\/v4\/runtime\/DefaultErrorStrategy.html [Online","author":"Team ANTLR","year":"2023","unstructured":"ANTLR Team. 2023. ANTLR DefaultErrorStrategy Class Documentation. https:\/\/www.ANTLR.org\/api\/Java\/org\/ANTLR\/v4\/runtime\/DefaultErrorStrategy.html [Online; accessed 23-Nov-2023]"},{"key":"e_1_3_2_1_38_1","unstructured":"SQLess Team. 2023. SQLess. https:\/\/github.com\/SQLess\/AdaptSQLess"},{"key":"e_1_3_2_1_39_1","unstructured":"SQLess Team. 2023. SQLessBugReports. https:\/\/github.com\/SQLess\/SQLess_Bugreports"},{"key":"e_1_3_2_1_40_1","unstructured":"SQLess Team. 2023. SQLessExample. https:\/\/github.com\/SQLess\/Examples\/blob\/main\/README.md"},{"key":"e_1_3_2_1_41_1","volume-title":"SQLite Bug Reporting Guidelines. https:\/\/www.chiark.greenend.org.uk\/ sgtatham\/bugs.html [Online","author":"Team Lite","year":"2023","unstructured":"SQLite Team. 2023. SQLite Bug Reporting Guidelines. https:\/\/www.chiark.greenend.org.uk\/ sgtatham\/bugs.html [Online; accessed Dec-2023]"},{"key":"e_1_3_2_1_42_1","volume-title":"ANTLR Grammars Repository. https:\/\/github.com\/ANTLR\/grammars-v4 [Online","author":"The ANTLR Organization","year":"2023","unstructured":"The ANTLR Organization. 2023. ANTLR Grammars Repository. https:\/\/github.com\/ANTLR\/grammars-v4 [Online; accessed 23-Nov-2023]"},{"key":"e_1_3_2_1_43_1","volume-title":"https:\/\/www.pingcap.com\/tidb\/ [Online","author":"Database DB.","year":"2023","unstructured":"TiDB. 2023. TiDB Database. https:\/\/www.pingcap.com\/tidb\/ [Online; accessed Dec-2023]"},{"key":"e_1_3_2_1_44_1","volume-title":"2013 8th International Conference on Communications and Networking in China. 426\u2013431","author":"Wang Jiajie","year":"2013","unstructured":"Jiajie Wang, Puhan Zhang, Lei Zhang, Haowen Zhu, and Xiaojun Ye. 2013. A model-based fuzzing approach for DBMS. In 2013 8th International Conference on Communications and Networking in China. 426\u2013431."},{"key":"e_1_3_2_1_45_1","volume-title":"2021 IEEE\/ACM 43rd International Conference on Software Engineering: Software Engineering in Practice. 328\u2013337","author":"Wang Mingzhe","year":"2021","unstructured":"Mingzhe Wang, Zhiyong Wu, Xinyi Xu, Jie Liang, Chijin Zhou, Huafeng Zhang, and Yu Jiang. 2021. Industry practice of coverage-guided enterprise-level DBMS fuzzing. In 2021 IEEE\/ACM 43rd International Conference on Software Engineering: Software Engineering in Practice. 328\u2013337."},{"key":"e_1_3_2_1_46_1","volume-title":"Comparison of Relational Database Management Systems. https:\/\/en.wikipedia.org\/wiki\/Comparison_of_relational_database_management_systems [Online","year":"2023","unstructured":"wiki. 2023. Comparison of Relational Database Management Systems. https:\/\/en.wikipedia.org\/wiki\/Comparison_of_relational_database_management_systems [Online; accessed Sep-2023]"},{"key":"e_1_3_2_1_47_1","volume-title":"SQL Dialects Reference\/Introduction. https:\/\/en.wikibooks.org\/wiki\/SQL_Dialects_Reference\/Introduction [Online","year":"2023","unstructured":"wikibooks. 2023. SQL Dialects Reference\/Introduction. https:\/\/en.wikibooks.org\/wiki\/SQL_Dialects_Reference\/Introduction [Online; accessed Nov-2023]"},{"key":"e_1_3_2_1_48_1","unstructured":"Michal Zalewski. 2021. American Fuzzy Lop (2.52b). http:\/\/lcamtuf.coredump.cx\/afl Accessed: June 2023"},{"key":"e_1_3_2_1_49_1","volume-title":"my program worked. Today, it does not. Why? ACM SIGSOFT Software engineering notes, 24, 6","author":"Zeller Andreas","year":"1999","unstructured":"Andreas Zeller. 1999. Yesterday, my program worked. Today, it does not. Why? ACM SIGSOFT Software engineering notes, 24, 6 (1999), 253\u2013267."},{"key":"e_1_3_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.1109\/32.988498"},{"key":"e_1_3_2_1_51_1","doi-asserted-by":"publisher","DOI":"10.1145\/3372297.3417260"}],"event":{"name":"ISSTA '24: 33rd ACM SIGSOFT International Symposium on Software Testing and Analysis","location":"Vienna Austria","acronym":"ISSTA '24","sponsor":["SIGSOFT ACM Special Interest Group on Software Engineering","AITO"]},"container-title":["Proceedings of the 33rd ACM SIGSOFT International Symposium on Software Testing and Analysis"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3650212.3680317","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3650212.3680317","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T22:50:07Z","timestamp":1750287007000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3650212.3680317"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,9,11]]},"references-count":51,"alternative-id":["10.1145\/3650212.3680317","10.1145\/3650212"],"URL":"https:\/\/doi.org\/10.1145\/3650212.3680317","relation":{},"subject":[],"published":{"date-parts":[[2024,9,11]]},"assertion":[{"value":"2024-09-11","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}