diff options
author | Benjamin Barenblat <bbaren@mit.edu> | 2017-07-23 09:50:04 -0400 |
---|---|---|
committer | Benjamin Barenblat <bbaren@mit.edu> | 2017-07-23 09:50:04 -0400 |
commit | 0cccdb0ae595cd7e3e136e984ac7b95b99f71a53 (patch) | |
tree | 491d3b13813610943c60460d3e178d3a73916346 /tests/order_by.ur |
Import urweb_20170720+dfsg.orig.tar.gz
[dgit import orig urweb_20170720+dfsg.orig.tar.gz]
Diffstat (limited to 'tests/order_by.ur')
-rw-r--r-- | tests/order_by.ur | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/tests/order_by.ur b/tests/order_by.ur new file mode 100644 index 0000000..de584fd --- /dev/null +++ b/tests/order_by.ur @@ -0,0 +1,35 @@ +table t1 : {A : int, B : string, C : float} +table t2 : {A : float, D : int} + +val q1 = (SELECT * FROM t1 ORDER BY t1.A, t1.B) +val q2 = (SELECT * FROM t1 GROUP BY t1.A ORDER BY t1.A, t1.B) +val q3 = (SELECT t1.B FROM t1 + UNION SELECT t1.B FROM t1 + ORDER BY t1.B) + +val q4 = (SELECT t1.A, t2.D, t1.A < t2.D AS Lt + FROM t1, t2 + ORDER BY Lt) +val q5 = (SELECT t1.A, t1.B, t2.D, t1.A < t2.D AS Lt + FROM t1, t2 + ORDER BY t1.A DESC, Lt ASC, t2.D DESC) + + +datatype list a = Nil | Cons of a * list a + +val r1 : transaction (list string) = + query q5 + (fn fs acc => return (Cons (fs.T1.B, acc))) + Nil + +val r2 : transaction string = + ls <- r1; + return (case ls of + Nil => "Problem" + | Cons (b, _) => b) + +val main : unit -> transaction page = fn () => + s <- r2; + return <html><body> + {cdata s} + </body></html> |