Annotation of parser3/tests/results/388-sql.processed, revision 1.9
1.1 moko 1: Content-Type: text/html
1.9 ! moko 2: Content-Length: 3863
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:
! 27: Type: sql.execute,
! 28: Source: select * from pets,
! 29: Comment: must return nothing
! 30:
! 31: 2.4
! 32:
! 33: Type: parser.runtime,
! 34: Source: sql,
! 35: Comment: called with invalid option
! 36:
! 37: 2.5
! 38:
! 39: Type: sql.execute,
! 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:
! 47: Type: sql.execute,
! 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:
! 53: Type: sql.execute,
! 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:
! 64: Type: parser.runtime,
! 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:
! 73: Type: parser.runtime,
! 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:
! 83: Type: sql.execute,
! 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:
! 132: Type: sql.execute,
! 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:
! 146: Type: sql.execute,
! 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:
! 168: Type: sql.execute,
! 169: Source: select * from pets,
! 170: Comment: bind variables not supported yet
! 171:
! 172:
! 173: 5.4
! 174:
! 175: Type: parser.runtime,
! 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:
! 205: Type: sql.execute,
! 206: Source: select * from pets,
! 207: Comment: result must contain not more then 3 columns
! 208:
! 209:
! 210: 6.4
! 211:
! 212: Type: parser.runtime,
! 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:
! 229: Type: sql.execute,
! 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:
! 236: Type: parser.runtime,
! 237: Source: sql,
! 238: Comment: called with invalid option
! 239:
! 240:
! 241: 6.8 "''test''"
! 242:
! 243: 7. string
! 244:
! 245: 7.1
! 246:
! 247: Type: sql.execute,
! 248: Source: select * from pets,
! 249: Comment: result must contain exactly one column
! 250:
! 251: 7.2
! 252:
! 253: Type: sql.execute,
! 254: Source: select pet from pets,
! 255: Comment: result must not contain more then one row
! 256:
! 257: 7.3
! 258:
! 259: Type: sql.execute,
! 260: Source: select 2+2,
! 261: Comment: bind variables not supported yet
! 262:
! 263: 7.4
! 264:
! 265: Type: parser.runtime,
! 266: Source: sql,
! 267: Comment: called with invalid option
! 268:
! 269: 7.5
! 270:
! 271: Type: parser.runtime,
! 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