Hi,
I think about this once again an what problem do you see with
a) select * from table b) insert into table values (...)
In point a - users see service fields and what problem? Wrong design and they
see it
In point b i see also no problem. Add after insert trigger and clear this
copied fields very easy operation
Regards,
Karol Bieniaszewski
----- Reply message -----
Od: "Vlad Khorsun" <[email protected]>
Do: "fb-devel" <[email protected]>
Temat: [Firebird-devel] RFC: non-expandable fields
Data: czw., kwi 4, 2013 15:27
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
------------------------------------------------------------------------------
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
