diff options
Diffstat (limited to 'tests')
-rw-r--r-- | tests/subquery.ur | 10 | ||||
-rw-r--r-- | tests/subquery.urp | 4 | ||||
-rw-r--r-- | tests/subquery.urs | 1 |
3 files changed, 15 insertions, 0 deletions
diff --git a/tests/subquery.ur b/tests/subquery.ur new file mode 100644 index 00000000..302175e5 --- /dev/null +++ b/tests/subquery.ur @@ -0,0 +1,10 @@ +table t : { A : int, B : int, C : int } + +fun main () = + v <- queryX1 (SELECT t.A, t.C + FROM t + WHERE t.B = (SELECT MAX(U.B) AS M + FROM t AS U + WHERE U.A = t.A)) + (fn r => <xml>{[r.A]},{[r.C]};</xml>); + return <xml>{v}</xml> diff --git a/tests/subquery.urp b/tests/subquery.urp new file mode 100644 index 00000000..3397f04c --- /dev/null +++ b/tests/subquery.urp @@ -0,0 +1,4 @@ +database /tmp/test +sql subquery.sql + +subquery diff --git a/tests/subquery.urs b/tests/subquery.urs new file mode 100644 index 00000000..6ac44e0b --- /dev/null +++ b/tests/subquery.urs @@ -0,0 +1 @@ +val main : unit -> transaction page |