On Fri, Mar 17, 2017 at 12:00 AM, Richard Hipp <d...@sqlite.org> wrote:
> On 3/16/17, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote: > > In sqlite_master I see quite a lot of "sql_autoindex" indexes. Do > > these auto indexes consume the same RAM as explicit indexes? > > Yes. Those indexes are implementing UNIQUE constraints. > Richard, why is SQLite ignoring an attempt to giving these an explicit name? --DD C:\Users\ddevienne>sqlite3 SQLite version 3.17.0 2017-02-13 16:02:40 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table t (id unique); sqlite> select * from sqlite_master; table|t|t|2|CREATE TABLE t (id unique) index|sqlite_autoindex_t_1|t|3| sqlite> sqlite> drop table t; sqlite> select * from sqlite_master; sqlite> sqlite> create table t (id constraint u1 unique); sqlite> select * from sqlite_master; table|t|t|2|CREATE TABLE t (id constraint u1 unique) index|sqlite_autoindex_t_1|t|3| sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
