Subject | Re: [firebird-support] Re: Corrupted primary key |
---|---|
Author | Alec Swan |
Post date | 2010-07-27T19:10:41Z |
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:
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:
>[Non-text portions of this message have been removed]
>
> 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
>
>