fix: unique index name for bucket_id index

Summary

Unique index name for bucket_id index in format {table_name}_bucket_id

---

• Close #604 (closed)
• Changes should be cherry-picked to 24.2: no
• Docs follow-up: not necessary

added bug label

requested review from @darthunix

assigned to @kusancho

Please, add some tests to test_sql.py:

1. create two sharded tables with arbitrary names
2. check that you can't manually create an index with the same name as was created for buckets of some existing table

added 7 commits

• 778ded38...6d851115 - 5 commits from branch master
• 226c5f1f - fix: unique index name for bucket_id index
• cf4f2f5b - tests: test_sql

Compare with previous version

added 63 commits

• cf4f2f5b...e041d7d1 - 61 commits from branch master
• 12b2be76 - fix: unique index name for bucket_id index
• 6a1c1799 - tests: test_sql

Compare with previous version

approved this merge request

added 1 commit

• 6bc5eac9 - tests: test_sql

Compare with previous version

added 3 commits

• 7f8d1bde - 1 commit from branch master
• 834f8cf3 - fix: unique index name for bucket_id index
• eb3f6b0c - tests: test_sql

Compare with previous version

added 2 commits

• 12b2be76 - fix: unique index name for bucket_id index
• a7f76e43 - tests: test_sql

Compare with previous version

added 1 commit

• f0700cdd - fix: unique index name for bucket_id index

Compare with previous version

added 8 commits

• f0700cdd...cf008582 - 7 commits from branch master
• f8f0743b - fix: unique index name for bucket_id index

Compare with previous version

enabled an automatic merge when the pipeline for f8f0743b succeeds

merged

mentioned in issue #958 (closed)