CREATE TABLE Foo (
CREATE VIEW VIEW_Foo (
) AS SELECT
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.