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

Jump to bottom

NOT EXISTS statement fails in 2.1 [CORE1764] #2188

Closed
firebird-automations opened this issue Feb 26, 2008 · 7 comments
Closed

NOT EXISTS statement fails in 2.1 [CORE1764] #2188

firebird-automations opened this issue Feb 26, 2008 · 7 comments
Assignees
@hvlad
Labels
affect-version: 2.1 Alpha 1 affect-version: 2.1 Beta 1 affect-version: 2.1 Beta 2 affect-version: 2.1 RC1 fix-version: 2.1 RC2 priority: major type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Robert Gilland (robert.gilland_basx.com.au)

running not exists statements fail in 2.1 ( build 16780 )

see SQL :

select RI.*
from RDB$INDICES RI
WHERE( NOT EXISTS
( SELECT *
FROM RDB$INDEX_SEGMENTS RS
WHERE( RI.RDB$INDEX_NAME = RS.RDB$INDEX_NAME )))

Resultant Error:

ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -206
Column unknown
RDB$INDICES.DB_KEY
At line 3, column 20

STATEMENT:
TIBOInternalDataset: "<TApplication>.frmMain.dlgWisql.<TIBOQuery>.<TIBOInternalDataset>."
@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

The official RC1 release is build 17735, so why do you test on something outdated? I cannot reproduce the issue with RC1 and IBExpert.

@firebird-automations
Copy link
Collaborator Author

Commented by: Claudio Valderrama C. (robocop)

This is an IBO internal error, because it tries to retrieve rdb$db_key by table name instead of table alias.
Either get a new IBOConsole (hopefully compiled with a fixed IBO) or read the file firebird.conf and the emergency workaround, setting RelaxedAliasChecking to 1.

@firebird-automations
Copy link
Collaborator Author

Modified by: Claudio Valderrama C. (robocop)

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

resolution: Fixed [ 1 ]

Fix Version: 2.1 RC2 [ 10250 ]

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Robert Gilland (robert.gilland_basx.com.au)

Firebird 2.0.3 with my version of IBObjects 4.6bc works fine.
I have not changed anything but install
Firebird 2.1 latest build ( I have since tested on 2.1 RC1 )
Now the NOT EXISTS statement does not work.
So how can this be a bug in IBO.
Since IBO worked with Firebird 2.0.3?

@firebird-automations
Copy link
Collaborator Author

Commented by: Smirnoff Serg (wildsery)

This _might_ be an issue in IBO.
Just execute this query with ISQL and see what happens.

Hint: monitor query that IBO actually send to server.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hvlad hvlad

Labels
affect-version: 2.1 Alpha 1 affect-version: 2.1 Beta 1 affect-version: 2.1 Beta 2 affect-version: 2.1 RC1 fix-version: 2.1 RC2 priority: major type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@hvlad @firebird-automations