On Sat, 9 Feb 2008 23:51:03 +1100, you wrote: >Following up: >> This also says that SQLite will accept a single quoted literal as an >> identifier in certain situations. I'm not aware of any other >> database that used single quotes that way, but I'm sure there was >> one somewhere along the line. > >It is a pain that SQLite accepts single quoted identifiers. It is >worse and, I suggest, a bug that SQLite also _creates_ single quoted >identifiers after when renaming a table. > >eg: > >create table MyTable( MyField ); >alter table MyTable rename to MyNewTable; >select SQL from SQLite_Master; > >which gives: > >CREATE TABLE 'MyNewTable'( MyField ) > >SQLite should instead use the quotes (if any) used in the alter table >command. > >Tom >BareFeet
Reproduced with v3.5.4. I would say that's a bug. You could open a bug ticket for it (after checking the most recent version still behaves like that). -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
