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

Reply via email to