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@xxxxxxxxxxx