| # 2011 October 13 |
| # |
| # The author disclaims copyright to this source code. In place of |
| # a legal notice, here is a blessing: |
| # |
| # May you do good and not evil. |
| # May you find forgiveness for yourself and forgive others. |
| # May you share freely, never taking more than you give. |
| # |
| #*********************************************************************** |
| # This file implements regression tests for SQLite library. Specifically, |
| # it tests that ticket [fa7bf5ec94801e7e2030e41eefe5d9dd96eaacfd] has |
| # been resolved. |
| # |
| # The problem described by this ticket was that the sqlite3ExprCompare() |
| # function was saying that expressions (x='a') and (x='A') were identical |
| # because it was using sqlite3StrICmp() instead of strcmp() to compare string |
| # literals. That was causing the query optimizer for aggregate queries to |
| # believe that both count() operations were identical, and thus only |
| # computing the first count() and making a copy of the result for the |
| # second count(). |
| # |
| |
| set testdir [file dirname $argv0] |
| source $testdir/tester.tcl |
| |
| do_test tkt-fa7bf5ec-1 { |
| execsql { |
| CREATE TABLE t1(x); |
| INSERT INTO t1 VALUES ('a'); |
| INSERT INTO t1 VALUES ('A'); |
| INSERT INTO t1 VALUES ('A'); |
| SELECT count(CASE WHEN x='a' THEN 1 END), |
| count(CASE WHEN x='A' THEN 1 END) |
| FROM t1; |
| } |
| } {1 2} |
| |
| finish_test |