Issue with sqlite3 / import / strictly numerical table names

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Issue with sqlite3 / import / strictly numerical table names

Alan Kinder
It would appear to me that sqlite and sqlite3 are out-of-sync in respect of
the handling of tables with strictly numerical table names - please see the
following sqlite3  log demonstrating the problem:
------------------------------------------------------------------------------------------------
-- Loading resources from C:\Users\Kinder/.sqliterc
SQLite version 3.28.0 2019-04-16 19:49:53
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .sys type C:\\Users\\Kinder\\.sqliterc
.mode columns
.headers on
sqlite> create table "_666" (c1 TEXT, c2 TEXT);
sqlite> create table "666" (c1 TEXT, c2 TEXT);
sqlite> .tables
666   _666
sqlite> .mode csv
sqlite> .sys type file.csv
"A","B"
sqlite> .import "file.csv" "_666"
sqlite> select * from "_666";
c1,c2
A,B
sqlite> .import "file.csv" "666"
Error: near "666": syntax error
sqlite>
------------------------------------------------------------------------------------------------
Please feel free to contact me if you require additional information.
Regards,
Alan Kinder
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users