Return to 388-sql.processed CVS log

Up to [parser3project] / parser3 / tests / results

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

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