Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Access to FB3 via FB4 provider (Engine12.dll) [CORE6306] #6548

Closed
firebird-automations opened this issue May 15, 2020 · 4 comments
Closed

Access to FB3 via FB4 provider (Engine12.dll) [CORE6306] #6548

firebird-automations opened this issue May 15, 2020 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Jorge Gonçalves (projorge_gmail.com)

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

@firebird-automations
Copy link
Collaborator Author

Commented by: Jorge Gonçalves (projorge_gmail.com)

Version 3.0.5 no longer presents this problem.

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Too old FB3 engine was used

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Cannot Reproduce [ 5 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant