sqllogictest
Check-in [fb12af96c2]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix aggregate function evidence tests to work with the scan-by-index optimization.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: fb12af96c24a3f9aaab2d8de9768c341e73aca04
User & Date: drh 2012-12-05 15:02:03
Context
2012-12-05
15:03
Pull in an SQLite amalgamation 3.7.15 beta. check-in: 13409d2824 user: drh tags: trunk
15:02
Fix aggregate function evidence tests to work with the scan-by-index optimization. check-in: fb12af96c2 user: drh tags: trunk
04:43
Improve the ability to compile and test on Windows using MinGW. check-in: b5fbadd16e user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/evidence/slt_lang_aggfunc.test.

    52     52   
    53     53   query I nosort
    54     54   SELECT max(DISTINCT x) FROM t1
    55     55   ----
    56     56   1
    57     57   
    58     58   query T nosort
    59         -SELECT group_concat(DISTINCT x) FROM t1
           59  +SELECT group_concat(DISTINCT x) FROM t1 NOT INDEXED
    60     60   ----
    61     61   1,0
    62     62   
    63     63   
    64     64   # EVIDENCE-OF: R-00171-59428 In such cases, duplicate elements are
    65     65   # filtered before being passed into the aggregate function.
    66     66   
................................................................................
   232    232   SELECT count(DISTINCT *) FROM t1 WHERE y='false'
   233    233   
   234    234   
   235    235   # EVIDENCE-OF: R-56088-25150 The group_concat() function returns a
   236    236   # string which is the concatenation of all non-NULL values of X.
   237    237   
   238    238   query T nosort
   239         -SELECT group_concat(x) FROM t1
          239  +SELECT group_concat(x) FROM t1 NOT INDEXED
   240    240   ----
   241    241   1,0,2,2
   242    242   
   243    243   query T nosort
   244         -SELECT group_concat(DISTINCT x) FROM t1
          244  +SELECT group_concat(DISTINCT x) FROM t1 NOT INDEXED
   245    245   ----
   246    246   1,0,2
   247    247   
   248    248   
   249    249   # EVIDENCE-OF: R-08600-21007 If parameter Y is present then it is used
   250    250   # as the separator between instances of X.
   251    251   
   252    252   query T nosort
   253         -SELECT group_concat(x,':') FROM t1
          253  +SELECT group_concat(x,':') FROM t1 NOT INDEXED
   254    254   ----
   255    255   1:0:2:2
   256    256   
   257    257   # TBD: DISTINCT can only be used with single parameters
   258    258   statement error
   259    259   SELECT group_concat(DISTINCT x,':') FROM t1
   260    260   
   261    261   
   262    262   # EVIDENCE-OF: R-39910-14723 A comma (",") is used as the separator if Y
   263    263   # is omitted.
   264    264   
   265    265   query T nosort
   266         -SELECT group_concat(x) FROM t1
          266  +SELECT group_concat(x) FROM t1 NOT INDEXED
   267    267   ----
   268    268   1,0,2,2
   269    269   
   270    270   query T nosort
   271         -SELECT group_concat(DISTINCT x) FROM t1
          271  +SELECT group_concat(DISTINCT x) FROM t1 NOT INDEXED
   272    272   ----
   273    273   1,0,2
   274    274   
   275    275   
   276    276   # EVIDENCE-OF: R-52585-35928 The max() aggregate function returns the
   277    277   # maximum value of all values in the group.
   278    278   
................................................................................
   489    489   query R nosort
   490    490   SELECT total(x) FROM t1
   491    491   ----
   492    492   
   493    493   query R nosort
   494    494   SELECT total(DISTINCT x) FROM t1
   495    495   ----
   496         -
   497         -