A Static-Based Approach to Detect SQL Semantic Bugs Dataset

The dataset used for our study: A Static-Based Approach to Detect SQL Semantic Bugs. This dataset contains more than 172,000 queries extracted from StackOverflow posts. It was built for analysing the prevalence of semantic bugs in SQL queries. For more information about our study and tools see our GitHub repository: https://github.com/SERG-Delft/sql-bug-finder Description of included files: sql_db.png: database ER diagram homedb_queries.sql: contains queries extracted from StackOverflow posts homedb_questions.sql: contains SQL related question posts extracted from StackOverflow homedb_answers.sql: contains the answers to SQL related question posts extracted from StackOverflow homedb_bugs.sql: contains queries with semantic bugs extracted from StackOverflow posts homedb_owners.sql: contains data related to the owners (users) of SQL StackOverflow posts homedb_pages.sql: artifact from book-keeping script, tracking the StackOverflow pages from which SQL queries were extracted (SQL tagged pages, ordered by votes in descending order)