Annotation of parser3/tests/results/428-sql.processed, revision 1.4
1.1 moko 1: Content-Type: text/html
1.4 ! moko 2: Content-Length: 4538
1.1 moko 3:
4:
5:
6:
7:
8:
9:
10:
11: 1.1
12:
13: Exception type: sql.execute,
14: Source: select pet from pets;select food from pets,
15: Comment: result must contain exactly one table
16:
17:
18: 1.2
19: {
1.2 moko 20: "0":[
21: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
22: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
23: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
24: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
25: ],
26: "1":[
1.4 ! moko 27: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
! 28: {"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
! 29: {"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 30: {"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
1.2 moko 31: ]
32: }
33:
34: 1.3
35: {
36: "0":[
37: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
38: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
39: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
40: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"},
41: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
42: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
43: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
44: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
45: ]
46: }
47:
48: 1.4
49: {
50: "0":[
51: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
52: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
53: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
54: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"},
55: {"0":"0","pet":"4"}
56: ]
57: }
58:
59: 1.5
60: {
61: "0":[
62: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
63: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
64: ],
65: "1":[
1.4 ! moko 66: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
1.2 moko 67: ]
68: }
69:
70: 1.6
71: {
72: "0":[
73: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
74: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
75: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
76: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
77: ],
78: "1":[
1.4 ! moko 79: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
1.2 moko 80: ]
1.4 ! moko 81: } - minor bug: limit for last query only
1.2 moko 82:
83: 1.7
84: {
1.1 moko 85: "cat":[
86: {"pet":"cat","food":"milk"}
87: ],
88: "dog":[
89: {"pet":"dog","food":"bone"}
90: ],
91: "hamster":[
92: {"pet":"hamster","food":"grain"}
93: ],
94: "parrot":[
95: {"pet":"parrot","food":"grain"}
96: ],
1.2 moko 97: "milk":[
1.4 ! moko 98: {"food":"milk","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
1.1 moko 99: ],
1.2 moko 100: "bone":[
1.4 ! moko 101: {"food":"bone","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
1.1 moko 102: ],
1.2 moko 103: "grain":[
1.4 ! moko 104: {"food":"grain","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 105: {"food":"grain","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
1.1 moko 106: ]
1.2 moko 107: }
108:
109: 1.8
110: {
111: "cat":{
112: "food":"milk"
113: },
114: "dog":{
115: "food":"bone"
116: },
117: "hamster":{
118: "food":"grain"
119: },
120: "parrot":{
121: "food":"grain"
122: },
123: "milk":{
1.4 ! moko 124: "pet":"cat",
! 125: "food":"milk",
! 126: "aggressive":"'very'",
! 127: "weigth":"5"
1.2 moko 128: },
129: "bone":{
1.4 ! moko 130: "pet":"dog",
! 131: "food":"bone",
! 132: "aggressive":"\"never\"",
! 133: "weigth":"10"
1.2 moko 134: },
135: "grain":{
1.4 ! moko 136: "pet":"hamster",
! 137: "food":"grain",
! 138: "aggressive":"",
! 139: "weigth":"1"
1.2 moko 140: }
141: }
1.3 moko 142:
143: 1.9
144: {
145: "0":{
146: "pet":"cat",
147: "food":"milk",
148: "aggressive":"'very'",
149: "weigth":"5"
150: }
151: }
1.4 ! moko 152: 1.10
1.3 moko 153: {
154: "0":{
155: "2+2":"4"
156: }
157: }
158:
1.4 ! moko 159: 1.11
! 160: {
! 161: "0":[
! 162: {"0":"0","food":"milk"},
! 163: {"0":"0","food":"bone"},
! 164: {"0":"0","food":"grain"},
! 165: {"0":"0","food":"grain"}
! 166: ],
! 167: "1":[
! 168: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
! 169: {"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
! 170: {"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 171: {"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 172: ]
! 173: } - different structure for each query as key differs
! 174: 1.12
! 175: {
! 176: "0":[
! 177: {"0":"0","food":"milk"},
! 178: {"0":"0","food":"bone"},
! 179: {"0":"0","food":"grain"},
! 180: {"0":"0","food":"grain"},
! 181: {"0":"0","food":"cat","2":"milk","3":"'very'","4":"5"},
! 182: {"0":"0","food":"dog","2":"bone","3":"\"never\"","4":"10"},
! 183: {"0":"0","food":"hamster","2":"grain","3":"","4":"1"},
! 184: {"0":"0","food":"parrot","2":"grain","3":"alwayws","4":"1"}
! 185: ]
! 186: } - note: there are missed and numeric columns in second query, but it better then exception
E-mail:
![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to 428-sql.processed CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [parser3project] / parser3 / tests / results