Unique index naming conflict with atlas

[pzeinlinger]

• [X ] The issue is present in the latest release.
• [ X] I have searched the issues of this repository and believe that this is not a duplicate.

Current Behavior 😯

Using atlas as migration engine leads to a naming conflict of columns with unique constraints using sqlite. Migrations with Postgres work as expected.

Output of debug client:

2022/03/22 19:20:01 driver.Tx(8f23a6a6-c886-4be1-be6d-067742351aef): started
2022/03/22 19:20:01 Tx(8f23a6a6-c886-4be1-be6d-067742351aef).Query: query=PRAGMA foreign_keys args=[]
2022/03/22 19:20:01 Tx(8f23a6a6-c886-4be1-be6d-067742351aef).Query: query=SELECT sqlite_version(), foreign_keys from pragma_foreign_keys args=[]
2022/03/22 19:20:01 Tx(8f23a6a6-c886-4be1-be6d-067742351aef).Query: query=SELECT name FROM pragma_collation_list() args=[]
2022/03/22 19:20:01 Tx(8f23a6a6-c886-4be1-be6d-067742351aef).Query: query=SELECT `name`, `file` FROM pragma_database_list() WHERE name IN (?) args=[main]
2022/03/22 19:20:01 Tx(8f23a6a6-c886-4be1-be6d-067742351aef).Query: query=SELECT `name`, `sql` FROM sqlite_master WHERE `type` = 'table' AND `name` NOT LIKE 'sqlite_%' AND name IN (?, ?) args=[groups users]
2022/03/22 19:20:01 Tx(8f23a6a6-c886-4be1-be6d-067742351aef).Exec: query=CREATE TABLE `groups` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `name` text NOT NULL) args=[]
2022/03/22 19:20:01 Tx(8f23a6a6-c886-4be1-be6d-067742351aef).Exec: query=CREATE UNIQUE INDEX `name` ON `groups` (`name`) args=[]
2022/03/22 19:20:01 Tx(8f23a6a6-c886-4be1-be6d-067742351aef).Exec: query=CREATE TABLE `users` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `name` text NOT NULL) args=[]
2022/03/22 19:20:01 Tx(8f23a6a6-c886-4be1-be6d-067742351aef).Exec: query=CREATE UNIQUE INDEX `name` ON `users` (`name`) args=[]
2022/03/22 19:20:01 Tx(8f23a6a6-c886-4be1-be6d-067742351aef): rollbacked
2022/03/22 19:20:01 failed creating schema resources: sql/schema: create index "name" to table: "users": index name already exists
exit status 1

db: sqlite

Expected Behavior 🤔

Ent's old migration engine used sqlite's auto index

CREATE TABLE `users`(`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL, `name` varchar(255) UNIQUE NOT NULL)

Steps to Reproduce 🕹

Minimal Reproducible Example

Your Environment 🌎

Tech	Version
Go	1.18.0
Ent	v0.10.2-0.20220321093754-edd968490ea2
Atlas	v0.3.8-0.20220314111236-b2171e04c5b2
Database	SQLite
Driver	https://github.com/mattn/go-sqlite3

[pzeinlinger]

Still present on master as of today. I updated the demo repo.

[a8m]

Thanks for reporting this @pzeinlinger 🙏

Fixed with #2433