Hi Vlad, I see two aspects:
- With "RDB$DB_KEY" there already is a hidden field (though this one is not in 'RDB$RELATION_FIELDS'), so it might not be that surprising to have this beeing a feature of FB. - On the other hand, I would not like neither your statement a) nor b) in our code, nor do I see the necessity of adding fields to a table for replication purpose ;-) ... I guess it's not to hard to implement, but I would expect it to be used very rarely. Thomas Am 04.04.2013 15:27, schrieb Vlad Khorsun: > Hi all, > > i wrote this RFC by request of one local company which have (as many others) > wrote own replicator and got some issues which could be resolved very easy > with a little support from the Firebird engine side. I think we could discuss > it and > determine if requested feature could add some value to the engine for wider > audience. > > Their software (replicator) add's some service field(s) to the customer > tables > to track changes. In most cases it doesn't harm and customer software works > as expected, i.e. ignores unknown for it new fields. But there are two cases > when such service fields could change application's logic and even broke it. I > mean queries where list of fields is not set explicitly by a programmer but > expanded by the engine in run-time: > a) select * from table > b) insert into table values (...) > > So, the proposition is simple: add ability for engine to distinguish such > service > fields and not include it into auto expanded list of fields for table or view > at the > queries above. I.e. service fields is fully accessible if present in query > text explicitly > and "hidden" otherwise. > > I prefer to discuss implementation details after (if) we agreed on > feasibility of > such feature. > > Comments, ideas are welcome ;) > Vlad > > ------------------------------------------------------------------------------ > 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 > -- Mit freundlichen Grüßen, Thomas Beckmann Diplom-Informatiker Wielandstraße 14c • 23558 Lübeck Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559 Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de> ASSFINET-Logo *ASSFINET Dienstleistungs-GmbH* Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de <http://www.assfinet.de/> Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann Registergericht Koblenz HRB 23331 Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. ------------------------------------------------------------------------------ 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
