/ Check-in [e90d5a55]
Login

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

Overview
Comment:Add a test to verify the sqlite3_column_name() interface returns the correct value when the query is of the form: "SELECT rowid,* FROM...". Ticket #3429. (CVS 5785)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: e90d5a5515f7096e247e6059cf77f8089ed90b2c
User & Date: drh 2008-10-09 15:56:46
Context
2008-10-09
17:57
New speed testing tools. (CVS 5786) check-in: 2d427746 user: drh tags: trunk
15:56
Add a test to verify the sqlite3_column_name() interface returns the correct value when the query is of the form: "SELECT rowid,* FROM...". Ticket #3429. (CVS 5785) check-in: e90d5a55 user: drh tags: trunk
15:56
Update the version number to 3.6.4. (CVS 5784) check-in: 4b973ac9 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.5 2008/09/13 01:20:15 drh Exp $
           16  +# $Id: colname.test,v 1.6 2008/10/09 15:56:46 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.
................................................................................
   299    299   do_test colname-6.18 {
   300    300     execsql2 {SELECT "[a]", max("[a]") AS m FROM t6}
   301    301   } {{[a]} 4 m 4}
   302    302   do_test colname-6.19 {
   303    303     execsql2 {SELECT "`a`", max([`a`]) AS m FROM t6}
   304    304   } {`a` 5 m 5}
   305    305   
          306  +
          307  +# Ticket #3429
          308  +# We cannot find anything wrong, but it never hurts to add another
          309  +# test case.
          310  +#
          311  +do_test colname-7.1 {
          312  +  db eval {
          313  +    CREATE TABLE t7(x INTEGER PRIMARY KEY, y);
          314  +    INSERT INTO t7 VALUES(1,2);
          315  +  }
          316  +  execsql2 {SELECT rowid, * FROM t7}
          317  +} {x 1 x 1 y 2}
          318  +
   306    319   finish_test