This is not generated, it is a literal string in the FBDatabaseMetaData
class. There are 5 tests for getTables in the testsuite which have not
failed for me since I wrote them (and this sql), so I'm somewhat surprised
at this problem.

Could you please get the source for jaybird out of cvs and run the
testsuite and see if the database metadata tests pass or fail?

cvs ... co client-java
cd client-java
./build.sh

Many thanks
david jencks

On 2003.05.11 21:12 mmathias0 wrote:
> Hi,
>
> I tryed the sql statement without "? = 'T'" through IBExpert and it
> worked without problems.
>
> Isn't Jaybird generating this SQL? If yes, why is it generating a
> wrong statement? What am I doing wrong?
>
> Thanks,
> Marcelo
>
> --- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
> <rrokytskyy@a...> wrote:
> > Helen,
> >
> > > >select null as TABLE_CAT, null as TABLE_SCHEM,
> > >
> > > This is the "feature not supported". You can't have an untyped
> column
> > > in an output set.
> >
> > When this behavior was changed? Note, following statement works
> > perfectly with Firebird 1.0.2 (build 908):
> >
> > select null as bla from rdb$database
> >
> > Personally I suspect another part: "... WHERE ? = 'T' ...", but this
> > should be confirmed.
> >
> > Thanks!
> > Roman
>
>
>
> 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/
>
>
>
>