Test fixtures aren't not valid ansi sql

Dialect

SQLite

Failing SQL

SELECT 42 WHERE 1 = ?1;

Description

Unfortunately, there is no real ANSI sql standard, because the standard itself is not very strict and every vendor has custom dialects. But the test fixtures should be dialect agnostic as possible.

This includes:

• No ?1 because this syntax isn't supported by all dialects (eg PostgreSQL R2DBC or DB2)
• Always add a FROM clause. While almost all dialects do support omitting the FROM clause, DB2 does not.

One simple option split the test fixtures and the variable into ansi sql and common sql (name to be discussed), which contains the failing test fixtures.

Locate the SQL test fixtures containing SELECT 42 WHERE 1 = ?1 and inspect how dialect-specific fixture groups are organized. Run the relevant fixture or parser tests, then ensure ANSI fixtures avoid numbered parameters and include a FROM clause, with the tests passing for the supported dialects.