The Exist function does not work as expected if it has a Joins condition. #1522
The Exist function does not work as expected if it has a Joins condition.
session.Table("number"). Select("player.id"). Join("INNER", "order_list", "order_list.id = number.lid"). Join("LEFT", "player", "player.id = order_list.eid") has, err = session.Exist()
SELECT * FROM `number` LIMIT 1
SELECT * FROM `number` INNER JOIN order_list ON order_list.id = number.lid LEFT JOIN player ON player.id = order_list.eid LIMIT 1
No due date set.
No dependencies set.
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?