Issue Details (XML | Word | Printable)

Key: CORE-3491
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Dmitry Yemanov
Votes: 2
Watchers: 2
Operations

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

Altering of a TYPE OF COLUMN parameter affects the original column

Created: 23/May/11 12:50 PM   Updated: 08/Apr/14 12:41 PM
Component/s: Engine
Affects Version/s: 2.5.0
Fix Version/s: 2.5.1, 3.0 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
Test case:

create table aaa (a integer);
commit;

create or alter procedure bbb
returns (b type of column aaa.a)
as
begin
 suspend;
end
commit;

create or alter procedure bbb
returns (b varchar(10))
as
begin
 suspend;
end
commit;

At this point, column "aaa.a" has data type of varchar(10)! It looks like the underlying domain has been modified without checking other dependencies.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.