Annotation of parser3/tests/results/388-sql.processed, revision 1.18
1.18 ! moko 1: Content-Type: text/html
! 2: Content-Length: 4662
! 3:
1.9 moko 4:
5:
6:
7: 1. 2 + 2 = 4
8:
9:
10: 2. void
11:
1.14 moko 12: 2.1
1.9 moko 13:
1.14 moko 14:
1.9 moko 15:
1.14 moko 16:
1.9 moko 17:
18: 2.3
19:
1.10 moko 20: Exception type: sql.execute,
1.9 moko 21: Source: select * from pets,
22: Comment: must return nothing
23:
24: 2.4
25:
1.10 moko 26: Exception type: parser.runtime,
1.9 moko 27: Source: sql,
28: Comment: called with invalid option
29:
30: 2.5
31:
1.10 moko 32: Exception type: sql.execute,
1.9 moko 33: Source: query,
34: Comment: bind variables not supported yet
35:
36:
37: 2.6 Multiple queries:
38: 2.8 Multiple queries, data in first query:
39:
1.10 moko 40: Exception type: sql.execute,
1.9 moko 41: Source: select 2+2 ; delete from pets where pet='',
42: Comment: must return nothing
43:
44: 2.9 Multiple queries, data in second query:
45:
1.10 moko 46: Exception type: sql.execute,
1.9 moko 47: Source: delete from pets where pet='' ; select 2+2,
48: Comment: must return nothing
49:
50:
51:
52: 3. int/double
53:
54: 3.1 2 int
55: 3.2
56:
1.10 moko 57: Exception type: parser.runtime,
1.9 moko 58: Source: sql,
59: Comment: produced no result, but no default option specified
60:
61: 3.3 1
62:
63: 3.4 -2 double
64: 3.5
65:
1.10 moko 66: Exception type: parser.runtime,
1.9 moko 67: Source: sql,
68: Comment: produced no result, but no default option specified
69:
70: 3.6 1
71:
72: 3.7 Multiple queries, data in first query: 4
73: 3.8 Multiple queries, data in second query: 4
74: 3.9 Multiple queries, data in both queries:
75:
1.10 moko 76: Exception type: sql.execute,
1.9 moko 77: Source: select 2+2 ; select 3+3 ,
78: Comment: result must contain exactly one column
79:
80:
81:
82: 4. hash
83:
84: 4.1
85: {
1.1 moko 86: "cat":{
87: "food":"milk",
88: "aggressive":"'very'",
89: "weigth":"5"
90: },
91: "dog":{
92: "food":"bone",
93: "aggressive":"\"never\"",
94: "weigth":"10"
95: },
1.13 moko 96: "hamster":{
97: "food":"grain",
98: "aggressive":"",
99: "weigth":"1"
100: },
1.1 moko 101: "parrot":{
102: "food":"grain",
103: "aggressive":"alwayws",
104: "weigth":"1"
105: }
106: }
1.9 moko 107:
108: 4.2
109: {
1.1 moko 110: "cat":[
111: {"pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
112: ],
113: "dog":[
114: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
115: ],
1.13 moko 116: "hamster":[
117: {"pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
118: ],
1.1 moko 119: "parrot":[
120: {"pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
121: ]
122: }
1.9 moko 123:
124: 4.3
125: {
1.1 moko 126: "cat":"milk",
127: "dog":"bone",
1.13 moko 128: "hamster":"grain",
1.1 moko 129: "parrot":"grain"
130: }
1.9 moko 131:
132: 4.4
133:
1.10 moko 134: Exception type: sql.execute,
1.9 moko 135: Source: select * from pets,
1.17 moko 136: Comment: only 2 columns allowed for $.type[string]
1.9 moko 137:
138:
139: 4.5.
140: {
1.1 moko 141: "dog":[
142: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
143: ]
144: }
1.9 moko 145:
146: 4.6
147:
1.10 moko 148: Exception type: sql.execute,
1.9 moko 149: Source: select 'dup', pet from pets,
150: Comment: duplicate key
151:
152:
1.11 moko 153: 4.7
154: {
155: "cat":true,
156: "dog":true,
1.13 moko 157: "hamster":true,
1.11 moko 158: "parrot":true
159: }
160:
1.13 moko 161: 4.7.1
162: {
163: "'very'":true,
164: "\"never\"":true,
165: "":true,
166: "alwayws":true
167: }
168:
1.12 moko 169: 4.8
170: {
1.13 moko 171: "milk":[
1.18 ! moko 172: {"id":"milk","pet":"cat"}
1.13 moko 173: ],
174: "bone":[
1.18 ! moko 175: {"id":"bone","pet":"dog"}
1.13 moko 176: ],
177: "grain":[
1.18 ! moko 178: {"id":"grain","pet":"hamster"},
! 179: {"id":"grain","pet":"parrot"}
1.12 moko 180: ]
181: }
182:
183: 4.9
184: {
1.13 moko 185: "milk":"cat",
186: "bone":"dog",
187: "grain":"hamster"
1.12 moko 188: }
189:
1.9 moko 190:
191: 5. table
192:
193: 5.1
194: [
1.1 moko 195: {"pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
196: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
1.13 moko 197: {"pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
1.1 moko 198: {"pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
199: ]
1.9 moko 200:
201: 5.2.
202: [
1.1 moko 203: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
204: ]
1.9 moko 205:
206: 5.3
207:
1.10 moko 208: Exception type: sql.execute,
1.9 moko 209: Source: select * from pets,
210: Comment: bind variables not supported yet
211:
212:
213: 5.4
214:
1.10 moko 215: Exception type: parser.runtime,
1.9 moko 216: Source: sql,
217: Comment: called with invalid option
218:
219:
220:
221: 6. file
222:
223: 6.1
224: {
1.1 moko 225: "class":"file",
226: "name":"test.txt",
227: "size":6,
228: "mode":"binary",
229: "content-type":"text\/plain",
230: "text":"'very'"
231: }
1.9 moko 232:
233: 6.2
234: {
1.1 moko 235: "class":"file",
236: "name":"unknown",
237: "size":7,
238: "mode":"binary",
239: "content-type":"unknown",
240: "text":"\"never\""
241: }
1.9 moko 242:
243: 6.3
244:
1.10 moko 245: Exception type: sql.execute,
1.9 moko 246: Source: select * from pets,
1.15 moko 247: Comment: result must contain no more than 3 columns
1.9 moko 248:
249:
250: 6.4
251:
1.10 moko 252: Exception type: parser.runtime,
1.9 moko 253: Source: sql,
254: Comment: produced no result
255:
256:
1.15 moko 257: 6.5
258:
259: Exception type: sql.execute,
260: Source: select 1 from pets,
261: Comment: result must contain no more than 1 row
262:
1.9 moko 263:
264: 6.6
265:
1.10 moko 266: Exception type: sql.execute,
1.9 moko 267: Source: select 1,2 from pets,
1.15 moko 268: Comment: result must contain no more than 1 row
1.9 moko 269:
270:
271: 6.7
272:
1.10 moko 273: Exception type: parser.runtime,
1.9 moko 274: Source: sql,
275: Comment: called with invalid option
276:
277:
278: 6.8 "''test''"
279:
280: 7. string
281:
282: 7.1
283:
1.10 moko 284: Exception type: sql.execute,
1.9 moko 285: Source: select * from pets,
286: Comment: result must contain exactly one column
287:
288: 7.2
289:
1.10 moko 290: Exception type: sql.execute,
1.9 moko 291: Source: select pet from pets,
1.16 moko 292: Comment: result must contain no more than one row
1.9 moko 293:
294: 7.3
295:
1.10 moko 296: Exception type: sql.execute,
1.9 moko 297: Source: select 2+2,
298: Comment: bind variables not supported yet
299:
300: 7.4
301:
1.10 moko 302: Exception type: parser.runtime,
1.9 moko 303: Source: sql,
304: Comment: called with invalid option
305:
306: 7.5
307:
1.10 moko 308: Exception type: parser.runtime,
1.9 moko 309: Source: sql,
310: Comment: produced no result, but no default option specified
311:
312: 7.6
313: "default"
314:
E-mail:
![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to 388-sql.processed CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [parser3project] / parser3 / tests / results