Mercurial > urweb

comparison tests/sql_indent.ur @ 373:008afab3a5ce

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Indenting simple DML properly
author Adam Chlipala <adamc@hcoop.net>
date Thu, 16 Oct 2008 16:24:19 -0400
parents fe018cbdd41e
children 1099d083a702
comparison
equal deleted inserted replaced
372:fe018cbdd41e 373:008afab3a5ce
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
7 val a1 = (INSERT INTO t1
8 VALUES (0, "1", 2.0))
9
10 val a2 = (UPDATE t1
11 SET A = 3, B = "4", C = 5.0)
12
13 val a3 = (DELETE FROM t1
14 WHERE B <> "good")