SQLancer

SQLancer allows finding logic bugs in DBMS and is available at

[SQLancer @sqlancer_dbms]

We are very excited to be working with two fantastic GSoC contributors this year: Yutan Yang (@tarotaroyoung) and Zhenglin Li. Learn more about them at https://t.co/e1Id66yjsk.

[Manuel Rigger @RiggerManuel]

CERT provides a new angle on the difficult problem of identifying relevant performance issues in database systems!

[Jinsheng Ba @JinshengBa]

How can we automatically and efficiently find performance issues in databases? We propose CERT, a novel black-box technique: https://t.co/eaDaCKP1uw. Our key idea is to test them through the lens of cardinality estimation - a more restrictive query should return fewer rows.

[Manuel Rigger @RiggerManuel]

SQLancer now supports @MaterializeInc! Thanks a lot to Dennis Felsing for contributing the code. https://t.co/oPceLmcEt2

[CnosDB @CnosDB]

CnosDB becomes the first cloud-native time-series database that supports SQLancer.

By using SQLancer, CnosDB technical team finds and fixes logical errors in product queries, and helps upstream projects build more stable query engines.
https://t.co/YaFqEmZAem
#TimeSeries #CnosDB

[Manuel Rigger @RiggerManuel]

Can ChatGPT replace database system testing tools like SQLancer or SQLsmith? An interesting read on an experiment by the @StarRocksLabs community. cc @CelerData https://t.co/S94Dd5qhRn

[SQLancer @sqlancer_dbms]

SQLancer was accepted as a GSoC organization! We have created a "gsoc-2023" Slack channel (https://t.co/dqXFxxSWth). See our wiki for further information and for project ideas (https://t.co/zI15GpxZcW).

[SQLancer @sqlancer_dbms]

We are excited that the @CnosDB development team contributed support for testing CnosDB to SQLancer! https://t.co/TjoCvT6G9s

[Jinsheng Ba @JinshengBa]

The paper has been released!! https://t.co/hXQ1uQmcUt

[SQLancer @sqlancer_dbms]

We are considering applying for SQLancer to be included as part of Google Summer of Code (GSoC) initiative and are looking for project ideas as well as mentors. Respond if, e.g., you would like to have your database system tested and/or would like to (co-)mentor a contributor!

[Manuel Rigger @RiggerManuel]

An interesting blog post on @Yugabyte's testing approaches, also mentioning @sqlancer_dbms.
https://t.co/dYgmhrQUjH

[Jinsheng Ba @JinshengBa]

We already integrated our Query Plan Guidance (QPG) approach into SQLancer (see https://t.co/YG1D3H8Cms). Feel free to give it a try! I also gave a talk on QPG at Tsinghua University, hosted by Yu Jiang, earlier today and received insightful questions and feedback!

[SQLancer @sqlancer_dbms]

Fun fact: in terms of the number of commits, @dependabot is the 2nd and 3rd most active committer to SQLancer. Thank you, @dependabot!

[Learn OceanBase @LearnOceanBase]

Wow, great way to run database test! Although the tweet happened last year, still wanna say congrats to @RiggerManuel to create SQLancer.

Impressive tool to automatically test database in order to find logic bugs during implementation!

#oceanbase #sqlancer #database #test

[SQLancer @sqlancer_dbms]

A new efficient test case generation technique that will be part of SQLancer soon!

[Jinsheng Ba @JinshengBa]

Our paper "Testing Database Engines via Query Plan Guidance" was accepted at @ICSEconf (3x accepts!). The core idea is to steer automated testing towards unseen query plans for finding logic bugs. We found over 50 unique, previously unknown bugs. Stay tuned for the preprint!

[SQLancer @sqlancer_dbms]

Thank you ChatGPT. 🥰

[Manuel Rigger @RiggerManuel]

Thanks to @12bytez's contribution, @sqlancer_dbms can now also test @Yugabyte! Great to see that SQLancer already has been useful in locating and preventing bugs (see https://t.co/rKUlNp95kQ).

[Manuel Rigger @RiggerManuel]

Thanks to Yisong Han and @Datafuse_Labs for contributing testing support for Databend to @sqlancer_dbms! Hope it will help with preventing bugs before they reach any users. https://t.co/QSzW0s4lo9

[SQLancer @sqlancer_dbms]

Woohoo! SQLancer has been starred 1,000 times. Thank you everyone for your support! https://t.co/2D2abCMS3E

[RisingWave @RisingWaveLabs]

Missed it? Register today for our upcoming event! We have exciting talks lined up for you.
➡️ Check it out: https://t.co/5FXJFJSrjh
#RisingWave #database #streamprocessing #serverless #opensource #meetups