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