Inconsistent behavior with COMPUTED BY fields and metadata extraction
---------------------------------------------------------------------
Key: CORE-3926
URL: http://tracker.firebirdsql.org/browse/CORE-3926
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 2.1.5, 2.0.7, 2.5.1, 2.1.4, 2.5.0, 2.0.6, 3.0 Initial,
2.1.3, 2.1.2, 2.0.5, 2.1.1, 2.1.0, 2.5.2, 2.5.3, 2.1.6, 3.0.0
Reporter: Carlos H. Cantu
Priority: Trivial
ALTER statement allows me to change a computed by field with a new formula
referencing a field that is positioned higher than the computed by field, but
when you extract the table metadata and try to run it, it crashes with "Column
unknown." error.
To reproduce:
Step 1)
create table a
( field2 numeric (9,2),
field1 computed by (field2 * 0.5));
Step 2)
alter table a add field3 numeric (9,2);
Step 3)
alter table a alter field1 computed by (field3 * 0.5); -- This works fine!!!
Step 3 works fine, but when you extract the DDL of the table and try to run it,
it will
crash, since it will be extracted like:
CREATE TABLE A (
FIELD2 NUMERIC(9,2),
FIELD1 COMPUTED BY (field3 * 0.5),
FIELD3 NUMERIC(9,2)
);
This means that you may have a "good" database, but when you extract its
metadata into a script to create another empty database, it will crash :-(
IMHO, the behavior should be consistent in the two scenarios so, or the table
creation should succeed, or the ALTER should had failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
