Automigrate error caused by indexes while using dynamic table name

[neeroz]

GORM Playground Link

go-gorm/playground#386

Description

I am trying to migrate tables using dynamic table name. All these tables have different name but the same schema. I am using scopes to generate the dynamic table name.

The tables are created with the dynamic table name but the indexes are not created as it should.

Struct
type NewUser struct {
gorm.Model
Name string gorm:"index"
City string gorm:"index"
Table string gorm:"-"
}

tableNameFormat newuser_%x

tableName := []string{"a","b","c"}

table created successfully newuser_a, newuser_b,newuser_c

When using scopes to generate the dynamic table name, the indexes are formatted as idx_new_users_name for all the tables and thus error -> Failed, got error: index idx_new_users_name already exists

To Reproduce Error: ./test.sh

Expected Output:

While doing migration, the tables with dynamic names should be created along with its indexes.

[ghost]

@neeroz hello,this may be a problem with sqlite,It does not support indexes with the same name.

[neeroz]

@longlihale This problem persists with postgresql as well. The index format idx_<table-name>_<column-name> is not being generated dynamically (table-name) which causes error. I can confirm this error on sqlite and postgresql

.

[ghost]

@neeroz thanks,this is bug and will be fixed later.

[xwjdsh]

Sorry, I tried to solve this problem, but it led to more mistakes, at last, I have no way... (I should make a pull request after full testing)

[ghost]

Sorry, I tried to solve this problem, but it led to more mistakes, at last, I have no way... (I should make a pull request after full testing)

because the problem happen in Schema result in it have some tough....