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

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: 29/May/15 05:40 PM
Component/s: Engine
Affects Version/s: 2.0.0, 2.0.1
Fix Version/s: 2.1 Beta 1, 2.0.2

Environment: WinXP SP2
Issue Links:

QA Status: Done successfully

 Description  « Hide
create procedure p
  returns (col int)
  col = 1;


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

 All   Comments   Change History   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.