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