Return to 388-sql.processed CVS log

Up to [parser3project] / parser3 / tests / results

Annotation of parser3/tests/results/388-sql.processed, revision 1.6

1.1       moko        1: Content-Type: text/html
1.6     ! moko        2: Content-Length: 3188
1.1       moko        3: 
                      4: 1. 2 + 2 = 4
                      5: 2. void
1.6     ! moko        6: 2.0 2.1 2.2 2.3 Type: sql.execute,
1.4       moko        7: Source: select * from pets,
1.1       moko        8: Comment: must return nothing
                      9: 2.4 Type: parser.runtime,
                     10: Source: sql,
                     11: Comment: called with invalid option
                     12: 2.5 Type: sql.execute,
                     13: Source: query,
1.6     ! moko       14: Comment: bind variables not supported (yet)
        !            15: 2.6 Multiple queries: 2.7 Exception in second query: Type: sql.execute,
        !            16: Source: delete from pets where pet='' ; select 2+2 ,
        !            17: Comment: must return nothing
1.1       moko       18: 3. int/double
                     19: 3.1 2 int
                     20: 3.2 Type: parser.runtime,
                     21: Source: sql,
                     22: Comment: produced no result, but no default option specified
                     23: 3.3 1
                     24: 3.4 -2 double
                     25: 3.5 Type: parser.runtime,
                     26: Source: sql,
                     27: Comment: produced no result, but no default option specified
                     28: 3.6 1
                     29: 4. hash
                     30: 4.1 {
                     31:        "cat":{
                     32:                "food":"milk",
                     33:                "aggressive":"'very'",
                     34:                "weigth":"5"
                     35:        },
                     36:        "dog":{
                     37:                "food":"bone",
                     38:                "aggressive":"\"never\"",
                     39:                "weigth":"10"
                     40:        },
                     41:        "parrot":{
                     42:                "food":"grain",
                     43:                "aggressive":"alwayws",
                     44:                "weigth":"1"
                     45:        }
                     46: }
                     47: 4.2 {
                     48:        "cat":[
                     49:                {"pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
                     50:        ],
                     51:        "dog":[
                     52:                {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
                     53:        ],
                     54:        "parrot":[
                     55:                {"pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
                     56:        ]
                     57: }
                     58: 4.3 {
                     59:        "cat":"milk",
                     60:        "dog":"bone",
                     61:        "parrot":"grain"
                     62: }
1.4       moko       63: 4.4 Type: sql.execute,
                     64: Source: select * from pets,
1.1       moko       65: Comment: only 2 columns allowed for $.type[string].
                     66: 4.5. {
                     67:        "dog":[
                     68:                {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
                     69:        ]
                     70: }
1.5       moko       71: 4.6 Type: sql.execute,
                     72: Source: select 'dup', pet from pets,
                     73: Comment: duplicate key
1.1       moko       74: 5. table
                     75: 5.1 [
                     76:        {"pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
                     77:        {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
                     78:        {"pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
                     79: ]
                     80: 5.2. [
                     81:        {"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
                     82: ]
1.3       moko       83: 5.3 Type: sql.execute,
                     84: Source: select * from pets,
1.6     ! moko       85: Comment: bind variables not supported (yet)
1.3       moko       86: 5.4 Type: parser.runtime,
                     87: Source: sql,
                     88: Comment: called with invalid option
1.1       moko       89: 6. file
                     90: 6.1 {
                     91:        "class":"file",
                     92:        "name":"test.txt",
                     93:        "size":6,
                     94:        "mode":"binary",
                     95:        "content-type":"text\/plain",
                     96:        "text":"'very'"
                     97: }
                     98: 6.2 {
                     99:        "class":"file",
                    100:        "name":"unknown",
                    101:        "size":7,
                    102:        "mode":"binary",
                    103:        "content-type":"unknown",
                    104:        "text":"\"never\""
                    105: }
1.4       moko      106: 6.3 Type: sql.execute,
                    107: Source: select * from pets,
1.1       moko      108: Comment: result must contain not more then 3 columns
                    109: 6.4 Type: parser.runtime,
                    110: Source: sql,
                    111: Comment: produced no result
                    112: 6.5 {
                    113:        "class":"file",
                    114:        "name":"1",
                    115:        "size":1,
                    116:        "mode":"binary",
                    117:        "content-type":"1",
                    118:        "text":"1"
                    119: } - bug!
1.4       moko      120: 6.6 Type: sql.execute,
                    121: Source: select 1,2 from pets,
1.1       moko      122: Comment: result must not contain more then one row, three columns
                    123: 6.7 Type: parser.runtime,
                    124: Source: sql,
                    125: Comment: called with invalid option
1.6     ! moko      126: 6.8 \"\'test\'\"
1.2       moko      127: 7. string
1.4       moko      128: 7.1 Type: sql.execute,
                    129: Source: select * from pets,
1.2       moko      130: Comment: result must contain exactly one column
1.4       moko      131: 7.2 Type: sql.execute,
                    132: Source: select pet from pets,
1.2       moko      133: Comment: result must not contain more then one row
                    134: 7.3 Type: sql.execute,
                    135: Source: select 2+2,
1.6     ! moko      136: Comment: bind variables not supported (yet)
1.2       moko      137: 7.4 Type: parser.runtime,
                    138: Source: sql,
                    139: Comment: called with invalid option
                    140: 7.5 Type: parser.runtime,
                    141: Source: sql,
                    142: Comment: produced no result, but no default option specified
                    143: 7.6 "default"