simultaneous_assignment would be my choice; as you say it's the most accurate, if a little long. 30/01/2018 13:24, Sergei Golubchik wrote:
Hi, Russell!
On Jan 29, Russell J.T. Dyer wrote:
Is this mode related only to UPDATE and this feature? If so, maybe it could be something like one of these:
update_static update_stasis update_isolation
These would focus on the fact that it's related just to UPDATE and that the values held in a state temporarily, or in isolation of each other.
Sorry, I should've said earlier.
It's not only for update. There is a patch to fix SELECT ... INTO, and I suppose we'll have "simultaneous assignment" behavior everywhere eventually.
So, I'm leaning towards either simultaneous_assignment or simultaneous_set as mode names. The first is more exact, but it's rather long (sql_mode names range from 3 to 26 characters, and this one is 23). The second (with 16) fits right in the middle of the range, length-wise. But there's no SET keyword in SELECT ... INTO. On the other hand, there's no ASSIGNMENT keyword anywhere either :)
Regards, Sergei Chief Architect MariaDB and security@mariadb.org