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

Attempt of execute statement on external datasource failed when datasource is interbase 4.1 [CORE3089] #3468

Closed
firebird-issue-importer opened this issue Jul 30, 2010 · 9 comments

Comments

@firebird-issue-importer

Submitted by: Andrey Feklistov (feklist)

Executing procedure

create or alter procedure TEST1
returns (
V_INT integer)
as
begin
for execute statement 'select 1+1 from rdb$database'
on external '________'
with common transaction
as user 'SYSDBA' password 'masterke'
into :v_int do
suspend;
end

with target database of interbase 4.1 results in
"Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Unexpected error in isc_database_info.
At procedure 'TEST1' line: 6, col: 3." message.

Commits: 1ca9c0a 4156a47

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 30, 2010

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 30, 2010

Commented by: Sean Leyne (seanleyne)

Are you serious???!!!!

You expect Firebird to support connectivity to a Interbase **4.1** database!

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 3, 2010

Commented by: Andrey Feklistov (feklist)

Actually, YES.

1. As fbclient.dll fully compatible with IB4.1 and other old versions, cost of this fix should be rather low.
2. Using FB2.5 to simply aggregate or consolidate data from old databases and develop new functionality in new environment supporting integrity and one entry point in information system - great argument to use Firebird by users of some ancient or proprietary software.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 3, 2010

Commented by: Sean Leyne (seanleyne)

1 - It is poor thinking to assume that because an application can use the FBClient to connect to a IB 4.1 database, that the external database access functionality would support the same.

2 - I could argue that you should be able easily to use Firebird with the ancient/proprietary software by simply migrating the existing database to a newer Firebird database structure.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 6, 2010

Commented by: @hvlad

The issue is that pre-IB6 engines don't understand isc_info_db_sql_dialect as there was no SQL dialects before IB6.
I see no problem to fix it.
Fix is committed, please confirm it (using tomorrows snapshot build)

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 6, 2010

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.5.1 [ 10333 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 2, 2010

Modified by: @dyemanov

Fix Version: 2.5.0 [ 10221 ]

Fix Version: 2.5.1 [ 10333 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 14, 2011

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 20, 2015

Modified by: @pavel-zotov

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

QA Status: Cannot be tested

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

Successfully merging a pull request may close this issue.

None yet
2 participants