Annotation of parser3/tests/results/429-sql.processed, revision 1.1
1.1 ! moko 1: Content-Type: text/html
! 2: Content-Length: 12144
! 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: ]
! 115: multi statements tests
! 116:
! 117: 1.2
! 118: [
! 119: [
! 120: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 121: ],
! 122: [
! 123: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 124: ],
! 125: [
! 126: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
! 127: ],
! 128: [
! 129: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 130: ],
! 131: [
! 132: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 133: ],
! 134: [
! 135: {"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 136: ],
! 137: [
! 138: {"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
! 139: ],
! 140: [
! 141: {"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 142: ]
! 143: ]
! 144:
! 145: 1.3
! 146: [
! 147: [
! 148: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 149: ],
! 150: [
! 151: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 152: ],
! 153: [
! 154: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
! 155: ],
! 156: [
! 157: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 158: ],
! 159: [
! 160: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 161: ],
! 162: [
! 163: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 164: ],
! 165: [
! 166: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
! 167: ],
! 168: [
! 169: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 170: ]
! 171: ]
! 172:
! 173: 1.4
! 174: [
! 175: [
! 176: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 177: ],
! 178: [
! 179: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 180: ],
! 181: [
! 182: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
! 183: ],
! 184: [
! 185: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 186: ],
! 187: [
! 188: {"0":"0","2+2":"4"}
! 189: ]
! 190: ]
! 191:
! 192: 1.5
! 193: [
! 194: [
! 195: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 196: ],
! 197: [
! 198: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 199: ],
! 200: [
! 201: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 202: ]
! 203: ]
! 204:
! 205: 1.6
! 206: [
! 207: [
! 208: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 209: ],
! 210: [
! 211: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 212: ],
! 213: [
! 214: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
! 215: ],
! 216: [
! 217: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 218: ],
! 219: [
! 220: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 221: ]
! 222: ] - minor bug: limit for last query only
! 223:
! 224: 1.7
! 225: [
! 226: [
! 227: {"weigth":"5","food":"milk"}
! 228: ],
! 229: [
! 230: {"weigth":"10","food":"bone"}
! 231: ],
! 232: [
! 233: {"weigth":"1","food":"grain"}
! 234: ],
! 235: [
! 236: {"weigth":"1","food":"grain"}
! 237: ],
! 238: [
! 239: {"weigth+10":"15","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 240: ],
! 241: [
! 242: {"weigth+10":"20","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 243: ],
! 244: [
! 245: {"weigth+10":"11","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
! 246: ],
! 247: [
! 248: {"weigth+10":"11","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 249: ]
! 250: ]
! 251:
! 252: 1.8
! 253: [
! 254: {
! 255: "weigth":"5",
! 256: "food":"milk"
! 257: },
! 258: {
! 259: "weigth":"10",
! 260: "food":"bone"
! 261: },
! 262: {
! 263: "weigth":"1",
! 264: "food":"grain"
! 265: },
! 266: {
! 267: "weigth":"1",
! 268: "food":"grain"
! 269: },
! 270: {
! 271: "weigth+10":"15",
! 272: "pet":"cat",
! 273: "food":"milk",
! 274: "aggressive":"'very'",
! 275: "weigth":"5"
! 276: },
! 277: {
! 278: "weigth+10":"20",
! 279: "pet":"dog",
! 280: "food":"bone",
! 281: "aggressive":"\"never\"",
! 282: "weigth":"10"
! 283: },
! 284: {
! 285: "weigth+10":"11",
! 286: "pet":"hamster",
! 287: "food":"grain",
! 288: "aggressive":"",
! 289: "weigth":"1"
! 290: },
! 291: {
! 292: "weigth+10":"11",
! 293: "pet":"parrot",
! 294: "food":"grain",
! 295: "aggressive":"alwayws",
! 296: "weigth":"1"
! 297: }
! 298: ]
! 299:
! 300: 1.9
! 301: [
! 302: {
! 303: "0":"0",
! 304: "pet":"cat",
! 305: "food":"milk",
! 306: "aggressive":"'very'",
! 307: "weigth":"5"
! 308: },
! 309: {
! 310: "0":"0",
! 311: "pet":"dog",
! 312: "food":"bone",
! 313: "aggressive":"\"never\"",
! 314: "weigth":"10"
! 315: },
! 316: {
! 317: "0":"0",
! 318: "pet":"hamster",
! 319: "food":"grain",
! 320: "aggressive":"",
! 321: "weigth":"1"
! 322: },
! 323: {
! 324: "0":"0",
! 325: "pet":"parrot",
! 326: "food":"grain",
! 327: "aggressive":"alwayws",
! 328: "weigth":"1"
! 329: },
! 330: {
! 331: "0":"0",
! 332: "2+2":"4"
! 333: }
! 334: ]
! 335: 1.10
! 336: [
! 337: {
! 338: "0":"0",
! 339: "2+2":"4"
! 340: },
! 341: {
! 342: "0":"0",
! 343: "pet":"cat",
! 344: "food":"milk",
! 345: "aggressive":"'very'",
! 346: "weigth":"5"
! 347: },
! 348: {
! 349: "0":"0",
! 350: "pet":"dog",
! 351: "food":"bone",
! 352: "aggressive":"\"never\"",
! 353: "weigth":"10"
! 354: },
! 355: {
! 356: "0":"0",
! 357: "pet":"hamster",
! 358: "food":"grain",
! 359: "aggressive":"",
! 360: "weigth":"1"
! 361: },
! 362: {
! 363: "0":"0",
! 364: "pet":"parrot",
! 365: "food":"grain",
! 366: "aggressive":"alwayws",
! 367: "weigth":"1"
! 368: }
! 369: ]
! 370:
! 371: 1.11
! 372: [
! 373: [
! 374: {"0":"0","food":"milk"}
! 375: ],
! 376: [
! 377: {"0":"0","food":"bone"}
! 378: ],
! 379: [
! 380: {"0":"0","food":"grain"}
! 381: ],
! 382: [
! 383: {"0":"0","food":"grain"}
! 384: ],
! 385: [
! 386: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 387: ],
! 388: [
! 389: {"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 390: ],
! 391: [
! 392: {"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
! 393: ],
! 394: [
! 395: {"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 396: ]
! 397: ]
! 398: 1.12
! 399: [
! 400: [
! 401: {"0":"0","food":"milk"}
! 402: ],
! 403: [
! 404: {"0":"0","food":"bone"}
! 405: ],
! 406: [
! 407: {"0":"0","food":"grain"}
! 408: ],
! 409: [
! 410: {"0":"0","food":"grain"}
! 411: ],
! 412: [
! 413: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 414: ],
! 415: [
! 416: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 417: ],
! 418: [
! 419: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"}
! 420: ],
! 421: [
! 422: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 423: ]
! 424: ]
! 425:
! 426:
! 427: basic tests sparse
! 428: 3.1
! 429: {
! 430: "1":[
! 431: {"key":"1","pet":"hamster"},
! 432: {"key":"1","pet":"parrot"}
! 433: ],
! 434: "5":[
! 435: {"key":"5","pet":"cat"}
! 436: ],
! 437: "10":[
! 438: {"key":"10","pet":"dog"}
! 439: ]
! 440: }
! 441:
! 442: 3.2
! 443: {
! 444: "1":"hamster",
! 445: "5":"cat",
! 446: "10":"dog"
! 447: }
! 448:
! 449:
! 450:
! 451: 3.3
! 452: {
! 453: "1":{
! 454: "pet":"parrot",
! 455: "food":"grain",
! 456: "aggressive":"alwayws",
! 457: "weigth":"1"
! 458: },
! 459: "5":{
! 460: "pet":"cat",
! 461: "food":"milk",
! 462: "aggressive":"'very'",
! 463: "weigth":"5"
! 464: },
! 465: "10":{
! 466: "pet":"dog",
! 467: "food":"bone",
! 468: "aggressive":"\"never\"",
! 469: "weigth":"10"
! 470: }
! 471: }
! 472:
! 473: 3.4
! 474: {
! 475: "1":[
! 476: {"weigth":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 477: ],
! 478: "5":[
! 479: {"weigth":"5","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 480: ],
! 481: "10":[
! 482: {"weigth":"10","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 483: ]
! 484: }
! 485:
! 486: 3.5
! 487: {
! 488: "1":"grain",
! 489: "5":"milk",
! 490: "10":"bone"
! 491: }
! 492:
! 493: 3.6
! 494:
! 495: Exception type: sql.execute,
! 496: Source: select weigth, * from pets,
! 497: Comment: only 2 columns allowed for $.type[string] and $.sparse(true)
! 498:
! 499:
! 500: 3.7.
! 501: {
! 502: "10":[
! 503: {"weigth":"10","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 504: ]
! 505: }
! 506:
! 507: 3.8
! 508:
! 509: Exception type: sql.execute,
! 510: Source: select '1', pet from pets,
! 511: Comment: duplicate key
! 512:
! 513:
! 514: 3.9
! 515: {
! 516: "1":{
! 517: "pet":"parrot"
! 518: },
! 519: "5":{
! 520: "pet":"cat"
! 521: },
! 522: "10":{
! 523: "pet":"dog"
! 524: }
! 525: }
! 526:
! 527:
! 528:
! 529:
! 530:
! 531:
! 532: multi statements tests
! 533:
! 534: 1.2
! 535: {
! 536: "0":[
! 537: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
! 538: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
! 539: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 540: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 541: ],
! 542: "1":[
! 543: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
! 544: {"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
! 545: {"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 546: {"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 547: ]
! 548: }
! 549:
! 550: 1.3
! 551: {
! 552: "0":[
! 553: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
! 554: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
! 555: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 556: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"},
! 557: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
! 558: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
! 559: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 560: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 561: ]
! 562: }
! 563:
! 564: 1.4
! 565: {
! 566: "0":[
! 567: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
! 568: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
! 569: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 570: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"},
! 571: {"0":"0","pet":"4"}
! 572: ]
! 573: }
! 574:
! 575: 1.5
! 576: {
! 577: "0":[
! 578: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
! 579: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 580: ],
! 581: "1":[
! 582: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 583: ]
! 584: }
! 585:
! 586: 1.6
! 587: {
! 588: "0":[
! 589: {"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
! 590: {"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
! 591: {"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 592: {"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 593: ],
! 594: "1":[
! 595: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 596: ]
! 597: } - minor bug: limit for last query only
! 598:
! 599: 1.7
! 600: {
! 601: "1":[
! 602: {"weigth":"1","food":"grain"},
! 603: {"weigth":"1","food":"grain"}
! 604: ],
! 605: "5":[
! 606: {"weigth":"5","food":"milk"}
! 607: ],
! 608: "10":[
! 609: {"weigth":"10","food":"bone"}
! 610: ],
! 611: "11":[
! 612: {"weigth+10":"11","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 613: {"weigth+10":"11","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 614: ],
! 615: "15":[
! 616: {"weigth+10":"15","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
! 617: ],
! 618: "20":[
! 619: {"weigth+10":"20","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
! 620: ]
! 621: }
! 622:
! 623: 1.8
! 624: {
! 625: "1":{
! 626: "food":"grain"
! 627: },
! 628: "5":{
! 629: "food":"milk"
! 630: },
! 631: "10":{
! 632: "food":"bone"
! 633: },
! 634: "11":{
! 635: "pet":"hamster",
! 636: "food":"grain",
! 637: "aggressive":"",
! 638: "weigth":"1"
! 639: },
! 640: "15":{
! 641: "pet":"cat",
! 642: "food":"milk",
! 643: "aggressive":"'very'",
! 644: "weigth":"5"
! 645: },
! 646: "20":{
! 647: "pet":"dog",
! 648: "food":"bone",
! 649: "aggressive":"\"never\"",
! 650: "weigth":"10"
! 651: }
! 652: }
! 653:
! 654: 1.9
! 655: {
! 656: "0":{
! 657: "pet":"cat",
! 658: "food":"milk",
! 659: "aggressive":"'very'",
! 660: "weigth":"5"
! 661: }
! 662: }
! 663: 1.10
! 664: {
! 665: "0":{
! 666: "2+2":"4"
! 667: }
! 668: }
! 669:
! 670: 1.11
! 671: {
! 672: "0":[
! 673: {"0":"0","food":"milk"},
! 674: {"0":"0","food":"bone"},
! 675: {"0":"0","food":"grain"},
! 676: {"0":"0","food":"grain"}
! 677: ],
! 678: "1":[
! 679: {"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
! 680: {"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
! 681: {"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
! 682: {"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
! 683: ]
! 684: }
! 685: 1.12
! 686: {
! 687: "0":[
! 688: {"0":"0","food":"milk"},
! 689: {"0":"0","food":"bone"},
! 690: {"0":"0","food":"grain"},
! 691: {"0":"0","food":"grain"},
! 692: {"0":"0","food":"cat","2":"milk","3":"'very'","4":"5"},
! 693: {"0":"0","food":"dog","2":"bone","3":"\"never\"","4":"10"},
! 694: {"0":"0","food":"hamster","2":"grain","3":"","4":"1"},
! 695: {"0":"0","food":"parrot","2":"grain","3":"alwayws","4":"1"}
! 696: ]
! 697: }
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