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
A Drouard made changes - 16/May/17 04:53 PM
Field Original Value New Value
Description Sometimes databases contain tables where rdb$relation_type is null.
Jaybird 2.29 list 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
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
Mark Rotteveel made changes - 17/May/17 03:25 PM
Link This issue is related to CORE-5543 [ CORE-5543 ]
Mark Rotteveel made changes - 20/May/17 09:44 AM
Fix Version/s Jaybird 3.0.1 [ 10831 ]
Fix Version/s Jaybird 3.1 [ 10441 ]
Mark Rotteveel made changes - 20/May/17 10:37 AM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Mark Rotteveel made changes - 05/Jun/17 01:14 PM
Status Resolved [ 5 ] Closed [ 6 ]