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

View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE [CORE3222] #3596

Closed
firebird-automations opened this issue Nov 9, 2010 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Ain Valtin (ain)

Is related to QA449

CREATE TABLE Foo (
Bar INTEGER,
Str CHAR(31)
);

CREATE VIEW VIEW_Foo (
Bar
) AS SELECT
Bar
FROM Foo
WHERE(Trim(Str) = 'test')
WITH CHECK OPTION
;

This will fail with error message
<<
Message: isc_dsql_prepare failed
SQL Message : -902
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Engine Code : 335544721
Engine Message :
Unable to complete network request to host "localhost".
Error reading data from the connection.
>>

It tooks few seconds before it fails, so it looks like server goes into some loop before it fails...
Remove either "WITH CHECK OPTION" or call to "TRIM" and it is accepted.

Commits: 9086a90 f8a665b FirebirdSQL/fbt-repository@90496df

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Version: 3.0 Initial [ 10301 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA449 [ QA449 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

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

Fix Version: 3.0 Alpha 1 [ 10331 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

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