Re: [sqlite] sqlite.exe db_name .dump : It missed : table name is un quoted.(INSERT statement)

[ぽぽんＧＭ]

sqlite-2.8.17-47fee16ba9bd8ab2.diff
--- SQLite-47fee16ba9bd8ab2/src/shell.c
+++ SQLite-47fee16ba9bd8ab2/src/shell.c
@@ -421,7 +421,7 @@
p->zDestTable = 0;
}
if( zName==0 ) return;
- needQuote = !isalpha(*zName) && *zName!='_';
+ needQuote = *zName!='_';
for(i=n=0; zName[i]; i++, n++){
if( !isalnum(zName[i]) && zName[i]!='_' ){
needQuote = 1;
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite.exe db_name .dump : It missed : table name is un quoted.(INSERT statement)

[geefwfge201011]

sqlite.exe db_name .dump
It missed : table name is un quoted.(INSERT statement)
database conversion fails (version 2 to 3)

sqlite -version
2.8.17

- dump_test.sql
create table "where" (id INTEGER);
   INSERT INTO "where" VALUES(1);
---

@rem create database
sqlite.exe dump_test.db < dump_test.sql

sqlite.exe dump_test.db .dump > test1.sql
@rem test1.sql : missed : table name is un quoted.

sqlite.exe dump_test.db .dump | sqlite3.exe test_db3.db
@rem sqlite3.exe test_db3.db < test1.sql
@rem  error occures.
@rem  : syntax error
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users