Annotation of parser3/tests/results/388-sql.processed, revision 1.14
1.1 moko 1: Content-Type: text/html
1.14 ! moko 2: Content-Length: 4683
1.9 moko 3:
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,
136: Comment: only 2 columns allowed for $.type[string].
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":[
172: {"key":"milk","pet":"cat"}
173: ],
174: "bone":[
175: {"key":"bone","pet":"dog"}
176: ],
177: "grain":[
178: {"key":"grain","pet":"hamster"},
179: {"key":"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,
247: Comment: result must contain not more then 3 columns
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:
257: 6.5
258: {
1.1 moko 259: "class":"file",
260: "name":"1",
261: "size":1,
262: "mode":"binary",
263: "content-type":"1",
264: "text":"1"
1.9 moko 265: } - bug!
266:
267: 6.6
268:
1.10 moko 269: Exception type: sql.execute,
1.9 moko 270: Source: select 1,2 from pets,
271: Comment: result must not contain more then one row, three columns
272:
273:
274: 6.7
275:
1.10 moko 276: Exception type: parser.runtime,
1.9 moko 277: Source: sql,
278: Comment: called with invalid option
279:
280:
281: 6.8 "''test''"
282:
283: 7. string
284:
285: 7.1
286:
1.10 moko 287: Exception type: sql.execute,
1.9 moko 288: Source: select * from pets,
289: Comment: result must contain exactly one column
290:
291: 7.2
292:
1.10 moko 293: Exception type: sql.execute,
1.9 moko 294: Source: select pet from pets,
295: Comment: result must not contain more then one row
296:
297: 7.3
298:
1.10 moko 299: Exception type: sql.execute,
1.9 moko 300: Source: select 2+2,
301: Comment: bind variables not supported yet
302:
303: 7.4
304:
1.10 moko 305: Exception type: parser.runtime,
1.9 moko 306: Source: sql,
307: Comment: called with invalid option
308:
309: 7.5
310:
1.10 moko 311: Exception type: parser.runtime,
1.9 moko 312: Source: sql,
313: Comment: produced no result, but no default option specified
314:
315: 7.6
316: "default"
317:
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