Issue Details (XML | Word | Printable)

Key: CORE-6306
Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: Major Major
Assignee: Unassigned
Reporter: Jorge Gonçalves
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Access to FB3 via FB4 provider (Engine12.dll)

Created: 15/May/20 07:21 PM   Updated: 17/May/20 03:13 PM
Component/s: None
Affects Version/s: 4.0 Beta 2
Fix Version/s: None

Environment: windows, FB3 : 3.0.4.33054, FB4: 4.0.0.1963

QA Status: No test


 Description  « Hide
Strange behavior when accessing an FB3 db:

Some examples:

isql from firebird 4
C:\Program Files\Firebird\Firebird_4_0>isql.exe fb3 -user SYSDBA -password masterkey
Database: fb3, User: SYSDBA

1---------------------
SQL> select current_user from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 8
-current_user

2-------------------------------
SQL> select current_date from rdb$database;

             CONSTANT
=====================
   0.0000000006702624

3-------------------------------
SQL> select current_time from rdb$database;

USER
===============================
SYSDBA

 4-------------------------------
SQL> select current_timestamp from rdb$database;

ROLE
===============================
NONE


select * from [any table from database] runs ok


same behavior with isql from fb3



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jorge Gonçalves added a comment - 15/May/20 11:25 PM
Version 3.0.5 no longer presents this problem.

Alexander Peshkov added a comment - 16/May/20 08:50 AM
Too old FB3 engine was used