/ Check-in [395ab5fa]
Login

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

Overview
Comment:The "table_info" pragma reports unspecified column types as "numeric" instead of "text". Fix for ticket #174. (CVS 767)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 395ab5fac201a37d6eca833ffd6f58ac8a0121a2
User & Date: drh 2002-10-20 16:00:28
Context
2002-10-20
18:19
Rework the changes for ticket #176 (check-ins (760) and (761)) to be more consistent with the rest of the source code. (CVS 768) check-in: f50a177b user: drh tags: trunk
16:00
The "table_info" pragma reports unspecified column types as "numeric" instead of "text". Fix for ticket #174. (CVS 767) check-in: 395ab5fa user: drh tags: trunk
15:55
Export the sqlite_function_type function from windows DLLs. Ticket #173. (CVS 766) check-in: d5470dfe user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/build.c.

    21     21   **     COPY
    22     22   **     VACUUM
    23     23   **     BEGIN TRANSACTION
    24     24   **     COMMIT
    25     25   **     ROLLBACK
    26     26   **     PRAGMA
    27     27   **
    28         -** $Id: build.c,v 1.114 2002/09/25 19:04:07 drh Exp $
           28  +** $Id: build.c,v 1.115 2002/10/20 16:00:28 drh Exp $
    29     29   */
    30     30   #include "sqliteInt.h"
    31     31   #include <ctype.h>
    32     32   
    33     33   /*
    34     34   ** This routine is called when a new SQL statement is beginning to
    35     35   ** be parsed.  Check to see if the schema for the database needs
................................................................................
  2301   2301           { OP_ColumnName,  3, 0,       "notnull"},
  2302   2302           { OP_ColumnName,  4, 0,       "dflt_value"},
  2303   2303         };
  2304   2304         int i;
  2305   2305         sqliteVdbeAddOpList(v, ArraySize(tableInfoPreface), tableInfoPreface);
  2306   2306         sqliteViewGetColumnNames(pParse, pTab);
  2307   2307         for(i=0; i<pTab->nCol; i++){
         2308  +        char *zType;
  2308   2309           sqliteVdbeAddOp(v, OP_Integer, i, 0);
  2309   2310           sqliteVdbeAddOp(v, OP_String, 0, 0);
  2310   2311           sqliteVdbeChangeP3(v, -1, pTab->aCol[i].zName, P3_STATIC);
  2311   2312           sqliteVdbeAddOp(v, OP_String, 0, 0);
  2312   2313           sqliteVdbeChangeP3(v, -1, 
  2313         -           pTab->aCol[i].zType ? pTab->aCol[i].zType : "text", P3_STATIC);
         2314  +           pTab->aCol[i].zType ? pTab->aCol[i].zType : "numeric", P3_STATIC);
  2314   2315           sqliteVdbeAddOp(v, OP_Integer, pTab->aCol[i].notNull, 0);
  2315   2316           sqliteVdbeAddOp(v, OP_String, 0, 0);
  2316   2317           sqliteVdbeChangeP3(v, -1, pTab->aCol[i].zDflt, P3_STATIC);
  2317   2318           sqliteVdbeAddOp(v, OP_Callback, 5, 0);
  2318   2319         }
  2319   2320       }
  2320   2321     }else