SQLite Forum

Bad practice to open AND attach the same database?
Login
I imagine this has some nasty consequences:

```
sqlite> .open ./db/chinook.db
sqlite> attach database 'd:\sqlite32\db\chinook.db' as chin;
sqlite> .databases
main: D:\SQLite32\db\chinook.db r/w
chin: d:\sqlite32\db\chinook.db r/w
```

Clearly, it is <i>possible</i> to do this.

What are the likely consequences?