Hello, All.

I'm working on controlling of replication using SQL and get stuck on "alter table" statement. It may include zero or more clauses that require modification of RDB$RELATIONS table. For example: "alter table t drop sql security, disable replication".

What is the best way to handle this in AlterRelationNode::execute() according to project's coding rules?

1) Several MODIFY RDB$RELATIONS statements, one for each change of attributes;
2) One unconditional MODIFY which may be no-op if no attributes was changed;
3) Loop through RelationNode::clauses gathering flags for each changed attribute and then (if needed) one MODIFY for all changed attributes.

--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to