Changes between Initial Version and Version 2 of Ticket #27412
- Timestamp:
- Nov 2, 2016, 12:24:17 AM (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #27412
- Property Triage Stage Unreviewed → Accepted
- Property Summary Coalesce function does not work with subqueries → Coalesce function should work with subqueries
-
Ticket #27412 – Description
initial v2 10 10 11 11 {{{ 12 SELECT val FROM foo WHERE COALESCE((SELECT val FROM foo WHERE val=6 LIMIT 1 OFFSET 0), 3);12 SELECT val FROM foo WHERE val >= COALESCE((SELECT val FROM foo WHERE val=6 LIMIT 1 OFFSET 0), 3); 13 13 }}} 14 14