Closed
Description
For example:
auto storage = make_storage("db.sqlite",
make_index("idx_users_first_name", indexed_column(&User::first_name).desc()),
make_index("idx_users_first_name_2", indexed_column(&User::first_name).collate("BINARY").desc()),
make_index("idx_users_nr", indexed_column(&User::nr).desc()),
make_table("users",
make_column("id", &User::id, autoincrement(), primary_key()),
make_column("first_name", &User::first_name),
make_column("nr", &User::nr)
));
I'm getting:
CREATE INDEX IF NOT EXISTS 'idx_users_nr' ON 'users' ('nr')
CREATE INDEX IF NOT EXISTS 'idx_users_first_name_2' ON 'users' ('first_name')
CREATE INDEX IF NOT EXISTS 'idx_users_first_name' ON 'users' ('first_name')
The "descending order" and the "collate" aren't being included in the query.
I'm missing something?
I'm using v1.6 and compiling with Apple clang version 12.0.5