Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | In the CLI, always "dump" the sqlite_sequence table last. Ticket #3867 (CVS 6663) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | a0028d4808275cb1d020d56344d90b2a04603f4d |
| User & Date: | drh 2009-05-21 14:51:03 |
References
|
2017-08-28
| ||
| 10:57 | • New ticket [02f0f4c5] The ".dump" comman crashes following PRAGMA empty_result_callbacks=1. artifact: db4451b8 user: drh | |
Context
|
2009-05-21
| ||
| 15:15 | In the CLI in the ".dump" command, do not attempt to clear the sqlite_sequence table until the first row of content of that table is seen. Ticket #3867 (CVS 6664) check-in: bedd5ad1 user: drh tags: trunk | |
| 14:51 | In the CLI, always "dump" the sqlite_sequence table last. Ticket #3867 (CVS 6663) check-in: a0028d48 user: drh tags: trunk | |
| 04:42 | Add conditional 'extern "C"' block to sqlite3async.h. Ticket #3866. (CVS 6662) check-in: e4d1b117 user: danielk1977 tags: trunk | |
Changes
Changes to src/shell.c.
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
....
2076
2077
2078
2079
2080
2081
2082
2083
2084
2085
2086
2087
2088
2089
2090
|
** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains code to implement the "sqlite" command line ** utility for accessing SQLite databases. ** ** $Id: shell.c,v 1.207 2009/03/16 10:59:44 drh Exp $ */ #if defined(_WIN32) || defined(WIN32) /* This needs to come before any includes for MSVC compiler */ #define _CRT_SECURE_NO_WARNINGS #endif #include <stdlib.h> ................................................................................ open_db(p); fprintf(p->out, "BEGIN TRANSACTION;\n"); p->writableSchema = 0; sqlite3_exec(p->db, "PRAGMA writable_schema=ON", 0, 0, 0); if( nArg==1 ){ run_schema_dump_query(p, "SELECT name, type, sql FROM sqlite_master " "WHERE sql NOT NULL AND type=='table'", 0 ); run_table_dump_query(p->out, p->db, "SELECT sql FROM sqlite_master " "WHERE sql NOT NULL AND type IN ('index','trigger','view')" ); }else{ int i; |
|
|
>
>
>
>
|
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
....
2076
2077
2078
2079
2080
2081
2082
2083
2084
2085
2086
2087
2088
2089
2090
2091
2092
2093
2094
|
** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains code to implement the "sqlite" command line ** utility for accessing SQLite databases. ** ** $Id: shell.c,v 1.208 2009/05/21 14:51:03 drh Exp $ */ #if defined(_WIN32) || defined(WIN32) /* This needs to come before any includes for MSVC compiler */ #define _CRT_SECURE_NO_WARNINGS #endif #include <stdlib.h> ................................................................................ open_db(p); fprintf(p->out, "BEGIN TRANSACTION;\n"); p->writableSchema = 0; sqlite3_exec(p->db, "PRAGMA writable_schema=ON", 0, 0, 0); if( nArg==1 ){ run_schema_dump_query(p, "SELECT name, type, sql FROM sqlite_master " "WHERE sql NOT NULL AND type=='table' AND name!='sqlite_sequence'", 0 ); run_schema_dump_query(p, "SELECT name, type, sql FROM sqlite_master " "WHERE name=='sqlite_sequence'", 0 ); run_table_dump_query(p->out, p->db, "SELECT sql FROM sqlite_master " "WHERE sql NOT NULL AND type IN ('index','trigger','view')" ); }else{ int i; |