
|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
WI-V2.5.0.26074 Firebird 2.5
|
|
Issue Links:
|
Relate
|
|
|
|
This issue is related to:
|
|
|
|
|
|
|
|
| Planning Status: |
Unspecified
|
|
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.
|
|
Description
|
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. |
Show » |
| There are no comments yet on this issue.
|
|