Hi Allen,

I use IB_SQL. Like I mentioned, a special combination of events
made up by how IB_SQL extracts the Metadata and than in
addition how the table was created. The interesting part is
that it also happens using FB1.5 and FB2.0, all Dialects.

I never noticed it with IBOConsole either. IBExpert, alike IB_SQL
now, may have a different approach or work around to extract
Metadata, but the original 'bug' fact remains. Why should the last
two examples work and the first one not ?

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


>> 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
>>
>>
>
> I can create this table and extract the metadata without error using
> IBExpert and ISQL.
> Are you sure you are not just using a script component in IBO to find this
> error?
> 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
>
>
>