sync mysql behavior with sqlite