Annotation of parser3/tests/results/429-sql.processed, revision 1.2
1.1 moko 1: Content-Type: text/html
1.2 ! moko 2: Content-Length: 12640
1.1 moko 3:
4:
5:
6:
7:
8:
9:
10: basic tests
11: 2.1
12: [
13: {
14: "pet":"cat",
15: "food":"milk",
16: "aggressive":"'very'",
17: "weigth":"5"
18: },
19: {
20: "pet":"dog",
21: "food":"bone",
22: "aggressive":"\"never\"",
23: "weigth":"10"
24: },
25: {
26: "pet":"hamster",
27: "food":"grain",
28: "aggressive":"",
29: "weigth":"1"
30: },
31: {
32: "pet":"parrot",
33: "food":"grain",
34: "aggressive":"alwayws",
35: "weigth":"1"
36: }
37: ]
38:
39: 2.2
40: [
41: [
42: {"pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
43: ],
44: [
45: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
46: ],
47: [
48: {"pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
49: ],
50: [
51: {"pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
52: ]
53: ]
54:
55: 2.3
56: [
57: {
58: "pet":"cat"
59: },
60: {
61: "pet":"dog"
62: },
63: {
64: "pet":"hamster"
65: },
66: {
67: "pet":"parrot"
68: }
69: ]
70:
71: 2.4
72: [
73: "cat",
74: "dog",
75: "hamster",
76: "parrot"
77: ]
78:
79: 2.5
80:
81: Exception type: sql.execute,
82: Source: select * from pets,
83: Comment: only one column allowed for $.type[string]
84:
85:
86: 2.6
87:
88: Exception type: parser.runtime,
89: Source: sql,
90: Comment: 'distinct' option can only be used when $.sparse(true) is specified
91:
92:
93: 2.7
94: [
95: [
96: {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
97: ]
98: ]
99:
100: 2.8
101: [
102: [
103: {"aggressive":"'very'"}
104: ],
105: [
106: {"aggressive":"\"never\""}
107: ],
108: [
109: {"aggressive":""}
110: ],
111: [
112: {"aggressive":"alwayws"}
113: ]
114: ]
1.2 ! moko 115:
! 116: 2.9
! 117:
! 118: Exception type: parser.runtime,
! 119: Source: sql,
! 120: Comment: called with invalid option
! 121:
1.1 moko 122: multi statements tests
123:
1.2 ! moko 124: 1.1
! 125: []
! 126:
1.1 moko 127: 1.2
128: [
129: [
130: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
131: ],
132: [
133: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
134: ],
135: [
136: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
137: ],
138: [
139: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
140: ],
141: [
142: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
143: ],
144: [
145: {"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
146: ],
147: [
148: {"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
149: ],
150: [
151: {"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
152: ]
153: ]
154:
155: 1.3
156: [
157: [
158: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
159: ],
160: [
161: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
162: ],
163: [
164: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
165: ],
166: [
167: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
168: ],
169: [
170: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
171: ],
172: [
173: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
174: ],
175: [
176: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
177: ],
178: [
179: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
180: ]
181: ]
182:
183: 1.4
184: [
185: [
186: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
187: ],
188: [
189: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
190: ],
191: [
192: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
193: ],
194: [
195: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
196: ],
197: [
198: {"0":"0","2+2":"4"}
199: ]
200: ]
201:
202: 1.5
203: [
204: [
205: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
206: ],
207: [
208: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
209: ],
210: [
211: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
212: ]
213: ]
214:
215: 1.6
216: [
217: [
218: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
219: ],
220: [
221: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
222: ],
223: [
224: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
225: ],
226: [
227: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
228: ],
229: [
230: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
231: ]
232: ] - minor bug: limit for last query only
233:
234: 1.7
235: [
236: [
237: {"weigth":"5","food":"milk"}
238: ],
239: [
240: {"weigth":"10","food":"bone"}
241: ],
242: [
243: {"weigth":"1","food":"grain"}
244: ],
245: [
246: {"weigth":"1","food":"grain"}
247: ],
248: [
249: {"weigth+10":"15","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
250: ],
251: [
252: {"weigth+10":"20","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
253: ],
254: [
255: {"weigth+10":"11","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
256: ],
257: [
258: {"weigth+10":"11","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
259: ]
260: ]
261:
262: 1.8
263: [
264: {
265: "weigth":"5",
266: "food":"milk"
267: },
268: {
269: "weigth":"10",
270: "food":"bone"
271: },
272: {
273: "weigth":"1",
274: "food":"grain"
275: },
276: {
277: "weigth":"1",
278: "food":"grain"
279: },
280: {
281: "weigth+10":"15",
282: "pet":"cat",
283: "food":"milk",
284: "aggressive":"'very'",
285: "weigth":"5"
286: },
287: {
288: "weigth+10":"20",
289: "pet":"dog",
290: "food":"bone",
291: "aggressive":"\"never\"",
292: "weigth":"10"
293: },
294: {
295: "weigth+10":"11",
296: "pet":"hamster",
297: "food":"grain",
298: "aggressive":"",
299: "weigth":"1"
300: },
301: {
302: "weigth+10":"11",
303: "pet":"parrot",
304: "food":"grain",
305: "aggressive":"alwayws",
306: "weigth":"1"
307: }
308: ]
309:
310: 1.9
311: [
312: {
313: "0":"0",
314: "pet":"cat",
315: "food":"milk",
316: "aggressive":"'very'",
317: "weigth":"5"
318: },
319: {
320: "0":"0",
321: "pet":"dog",
322: "food":"bone",
323: "aggressive":"\"never\"",
324: "weigth":"10"
325: },
326: {
327: "0":"0",
328: "pet":"hamster",
329: "food":"grain",
330: "aggressive":"",
331: "weigth":"1"
332: },
333: {
334: "0":"0",
335: "pet":"parrot",
336: "food":"grain",
337: "aggressive":"alwayws",
338: "weigth":"1"
339: },
340: {
341: "0":"0",
342: "2+2":"4"
343: }
344: ]
345: 1.10
346: [
347: {
348: "0":"0",
349: "2+2":"4"
350: },
351: {
352: "0":"0",
353: "pet":"cat",
354: "food":"milk",
355: "aggressive":"'very'",
356: "weigth":"5"
357: },
358: {
359: "0":"0",
360: "pet":"dog",
361: "food":"bone",
362: "aggressive":"\"never\"",
363: "weigth":"10"
364: },
365: {
366: "0":"0",
367: "pet":"hamster",
368: "food":"grain",
369: "aggressive":"",
370: "weigth":"1"
371: },
372: {
373: "0":"0",
374: "pet":"parrot",
375: "food":"grain",
376: "aggressive":"alwayws",
377: "weigth":"1"
378: }
379: ]
380:
381: 1.11
382: [
383: [
384: {"0":"0","food":"milk"}
385: ],
386: [
387: {"0":"0","food":"bone"}
388: ],
389: [
390: {"0":"0","food":"grain"}
391: ],
392: [
393: {"0":"0","food":"grain"}
394: ],
395: [
396: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
397: ],
398: [
399: {"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
400: ],
401: [
402: {"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
403: ],
404: [
405: {"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
406: ]
407: ]
408: 1.12
409: [
410: [
411: {"0":"0","food":"milk"}
412: ],
413: [
414: {"0":"0","food":"bone"}
415: ],
416: [
417: {"0":"0","food":"grain"}
418: ],
419: [
420: {"0":"0","food":"grain"}
421: ],
422: [
423: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
424: ],
425: [
426: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
427: ],
428: [
429: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
430: ],
431: [
432: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
433: ]
434: ]
435:
436:
437: basic tests sparse
438: 3.1
439: {
440: "1":[
441: {"key":"1","pet":"hamster"},
442: {"key":"1","pet":"parrot"}
443: ],
444: "5":[
445: {"key":"5","pet":"cat"}
446: ],
447: "10":[
448: {"key":"10","pet":"dog"}
449: ]
450: }
1.2 ! moko 451: 3.1.1
! 452:
! 453: Exception type: sql.execute,
! 454: Source: select weigth as key, pet from pets,
! 455: Comment: duplicate key
! 456:
1.1 moko 457:
458: 3.2
459: {
460: "1":"hamster",
461: "5":"cat",
462: "10":"dog"
463: }
1.2 ! moko 464: 3.2.1
! 465:
! 466: Exception type: sql.execute,
! 467: Source: select weigth as key, pet from pets,
! 468: Comment: duplicate key
! 469:
1.1 moko 470:
471:
472:
473: 3.3
474: {
475: "1":{
476: "pet":"parrot",
477: "food":"grain",
478: "aggressive":"alwayws",
479: "weigth":"1"
480: },
481: "5":{
482: "pet":"cat",
483: "food":"milk",
484: "aggressive":"'very'",
485: "weigth":"5"
486: },
487: "10":{
488: "pet":"dog",
489: "food":"bone",
490: "aggressive":"\"never\"",
491: "weigth":"10"
492: }
493: }
494:
495: 3.4
496: {
497: "1":[
498: {"weigth":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
499: ],
500: "5":[
501: {"weigth":"5","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
502: ],
503: "10":[
504: {"weigth":"10","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
505: ]
506: }
507:
508: 3.5
509: {
510: "1":"grain",
511: "5":"milk",
512: "10":"bone"
513: }
514:
515: 3.6
516:
517: Exception type: sql.execute,
518: Source: select weigth, * from pets,
519: Comment: only 2 columns allowed for $.type[string] and $.sparse(true)
520:
521:
522: 3.7.
523: {
524: "10":[
525: {"weigth":"10","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
526: ]
527: }
528:
529: 3.8
530:
531: Exception type: sql.execute,
532: Source: select '1', pet from pets,
533: Comment: duplicate key
534:
535:
536: 3.9
537: {
538: "1":{
539: "pet":"parrot"
540: },
541: "5":{
542: "pet":"cat"
543: },
544: "10":{
545: "pet":"dog"
546: }
547: }
1.2 ! moko 548:
! 549: 3.10
! 550: {
! 551: "1":true,
! 552: "5":true,
! 553: "10":true
! 554: }
! 555:
! 556: 3.11
! 557:
! 558: Exception type: number.format,
! 559: Source: sqlite://****,
! 560: Comment: '-1' is out if range (negative)
! 561:
1.1 moko 562:
563:
564:
565:
566:
567:
568: multi statements tests
569:
1.2 ! moko 570: 1.1
! 571: {}
! 572:
1.1 moko 573: 1.2
574: {
575: "0":[
576: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
577: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
578: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
579: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
580: ],
581: "1":[
582: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
583: {"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
584: {"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
585: {"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
586: ]
587: }
588:
589: 1.3
590: {
591: "0":[
592: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
593: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
594: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
595: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"},
596: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
597: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
598: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
599: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
600: ]
601: }
602:
603: 1.4
604: {
605: "0":[
606: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
607: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
608: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
609: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"},
610: {"0":"0","pet":"4"}
611: ]
612: }
613:
614: 1.5
615: {
616: "0":[
617: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
618: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
619: ],
620: "1":[
621: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
622: ]
623: }
624:
625: 1.6
626: {
627: "0":[
628: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
629: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
630: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
631: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
632: ],
633: "1":[
634: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
635: ]
636: } - minor bug: limit for last query only
637:
638: 1.7
639: {
640: "1":[
641: {"weigth":"1","food":"grain"},
642: {"weigth":"1","food":"grain"}
643: ],
644: "5":[
645: {"weigth":"5","food":"milk"}
646: ],
647: "10":[
648: {"weigth":"10","food":"bone"}
649: ],
650: "11":[
651: {"weigth+10":"11","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
652: {"weigth+10":"11","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
653: ],
654: "15":[
655: {"weigth+10":"15","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
656: ],
657: "20":[
658: {"weigth+10":"20","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
659: ]
660: }
661:
662: 1.8
663: {
664: "1":{
665: "food":"grain"
666: },
667: "5":{
668: "food":"milk"
669: },
670: "10":{
671: "food":"bone"
672: },
673: "11":{
674: "pet":"hamster",
675: "food":"grain",
676: "aggressive":"",
677: "weigth":"1"
678: },
679: "15":{
680: "pet":"cat",
681: "food":"milk",
682: "aggressive":"'very'",
683: "weigth":"5"
684: },
685: "20":{
686: "pet":"dog",
687: "food":"bone",
688: "aggressive":"\"never\"",
689: "weigth":"10"
690: }
691: }
692:
693: 1.9
694: {
695: "0":{
696: "pet":"cat",
697: "food":"milk",
698: "aggressive":"'very'",
699: "weigth":"5"
700: }
701: }
702: 1.10
703: {
704: "0":{
705: "2+2":"4"
706: }
707: }
708:
709: 1.11
710: {
711: "0":[
712: {"0":"0","food":"milk"},
713: {"0":"0","food":"bone"},
714: {"0":"0","food":"grain"},
715: {"0":"0","food":"grain"}
716: ],
717: "1":[
718: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
719: {"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
720: {"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
721: {"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
722: ]
723: }
724: 1.12
725: {
726: "0":[
727: {"0":"0","food":"milk"},
728: {"0":"0","food":"bone"},
729: {"0":"0","food":"grain"},
730: {"0":"0","food":"grain"},
731: {"0":"0","food":"cat","2":"milk","3":"'very'","4":"5"},
732: {"0":"0","food":"dog","2":"bone","3":"\"never\"","4":"10"},
733: {"0":"0","food":"hamster","2":"grain","3":"","4":"1"},
734: {"0":"0","food":"parrot","2":"grain","3":"alwayws","4":"1"}
735: ]
736: }
E-mail:
![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to 429-sql.processed CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [parser3project] / parser3 / tests / results