Issue Details (XML | Word | Printable)

Key: CORE-1183
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0
Operations

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

View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference

Created: 28/Mar/07 02:20 PM   Updated: 19/Aug/07 12:15 PM
Component/s: Engine
Affects Version/s: 2.0.0, 2.0.1
Fix Version/s: 2.1 Beta 1, 2.0.2

Time Tracking:
Not Specified

Environment: WinXP SP2
Issue Links:
Relate
 


 Description  « Hide
create procedure p
  returns (col int)
as
begin
  col = 1;
  suspend;
end;

commit;

create view v
as
  select * from rdb$database
  where 1 in ( select col from p );
-- error "feature is not supported"


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 19/Aug/07 12:15 PM
Fix verified for 2.1 Beta 1, test added.