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

2010-11-07 Thread ぽぽんGM
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(

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

2010-11-04 Thread 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