diff options
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/coalesce.ur | 6 | ||||
| -rw-r--r-- | tests/coalesce.urp | 4 |
2 files changed, 10 insertions, 0 deletions
diff --git a/tests/coalesce.ur b/tests/coalesce.ur new file mode 100644 index 00000000..5ee8cf19 --- /dev/null +++ b/tests/coalesce.ur @@ -0,0 +1,6 @@ +table t : { A : option int } + +fun main () : transaction page = + queryX (SELECT COALESCE(t.A, 13) + FROM t) + (fn r => <xml>{[r.1]},</xml>) diff --git a/tests/coalesce.urp b/tests/coalesce.urp new file mode 100644 index 00000000..7d7decee --- /dev/null +++ b/tests/coalesce.urp @@ -0,0 +1,4 @@ +database dbname=test +sql coalesce.sql + +coalesce |