Annotation of parser3/tests/results/388-sql.processed, revision 1.12
1.1 moko 1: Content-Type: text/html
1.12 ! moko 2: Content-Length: 4257
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: },
103: "parrot":{
104: "food":"grain",
105: "aggressive":"alwayws",
106: "weigth":"1"
107: }
108: }
1.9 moko 109:
110: 4.2
111: {
1.1 moko 112: "cat":[
113: {"pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
114: ],
115: "dog":[
116: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
117: ],
118: "parrot":[
119: {"pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
120: ]
121: }
1.9 moko 122:
123: 4.3
124: {
1.1 moko 125: "cat":"milk",
126: "dog":"bone",
127: "parrot":"grain"
128: }
1.9 moko 129:
130: 4.4
131:
1.10 moko 132: Exception type: sql.execute,
1.9 moko 133: Source: select * from pets,
134: Comment: only 2 columns allowed for $.type[string].
135:
136:
137: 4.5.
138: {
1.1 moko 139: "dog":[
140: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
141: ]
142: }
1.9 moko 143:
144: 4.6
145:
1.10 moko 146: Exception type: sql.execute,
1.9 moko 147: Source: select 'dup', pet from pets,
148: Comment: duplicate key
149:
150:
1.11 moko 151: 4.7
152: {
153: "cat":true,
154: "dog":true,
155: "parrot":true
156: }
157:
1.12 ! moko 158: 4.8
! 159: {
! 160: "0":[
! 161: {"key":"0","pet":"cat"},
! 162: {"key":"0","pet":"dog"},
! 163: {"key":"0","pet":"parrot"}
! 164: ]
! 165: }
! 166:
! 167: 4.9
! 168: {
! 169: "0":"cat"
! 170: }
! 171:
1.9 moko 172:
173: 5. table
174:
175: 5.1
176: [
1.1 moko 177: {"pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
178: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
179: {"pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
180: ]
1.9 moko 181:
182: 5.2.
183: [
1.1 moko 184: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
185: ]
1.9 moko 186:
187: 5.3
188:
1.10 moko 189: Exception type: sql.execute,
1.9 moko 190: Source: select * from pets,
191: Comment: bind variables not supported yet
192:
193:
194: 5.4
195:
1.10 moko 196: Exception type: parser.runtime,
1.9 moko 197: Source: sql,
198: Comment: called with invalid option
199:
200:
201:
202: 6. file
203:
204: 6.1
205: {
1.1 moko 206: "class":"file",
207: "name":"test.txt",
208: "size":6,
209: "mode":"binary",
210: "content-type":"text\/plain",
211: "text":"'very'"
212: }
1.9 moko 213:
214: 6.2
215: {
1.1 moko 216: "class":"file",
217: "name":"unknown",
218: "size":7,
219: "mode":"binary",
220: "content-type":"unknown",
221: "text":"\"never\""
222: }
1.9 moko 223:
224: 6.3
225:
1.10 moko 226: Exception type: sql.execute,
1.9 moko 227: Source: select * from pets,
228: Comment: result must contain not more then 3 columns
229:
230:
231: 6.4
232:
1.10 moko 233: Exception type: parser.runtime,
1.9 moko 234: Source: sql,
235: Comment: produced no result
236:
237:
238: 6.5
239: {
1.1 moko 240: "class":"file",
241: "name":"1",
242: "size":1,
243: "mode":"binary",
244: "content-type":"1",
245: "text":"1"
1.9 moko 246: } - bug!
247:
248: 6.6
249:
1.10 moko 250: Exception type: sql.execute,
1.9 moko 251: Source: select 1,2 from pets,
252: Comment: result must not contain more then one row, three columns
253:
254:
255: 6.7
256:
1.10 moko 257: Exception type: parser.runtime,
1.9 moko 258: Source: sql,
259: Comment: called with invalid option
260:
261:
262: 6.8 "''test''"
263:
264: 7. string
265:
266: 7.1
267:
1.10 moko 268: Exception type: sql.execute,
1.9 moko 269: Source: select * from pets,
270: Comment: result must contain exactly one column
271:
272: 7.2
273:
1.10 moko 274: Exception type: sql.execute,
1.9 moko 275: Source: select pet from pets,
276: Comment: result must not contain more then one row
277:
278: 7.3
279:
1.10 moko 280: Exception type: sql.execute,
1.9 moko 281: Source: select 2+2,
282: Comment: bind variables not supported yet
283:
284: 7.4
285:
1.10 moko 286: Exception type: parser.runtime,
1.9 moko 287: Source: sql,
288: Comment: called with invalid option
289:
290: 7.5
291:
1.10 moko 292: Exception type: parser.runtime,
1.9 moko 293: Source: sql,
294: Comment: produced no result, but no default option specified
295:
296: 7.6
297: "default"
298:
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