SQL Lint Shape — Union All Dupes
Tiny SAMPLE SQL shape (union-all-dupes) for static-analysis demos — not live DDL.
SELECT id FROM a
UNION ALL
SELECT id FROM a; -- SAMPLE duplicate union
Specifications
- Role
- sql-lint-shape
- Wave
- I
Testing contract
Expected to fail- Scenario
- Parse the statement and reason about its result cardinality.
- Expected result
- It parses as valid SQL, and because both branches of the UNION ALL select the same column from the same table `a`, every row appears exactly twice - `UNION ALL` does not deduplicate. A linter must flag the identical branches; swapping in `UNION` would change the row count, which is what makes this checkable.
What is a .sql file?
SQL files contain plain-text Structured Query Language statements, typically schema definitions, data inserts, or queries used to build or populate a database. Dialect details vary between engines such as PostgreSQL, MySQL, and SQLite. A dump file often recreates an entire database when executed.
How to use this file
Use an example SQL file to test statement parsing, database restore and migration tooling, and dialect-compatibility of import pipelines.
How to use this file for testing
“SQL Lint Shape — Union All Dupes” is a deterministic Novus Examples fixture for Code parsing, SQL import, Editor testing. Short, known-correct source files in many languages with classes, functions, generics, enums, and error handling, for testing parsers, linters, formatters, language detection, and diff viewers.
Documented properties for this file: sql-lint-shape. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
This is a short, known-correct source file. Run it through your syntax highlighter, linter, formatter, tree-sitter grammar, or parser, and open it in the in-browser editor to tweak and re-download. Each snippet exercises comments, string escapes, literals, and language keywords.
Code examples
psql mydb < union-all-dupes.sql # PostgreSQL
mysql -u user -p mydb < union-all-dupes.sql # MySQLRelated files
- sqlSQL — Hello WorldThe classic first query in SQL — a single SELECT of a literal — for testing highlighters, SQL parsers, and query editors.
- sqlSQL — Library schema (DDL, view, join)A realistic SQL script with CREATE TABLE constraints and foreign keys, INSERT seed data, a CREATE VIEW, and a grouped aggregate query with a join — for testing SQL parsers, formatters, and highlighters.
- sqlSQL Window FunctionSQL window function SAMPLE for SQL parsers.
- cC — Hello WorldThe classic hello-world in C — an include, main, and printf — for testing highlighters, C compilers, and parsers against the canonical first program.
- cC — Linked list (structs, malloc, pointers)A realistic C program: a singly linked list with a typedef struct, malloc/free memory management, pointer walking, and error handling — for testing highlighters, compilers, and static analysers.
- cC StructC struct SAMPLE for clangd / highlighter fixtures.
Generated by generation/pad_wave_i.py. Free for any use, no attribution required, license.