search

zedalaye / fbclone

A wonderful tool to take care of your Firebird databases
33 stars 19 forks source link

Index creation order #7

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Have a table T1(A, B, ...) with a unique index on field A
2. Have a table T2(C, A, ...) with a foreign key pointing T1(A)
3. Run fbclone

What is the expected output? What do you see instead?
The unique index is used by the foreign key.
Because the foreing key is created prior to the unique index it fails saying 
than it doesn't find any suitable index.
It should create indexes in this order:
1. PK
2. UNIQUE <--- First
3. FK     <--- Second
4. INDEX
5. CHECK

What version of the product are you using? On what operating system?
Windows XP Firebird Client LI-V6.3.6.5026 Firebird 1.5
Linux (Ubuntu) Server LI-V1.5.6.5026 Firebird 1.5
fbclone ver. 2.1.4.0

Please provide any additional information below.

Original issue reported on code.google.com by duiliois...@gmail.com on 25 Oct 2012 at 8:20

GoogleCodeExporter commented 9 years ago 
Fixed in trunk. Don't forget to compile using very latest UIB trunk. Or wait 
for post 2.2.0 binaries.

Original comment by pierr...@gmail.com on 9 Nov 2012 at 3:09