Hello

Excuse me, I review the tests and find that the table name used includes an underscore.

I confirm the bug and the diagnostic from David.

I will post a patch this afternoon.

Regards
Blas Rodriguez Somoza.

----- Original Message -----
From: "Blas Rodriguez Somoza" <blas@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Wednesday, June 05, 2002 7:18 PM
Subject: Re: [Firebird-Java] Re: FBDatabaseMetaData and underscores


> Hello
>
> Which version of the driver are you using? and which FB dialect?.
>
> I run jDataMaster tests before the last commit and getColumns works OK, the tests include that getColumns return not empty
> resultSet for a table created in the test.
>
> Regards
> Blas Rodriguez Somoza
>
> ----- Original Message -----
> From: "David Jencks" <davidjencks@...>
> To: <Firebird-Java@yahoogroups.com>
> Sent: Wednesday, June 05, 2002 6:15 PM
> Subject: Re: [Firebird-Java] Re: FBDatabaseMetaData and underscores
>
>
> > Looks like there is a genuine problem.
> >
> > I wonder if the empty result sets are related to the recent change in
> > char(n) treatment from padding with spaces to padding with nulls? If the
> > system tables are padded with spaces they would not match a null-padded
> > string.
> >
> > david jencks
> >
> > On 2002.06.05 11:31:18 -0400 llafranc78 wrote:
> > > I've done two or three tests, and here is the scenario:
> > >
> > > a) if tableName contains underscores and it's short enough, no
> > > Exception is thrown and I get the right ResultSet;
> > >
> > > b) if tableName contains underscores and it's long enough, the
> > > Exception is thrown;
> > >
> > > c) if tableName doesn't contain underscores there is no Exception but
> > > I get an empty ResultSet;
> > >
> > > So after escaping the underscores the Exception is gone, but ALL
> > > ResultSets are empty!
> > >
> > > Regards
> > > Luca
> > >
> > >
> > >
> > >
> > > > I believe my implementation is spec compliant. It would certainly be
> > > > simpler not to handle wildcards at all. Try escaping them like this:
> > > >
> > > > column\_name
> > > >
> > > > or if you a literal string
> > > >
> > > > "column\\_name"
> > > >
> > > > Then you shouldn't see the extra spaces or the LIKE used either.
> > > >
> > > > There are tests for this in jca/TestDataBaseMetaData.java
> > > >
> > > > david jencks
> > > >
> > > > On 2002.06.05 10:29:02 -0400 llafranc78 wrote:
> > >
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > Firebird-Java-unsubscribe@yahoogroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> > >
> > >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Firebird-Java-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>