diff options
| author |  Adam Chlipala <adamc@hcoop.net> | 2010-03-25 15:44:24 -0400 |
|---|---|---|
| committer | Adam Chlipala <adamc@hcoop.net> | 2010-03-25 15:44:24 -0400 |
| commit | 8956b5096cd268b6eb73040ede0688849084c5fe (patch) | |
| tree | dec271c0511b398d8701237909469ed5be9dca5b /tests | |
| parent | 68135d19275831c9f63f7e141b5134c17c095b3f (diff) | |
Subquery expressions
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 |