public function case_select_join()
{
$this->given($q = new CUT())->when($s = $q->select(), $s->enableEncloseIdentifier(), $result = (string) $s->select('a')->select('b')->from('foo')->join('bar')->on('"b" = "baz"')->where('"b" > 10'))->then->string($result)->isEqualTo('SELECT "a", "b" FROM "foo" ' . 'JOIN "bar" ON "b" = "baz" ' . 'WHERE "b" > 10');
}
public function case_insert_select()
{
$this->given($q = new CUT())->when($result = (string) $q->insert()->or->rollback()->into('foo')->on('a', 'b', 'c')->values($q->select('a', 'b', 'c')->from('foo')->limit(3)))->then->string($result)->isEqualTo('INSERT OR ROLLBACK INTO foo (a, b, c) ' . 'SELECT a, b, c FROM foo LIMIT 3');
}
