Return to 428-sql.html CVS log

Up to [parser3project] / parser3 / tests

Annotation of parser3/tests/428-sql.html, revision 1.6

1.1       moko        1: @USE
                      2: 388-sql.html
                      3: 
                      4: @main[]
                      5: 
                      6: ^connect[$SQL.drivers.connect]{
                      7:        ^prepare-data[]
                      8: 
                      9:        1.1 ^try-catch{ ^t[select pet from pets^;select food from pets] }
                     10: 
1.6     ! moko       11:        1.2 ^h[select 0,pets.* from pets^;select 1,pets.* from pets; $.type[table] $.distinct(true) ]
1.2       moko       12: 
1.6     ! moko       13:        1.3 ^h[select 0,pets.* from pets^;select 0,pets.* from pets; $.type[table] $.distinct(true) ]
1.2       moko       14: 
1.6     ! moko       15:        1.4 ^h[select 0,pets.* from pets^;select 0, 2+2; $.type[table] $.distinct(true) ]
1.2       moko       16: 
1.6     ! moko       17:        1.5 ^h[select 0,pets.* from pets limit 2^;delete from pets where pet=''^;select 1,pets.* from pets limit 1; $.type[table] $.distinct(true) ]
1.2       moko       18: 
1.6     ! moko       19:        1.6 ^h[select 0,pets.* from pets^;delete from pets where pet=''^;select 1,pets.* from pets; $.type[table] $.distinct(true) $.limit(1) ] - minor bug: limit for last query only
1.2       moko       20: 
1.6     ! moko       21:        1.7 ^h[select pet,food from pets^;select food,pets.* from pets; $.type[table] $.distinct(true)]
1.2       moko       22: 
1.6     ! moko       23:        1.8 ^h[select pet,food from pets^;select food,pets.* from pets;  $.distinct(true)]
1.3       moko       24: 
1.6     ! moko       25:        1.9 ^h[select 0,pets.* from pets^;select 0, 2+2; $.type[hash] $.distinct(true) ]
        !            26:        1.10 ^h[select 0, 2+2^;select 0,pets.* from pets; $.type[hash] $.distinct(true) ]
1.3       moko       27: 
1.6     ! moko       28:        1.11 ^h[select 0,food from pets^;select 1,pets.* from pets; $.type[table] $.distinct(true) ] - different structure for each query as key differs
        !            29:        1.12 ^h[select 0,food from pets^;select 0,pets.* from pets; $.type[table] $.distinct(true) ] - note: there are missed and numeric columns in second query, but it better then exception
1.1       moko       30: }