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