(c *gc.C)
| 179 | } |
| 180 | |
| 181 | func (s *StmtSuite) TestSelectMultiOrderBy(c *gc.C) { |
| 182 | q := table1.Select(table1Col1, table1Col2) |
| 183 | q.OrderBy(table1Col2, table1Col1) |
| 184 | sql, err := q.String("db") |
| 185 | |
| 186 | c.Assert(err, gc.IsNil) |
| 187 | c.Assert( |
| 188 | sql, |
| 189 | gc.Equals, |
| 190 | "SELECT `table1`.`col1`,`table1`.`col2` "+ |
| 191 | "FROM `db`.`table1` "+ |
| 192 | "ORDER BY `table1`.`col2`,`table1`.`col1`") |
| 193 | } |
| 194 | |
| 195 | func (s *StmtSuite) TestSelectOnJoin(c *gc.C) { |
| 196 |