Hello Alan,

After weeks of tracing and debugging, I found out
it fails only in a special sequence and brought it to
Jason's attention. I expect it might cause intermittent
problems somewhere else.

Hans

CREATE TABLE TEST (
A12345678901234 INTEGER NOT NULL
, B123456789012345 INTEGER NOT NULL
) ====> Fails .. Metadata extract fails with bogus error

CREATE TABLE TEST (
A12345678901234 INTEGER NOT NULL
, B12345678901234 INTEGER NOT NULL
) ====> Does not fail

CREATE TABLE TEST (
A123456789012345 INTEGER NOT NULL
, B12345678901234 INTEGER NOT NULL
) ====> Does not fail

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, January 20, 2007 7:52 PM
Subject: RE: [firebird-support] Re: Where to go or not to go


>> Hello Adam
>>
>> If of interest,
>> check the just releaed IBObjects Beta15 release notes.
>>
>> Best Regards
>> Hans
>>
>
> "I fixed/worked around a bug in Firebird that has to do with a bogus error
> when extracting metadata from a database. Seems the internal buffers get
> messed up after the first use of the SQLDA/SQLVAR buffers of the query to
> retreive the constraints information from the system tables. Simply
> unpreparing the cursor to get this data each time avoids the error. It
> doesn't run as fast, but at least it runs."
>
> I appreciate this, but I wonder if I would have expected the buffers to
> maintain integrity during these operations. I have a feeling that I would
> have expected to do a re-prepare anyway.
> Alan
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>