Method TestNestedRightJoin

database/sqlbuilder/table_test.go:193–209

(c *gc.C)

}

func (s *TableSuite) TestNestedRightJoin(c *gc.C) {
	join1 := table1.InnerJoinOn(table2, Eq(table1Col3, table2Col3))
	join2 := join1.RightJoinOn(table3, Eq(table1Col1, table3Col1))

	buf := &bytes.Buffer{}

	err := join2.SerializeSql("db", buf)
	c.Assert(err, gc.IsNil)

	sql := buf.String()
	c.Assert(
		sql,
		gc.Equals,
		"`db`.`table1` "+
			"JOIN `db`.`table2` ON `table1`.`col3`=`table2`.`col3` "+
			"RIGHT JOIN `db`.`table3` ON `table1`.`col1`=`table3`.`col1`")
}