Issue Details (XML | Word | Printable)

Key: CORE-2386
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

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

ALTER VIEW could remove column used in stored procedure or trigger

Created: 24/Mar/09 05:12 PM   Updated: 19/Jan/16 06:11 AM
Component/s: Engine
Affects Version/s: 2.5 Alpha 1
Fix Version/s: 2.5 Beta 2

Issue Links:
Relate
 

QA Status: Done successfully


 Description  « Hide
SET TERM ^ ;

CREATE VIEW V_TEST (F1, F2)
AS
  SELECT 1, 2 FROM RDB$DATABASE
^

CREATE PROCEDURE SP_TEST
AS
DECLARE I INT;
BEGIN
  SELECT F1, F2 FROM V_TEST
    INTO :I, :I;
END
^

COMMIT
^

ALTER VIEW V_TEST (F1) AS
  SELECT 1 FROM RDB$DATABASE
^

COMMIT
^

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 24/Mar/09 05:51 PM
Fix is not in time to be included into Beta1

Pavel Cisar added a comment - 31/May/11 01:20 PM
QA test added.