Issue Details (XML | Word | Printable)

Key: JDBC-494
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: A Drouard
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Jaybird JCA/JDBC Driver

FBDatabaseMetaData.getTables does not list tables where rdb$relation_type is null

Created: 16/May/17 01:46 PM   Updated: 05/Jun/17 01:14 PM
Component/s: JDBC driver
Affects Version/s: Jaybird 3.0.0
Fix Version/s: Jaybird 3.0.1, Jaybird 3.1

Environment: Windows 8, Java 8, Firebird 3
Issue Links:
Relate
 


 Description  « Hide
Sometimes databases contain tables where rdb$relation_type is null.
Jaybird 2.2.9 lists such tables, Jaybird 3.0.0 does not.
May be it's a Firebird issue, but update of rdb$relations is prohibited by Firebird 3.
gfix and gbak didn't help.

Request to list tables with problem :
select rdb$relation_name from rdb$relations where rdb$relation_type is null and rdb$system_flag = 0

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.