Mercurial > urweb

comparison tests/sql_indent.ur @ 375:d3de57ce4bca

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixing overzealous SQL paren-nester
author Adam Chlipala <adamc@hcoop.net>
date Thu, 16 Oct 2008 17:31:24 -0400
parents 1099d083a702
children
comparison
equal deleted inserted replaced
374:1099d083a702 375:d3de57ce4bca
1 table t1 : {A : int, B : string, C : float} 1 table t1 : {A : int, B : string, C : float}
2 2
3 val q1 = (SELECT * 3 val q1 = (SELECT *
4 FROM t1) 4 FROM t1
5 WHERE A = 0) 5 WHERE A = 0)
6 6
7 val a1 = (INSERT INTO t1 7 val a1 = (INSERT INTO t1
8 VALUES (0, "1", 2.0)) 8 VALUES (0, "1", 2.0))
9 9
10 val a2 = (UPDATE t1 10 val a2 = (UPDATE t1
11 SET A = 3, B = "4", C = 5.0) 11 SET A = 3, B = "4", C = 5.0)
12 12
13 val a3 = (DELETE FROM t1 13 val a3 = (DELETE FROM t1
14 WHERE B <> "good") 14 WHERE B <> "good")
15 15
16 16
17 val q2 = (SELECT * 17 val q2 = (SELECT *