/ Check-in [2472f6db]
Login

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

Overview
Comment:Add a test case for ticket #3893 and ticket #3894. (CVS 6705)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:2472f6db95cd537a908bdbbbbc41bad2bd987b2f
User & Date: drh 2009-06-02 15:47:38
Context
2009-06-02
16:06
Tweaks to vdbe.c to further reduce stack space requirements. (CVS 6706) check-in: 6f2aab3f user: drh tags: trunk
15:47
Add a test case for ticket #3893 and ticket #3894. (CVS 6705) check-in: 2472f6db user: drh tags: trunk
15:21
Add the vdbe-compress.tcl script which automatically refactors the sqlite3VdbeExec() routine to use less stack space. Use this script when constructing the amalgamation. (CVS 6704) check-in: 7f433918 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/colname.test.

     9      9   #
    10     10   #***********************************************************************
    11     11   # This file implements regression tests for SQLite library. 
    12     12   #
    13     13   # The focus of this file is testing how SQLite generates the names
    14     14   # of columns in a result set.
    15     15   #
    16         -# $Id: colname.test,v 1.6 2008/10/09 15:56:46 drh Exp $
           16  +# $Id: colname.test,v 1.7 2009/06/02 15:47:38 drh Exp $
    17     17   
    18     18   set testdir [file dirname $argv0]
    19     19   source $testdir/tester.tcl
    20     20   
    21     21   # Rules (applied in order):
    22     22   #
    23     23   # (1) If there is an AS clause, use it.
................................................................................
   311    311   do_test colname-7.1 {
   312    312     db eval {
   313    313       CREATE TABLE t7(x INTEGER PRIMARY KEY, y);
   314    314       INSERT INTO t7 VALUES(1,2);
   315    315     }
   316    316     execsql2 {SELECT rowid, * FROM t7}
   317    317   } {x 1 x 1 y 2}
          318  +
          319  +# Tickets #3893 and #3984.  (Same problem; independently reported)
          320  +#
          321  +do_test colname-8.1 {
          322  +  db eval {
          323  +    CREATE TABLE "t3893"("x");
          324  +    INSERT INTO t3893 VALUES(123);
          325  +    SELECT "y"."x" FROM (SELECT "x" FROM "t3893") AS "y";
          326  +  }
          327  +} {123}
   318    328   
   319    329   finish_test