Hello Vlad and all, IMHO, the easiest way to implement this is to make all fields with prefix "RDB$" (or whatever) hidden by default. Untill you do not address to those fields directly - they are ignored by the engine, when data is fetched.
But the problem is a bit deeper. How to deal with those fields, if they will be declared unique? Of they will be declared as FK, etc? Sure, this will add a lot of headache to tools` developers - like IB Expert and others. Also, you definitelly can rise a lot of bugs, caused by "phantom" fields - from the one point of view, they do not exists, from the other - engine must check everything related to data integrity constraints, related to those fields... just my 0.02MDL :) Thursday, April 4, 2013, 4:27:31 PM, you wrote: VK> Hi all, VK> i wrote this RFC by request of one local company which have (as many others) VK> wrote own replicator and got some issues which could be resolved very easy VK> with a little support from the Firebird engine side. I think we could discuss it and VK> determine if requested feature could add some value to the engine for wider VK> audience. VK> Their software (replicator) add's some service field(s) to the customer tables VK> to track changes. In most cases it doesn't harm and customer software works VK> as expected, i.e. ignores unknown for it new fields. But there are two cases VK> when such service fields could change application's logic and even broke it. I VK> mean queries where list of fields is not set explicitly by a programmer but VK> expanded by the engine in run-time: VK> a) select * from table VK> b) insert into table values (...) VK> So, the proposition is simple: add ability for engine to distinguish such service VK> fields and not include it into auto expanded list of fields for table or view at the VK> queries above. I.e. service fields is fully accessible if present in query text explicitly VK> and "hidden" otherwise. VK> I prefer to discuss implementation details after (if) we agreed on feasibility of VK> such feature. VK> Comments, ideas are welcome ;) VK> Vlad VK> ------------------------------------------------------------------------------ VK> Minimize network downtime and maximize team effectiveness. VK> Reduce network management and security costs.Learn how to hire VK> the most talented Cisco Certified professionals. Visit the VK> Employer Resources Portal VK> http://www.cisco.com/web/learning/employer_resources/index.html VK> Firebird-Devel mailing list, web interface at VK> https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Best regards, Sergey mailto:s...@dqteam.com ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
