SQLite Forum

import mishandles table name
Login
Currently `.import file table` fails to respect namespaces:

```
sqlite3
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .mode csv
sqlite> .version
SQLite 3.34.1 2021-01-20 14:10:07 10e20c0b43500cfb9bbc0eaa061c57514f715d87238f4d835880cd846b9ealt1
zlib version 1.2.11
gcc-10.2.0
sqlite> .import summary_0.csv temp.summary
sqlite> .schema
CREATE TABLE IF NOT EXISTS "temp.summary"(
  "uid" TEXT,
  "seqid" TEXT,
  "accession" TEXT,
  "name" TEXT,
  "description" TEXT,
  "type" TEXT,
  "molecule_type" TEXT,
  "sequence_version" TEXT,
  "gi_number" TEXT,
  "cds_count" TEXT,
  "gene_count" TEXT,
  "rna_count" TEXT,
  "repeat_region_count" TEXT,
  "length" TEXT,
  "source" TEXT
);
sqlite> select * from temp.summary;
Error: no such table: temp.summary
sqlite> select * from "temp.summary";
9451451,NZ_CP071129.1,NZ_CP071129,NZ_CP071129,"Caballeronia sp. M1242 chromosome%2C complete genome",chromosome,"genomic DNA",1,"",2667,2739,72,0,2932255,"Caballeronia sp. M1242"
```

I would expect this to create the summary table in the temp namespace.