Subject Re: [firebird-support] Re: Corrupted primary key
Author Alec Swan
Hello Ann,

Where can I find the description of IBPhoenix commercial support services
and pricing? What do I need to do to request such a service?

Thanks,

Alec

On Tue, Jul 27, 2010 at 10:34 AM, Ann W. Harrison
<aharrison@...>wrote:

>
>
> Alec Swan wrote:
>
> > We are using Firebird 2.1.2 in Embedded mode with Jaybird JDBC driver
> 2.1.6
> > on Windows XP.
> >
> > Let me clarify the problem with primary key index corruption. We have a
> > query which returns primary key values from a specific table. This query
> > returns 2 rows. We have another query which returns all values from the
> same
> > table using the first query as a sub-query to filter rows based on
> primary
> > key values. This query returns 1 row. Which is incorrect.
> >
> > If we drop and re-create the primary key on the table and re-run both
> > queries they consistently return 2 rows each. I have the database and
> > queries which I can send to you. The database contains production
> customer
> > data, so I wonder if I could send it to you in a private email?
> >
>
> Much better description ... unfortunately, I'm going on vacation soon
> and can't help you immediately. Perhaps one of the current developers
> will speak up.
>
> Best regards,
>
> Ann
>
>


[Non-text portions of this message have been removed]