LS> The current functionality seems to be reasonable to me.
LS> How can system know about Field2 if it hasn't reached that far in parsing
the command?
I agree, but the real problem appears in different situations, for example:
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 :-(
[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br
------------------------------------------------------------------------------
How fast is your code?
3 out of 4 devs don\\\'t know how their code performs in production.
Find out how slow your code is with AppDynamics Lite.
http://ad.doubleclick.net/clk;262219672;13503038;z?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
