More on key column updates...

Upon speaking to Bryn, I found out that my last post wasn't quite correct. The alternative update mechanism is chosen if the update is to a key column and the update is not context literal (the meaning of that is another story). For example, an update such as:
update Customer set { SSN := "333-33-3333" } where SSN = "222-22-2222"
(assuming that SSN is all or part of a key) will not require the "doopty doo dance maneuver" and Dataphor detects this.

Comments

Popular posts from this blog

Don't Repeat Yourself... Really!

Virtual Appliances... poodoo

Issues raised by polymorphism in relation land