> 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 ?

but they all work fine for me. I don't use IB_SQL, just IBExpert and ISQL.
so doesn't they something more specific about IBO/IB_SQL and not fbserver?
Alan

>
> ----- 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