Hello,
Your query uses index, which is correct (it contains unique values).
Try to run this query on partially restored database.
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
Hi,
We use Firebird 2.5.1 on Linux 64 bit
Firebird fails to restore because of a unique constraint( see
Your query needs an aggregate field. Count.
Alan
On Oct 24, 2012 1:49 PM, sir_wally_lewis rgilland1...@gmail.com wrote:
Hi,
We use Firebird 2.5.1 on Linux 64 bit
Firebird fails to restore because of a unique constraint( see below ).
However when interrogating the data, no duplicate is
Hi,
We use Firebird 2.5.1 on Linux 64 bit
Firebird fails to restore because of a unique constraint( see below ).
However when interrogating the data, no duplicate is found. ( see below SQL,
unique key is on the grouped by fields )
How can this be?
Kind Regards,
Robert.
SELECT ID_VN,