Changes between Initial Version and Version 2 of Ticket #27412


Ignore:
Timestamp:
Nov 2, 2016, 12:24:17 AM (7 years ago)
Author:
Tzu-ping Chung
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #27412

    • Property Triage Stage UnreviewedAccepted
    • Property Summary Coalesce function does not work with subqueriesCoalesce function should work with subqueries
  • Ticket #27412 – Description

    initial v2  
    1010
    1111{{{
    12 SELECT val FROM foo WHERE COALESCE((SELECT val FROM foo WHERE val=6 LIMIT 1 OFFSET 0), 3);
     12SELECT val FROM foo WHERE val >= COALESCE((SELECT val FROM foo WHERE val=6 LIMIT 1 OFFSET 0), 3);
    1313}}}
    1414
Back to Top