Annotation of parser3/tests/results/388-sql.processed, revision 1.11
1.1 moko 1: Content-Type: text/html
1.11 ! moko 2: Content-Length: 4127
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.9 moko 158:
159: 5. table
160:
161: 5.1
162: [
1.1 moko 163: {"pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
164: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
165: {"pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
166: ]
1.9 moko 167:
168: 5.2.
169: [
1.1 moko 170: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
171: ]
1.9 moko 172:
173: 5.3
174:
1.10 moko 175: Exception type: sql.execute,
1.9 moko 176: Source: select * from pets,
177: Comment: bind variables not supported yet
178:
179:
180: 5.4
181:
1.10 moko 182: Exception type: parser.runtime,
1.9 moko 183: Source: sql,
184: Comment: called with invalid option
185:
186:
187:
188: 6. file
189:
190: 6.1
191: {
1.1 moko 192: "class":"file",
193: "name":"test.txt",
194: "size":6,
195: "mode":"binary",
196: "content-type":"text\/plain",
197: "text":"'very'"
198: }
1.9 moko 199:
200: 6.2
201: {
1.1 moko 202: "class":"file",
203: "name":"unknown",
204: "size":7,
205: "mode":"binary",
206: "content-type":"unknown",
207: "text":"\"never\""
208: }
1.9 moko 209:
210: 6.3
211:
1.10 moko 212: Exception type: sql.execute,
1.9 moko 213: Source: select * from pets,
214: Comment: result must contain not more then 3 columns
215:
216:
217: 6.4
218:
1.10 moko 219: Exception type: parser.runtime,
1.9 moko 220: Source: sql,
221: Comment: produced no result
222:
223:
224: 6.5
225: {
1.1 moko 226: "class":"file",
227: "name":"1",
228: "size":1,
229: "mode":"binary",
230: "content-type":"1",
231: "text":"1"
1.9 moko 232: } - bug!
233:
234: 6.6
235:
1.10 moko 236: Exception type: sql.execute,
1.9 moko 237: Source: select 1,2 from pets,
238: Comment: result must not contain more then one row, three columns
239:
240:
241: 6.7
242:
1.10 moko 243: Exception type: parser.runtime,
1.9 moko 244: Source: sql,
245: Comment: called with invalid option
246:
247:
248: 6.8 "''test''"
249:
250: 7. string
251:
252: 7.1
253:
1.10 moko 254: Exception type: sql.execute,
1.9 moko 255: Source: select * from pets,
256: Comment: result must contain exactly one column
257:
258: 7.2
259:
1.10 moko 260: Exception type: sql.execute,
1.9 moko 261: Source: select pet from pets,
262: Comment: result must not contain more then one row
263:
264: 7.3
265:
1.10 moko 266: Exception type: sql.execute,
1.9 moko 267: Source: select 2+2,
268: Comment: bind variables not supported yet
269:
270: 7.4
271:
1.10 moko 272: Exception type: parser.runtime,
1.9 moko 273: Source: sql,
274: Comment: called with invalid option
275:
276: 7.5
277:
1.10 moko 278: Exception type: parser.runtime,
1.9 moko 279: Source: sql,
280: Comment: produced no result, but no default option specified
281:
282: 7.6
283: "default"
284:
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