Erik Darling has a new video. This one is on variable assignment and how SET and SELECT behave somewhat differently. The crux of the video is how SELECT will not reset a variable’s value the result of the assignment is NULL. Erik also shows how to make SELECT respect NULL in variable assignment.