search

AnyhowStep / tsql

A SQL query-builder/ORM
37 stars 3 forks source link

SQLite does not throw if subquery returns more than one row #232

Open AnyhowStep opened 4 years ago

AnyhowStep commented 4 years ago

On SQLite, the following returns 'hi',

SELECT 
  COALESCE(
    NULL, 
    (SELECT 'hi' UNION ALL SELECT 'bye')
  );

It will throw for any other database.