Issue Details (XML | Word | Printable)

Key: CORE-3222
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Ain Valtin
Votes: 0
Watchers: 1
Operations

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

View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE

Created: 09/Nov/10 09:00 AM   Updated: 04/Jun/13 09:51 AM
Component/s: Engine
Affects Version/s: 3.0 Initial, 2.5.0
Fix Version/s: 2.5.1

Time Tracking:
Not Specified

Environment: WI-V2.5.0.26074 Firebird 2.5
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
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.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.