Li Lin's HomePage

Ph.D. student @Zhejiang University
Supervised by Prof. Lingfeng Bao
Intelligent Computing and Software Center
Department of Computer Science and Technology

E-Mail: linli1210@zju.edu.cn

Research Interests

Software Security, Software Engineering, Database and Large Language Models.
Currently, my research focuses on (1) Database Testing: enhancing the reliability and security of database systems using advanced software testing techniques, particularly addressing testing in multi-dialect environments and developing efficient test oracles; (2) Efficient Text-to-SQL Systems: building efficient Text-to-SQL systems focused on generating high-performance and low-hallucination SQL queries; (3) Security in Open Source Software Ecosystems: investigating security issues in open-source software ecosystems, with a focus on improving the security of libraries and reducing vulnerabilities; and (4) Security of LLMs- and Agent-based Systems: focusing on LLM-based applications/agent security such as jailbreak and prompt injection.

Education

2022-09 ~ 2025.06
Master's degree in Computer Science and Technology, Xiamen University
  • Supervised by Prof. Rongxin Wu，System and Software Security Group
    • 2018-09 ~ 2022-06
    Bachelor's degree in Computer Science and Technology, Xiamen University

    Publications

    1. Validating LLM-Generated SQL Queries Through Metamorphic Prompting
      Li Lin, Qinglin Zhu, Jintai Hong, Chong Wang, Yang Liu and Rongxin Wu
      FSE 2026: The 34th ACM International Conference on the Foundations of Software Engineering, July, 2026.
      [PDF | GitHub]
    2. ReachCheck: Compositional Library-Aware Call Graph Reachability Analysis in the IDEs
      Chao Wang, Li Lin, Chengpeng Wang, Jiafeng Huang, Congxia Wu and Rongxin Wu
      TOSEM 2025: In ACM Transactions on Software Engineering and Methodology, Accepted.
      [PDF]
    3. DLBENCH: A Comprehensive Benchmark for SQL Translation with Large Language Models
      Li Lin, Hongqiao Chen, Qinglin Zhu, Liehang Chen, Linlong Tang and Rongxin Wu
      ASE 2025: The 40th IEEE/ACM International Conference on Automated Software Engineering, November, 2025.
      [PDF | Leaderboard]
    4. QTRAN: Extending Metamorphic-Oracle based Logical Bug Detection Techniques for Multiple-DBMS Dialect Support
      Li Lin, Qinglin Zhu, Hongqiao Chen, Zhuangda Wang, Rongxin Wu and Xiaoheng Xie
      ISSTA 2025: The ACM SIGSOFT International Symposium on Software Testing and Analysis, June, 2025.
      [PDF | GitHub]
    5. PATEN: Identifying Unpatched Third-Party APIs via Fine-grained Patch-enhanced AST-level Signature
      Li Lin, Jialin Ye, Chao Wang, and Rongxin Wu
      TSE 2025: IEEE Transactions on Software Engineering, vol. 51, no. 4, pp. 990-1006 , Apr. 2025.
      [PDF | GitHub]
    6. SQLess: Dialect-Agnostic SQL Query Simplification
      Li Lin, Zongyin Hao, Chengpeng Wang, Zhuangda Wang, Rongxin Wu, Gang Fan.
      ISSTA 2024: The ACM SIGSOFT International Symposium on Software Testing and Analysis, September, 2024
      [PDF | GitHub]
      7. # means equal contribution. * means corresponding author.

    Patents

    Patent No: CN119807057A
    Large Language Model-Based Method, Apparatus, and Computer-Readable Medium for Database Test Case Expansion.
    Patent No: CN118035274A
    The method and device for processing SQL statements.
    Patent No: CN115016840B
    Method and Device for Dependency Conflict Resolution Based on Call Graph
    Patent No: CN114780109B
    Method for automated parsing and installation of third-party library dependencies in Python projects.

    Academic Service

    Journal Reviewer: IEEE Transactions on Information Forensics & Security (TIFS) 2025
    Journal Reviewer: IEEE Transactions on Software Engineering (TSE) 2025

    Industry Experience

    Ant Group, Shenzhen, China (May 2024 - Aug 2024): Research Intern, working on LLM-aided bug detection.

    Talks

  • DLBENCH: A Comprehensive Benchmark for SQL Translation with Large Language Models (conference talk), hosted by ASE25, Souel, Novermber 2025
  • QTRAN: Extending Metamorphic-Oracle based Logical Bug Detection Techniques for Multiple-DBMS Dialect Support (conference talk), hosted by Issta25, Trondheim, June 2025
  • Automating and Enhancing DBMS Testing: From SQL Generation and Transformation to Simplification (invited talk), hosted by Cyber Security Research Center, Nanyang Technological University, Singapore, Jan 2025
  • SQLess: Dialect-agnostic SQL Query Simplification (invited talk), hosted by Ant Technology Research Institute, Online (Public), Nov 2024
  • SQLess: Dialect-agnostic SQL Query Simplification (conference talk), hosted by Issta24, Vienna, Sep 2024
  • SQLess: Dialect-agnostic SQL Query Simplification (invited talk), hosted by AntGroup, ChengDu, Jun 2024
  • Bug detection in DBMS (invited talk), hosted by AntGroup, ShenZhen, May 2024

    • Honors

    2025-06
    Outstanding Master’s Graduate of Xiamen University
    2025-06
    Award for Outstanding Master’s Thesis
    2024-12
    Outstanding Paper of the 2024 Annual Academic Conference of the Fujian Computer Society
    2024
    National Scholarship
    2021-2022
    Outstanding Academic Scholarship, Department of Computer Science and Technology, Xiamen University
    2019-2020
    Outstanding Academic Scholarship, Department of Computer Science and Technology, Xiamen University

    --- Updated in 14 August 2025 ---