1 Commits (mr13.3)

Author	SHA1	Message	Date
Kirill Solomko	38051cfc67	MT#57708 change sound_set_handle_parents index and proc ... * convert unique key set_handle_id_idx (set_id, handle_id) to non-unique to avoid deadlocks because of forced gap locks in INSERT and DELETE concurrent operations (when such occur) * "update_sound_set_handle_parents" procedure: - avoid IODKU and instead calculate entries to skip on the fly. - WITH and WITHOUT u_handle_id is now split into 2 separate IF blocks as otherwise "AND handle_id = u_handle_id OR 1:1" caused full handles update even if u_handle_id was there * fix a typo for "TRIGGER voip_sound_files_create_trig AFTER INSERT" which wrongly had "AFTER UPDATE" * fix warnings of 'Truncated DOUBLE' coming from using IF evaluation variable as boolean, IF(LENGTH(cte.parent_chain) > 1 addresses it. Change-Id: Id6b6ab66de53c2ccd95f28d23e5e2b97ece89923	3 years ago