The Exist function does not work as expected if it has a Joins condition. #1522

New Issue

kusana · 2020-02-19T07:39:02Z

kusana commented

2020-02-19 07:39:02 +00:00

The Exist function does not work as expected if it has a Joins condition.

ex.

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()

actual query

SELECT * FROM `number` LIMIT 1

expected

SELECT * FROM `number` 
INNER JOIN order_list ON order_list.id = number.lid 
LEFT JOIN player ON player.id = order_list.eid 
LIMIT 1

The Exist function does not work as expected if it has a Joins condition. ex. ``` 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() ``` actual query ``` SELECT * FROM `number` LIMIT 1 ``` expected ``` SELECT * FROM `number` INNER JOIN order_list ON order_list.id = number.lid LEFT JOIN player ON player.id = order_list.eid LIMIT 1 ```

kusana commented

2020-02-19 07:41:29 +00:00

PR:#1520

why build was killed

PR:https://gitea.com/xorm/xorm/pulls/1520 why build was killed

lunny commented

2020-02-19 07:50:58 +00:00

@kusana CI server has some problems.