sminnee / silverstripe-framework

		$this->assertEquals(10, $limit['start']);

	}

	public function testParameterisedInnerJoins() {

		$query = new SQLQuery();

		$query->setSelect(array('"SQLQueryTest_DO"."Name"', '"SubSelect"."Count"'));

		$query->setFrom('"SQLQueryTest_DO"');

		$query->addInnerJoin(

			'(SELECT "Title", COUNT(*) AS "Count" FROM "SQLQueryTestBase" GROUP BY "Title" HAVING "Title" NOT LIKE ?)',

			'"SQLQueryTest_DO"."Name" = "SubSelect"."Title"',

			'SubSelect',

			20,

			array('%MyName%')

		);

		$query->addWhere(array('"SQLQueryTest_DO"."Date" > ?' => '2012-08-08 12:00'));

		$this->assertSQLEquals('SELECT "SQLQueryTest_DO"."Name", "SubSelect"."Count"

			FROM "SQLQueryTest_DO" INNER JOIN (SELECT "Title", COUNT(*) AS "Count" FROM "SQLQueryTestBase"

		   GROUP BY "Title" HAVING "Title" NOT LIKE ?) AS "SubSelect" ON "SQLQueryTest_DO"."Name" =

		   "SubSelect"."Title"

			WHERE ("SQLQueryTest_DO"."Date" > ?)', $query->sql($parameters)

		);

		$this->assertEquals(array('%MyName%', '2012-08-08 12:00'), $parameters);

		$query->execute();

	}

	public function testParameterisedLeftJoins() {

		$query = new SQLQuery();

		$query->execute();

	}

	public function testParameterisedLeftJoins() {

		$query = new SQLQuery();

		$query->setSelect(array('"SQLQueryTest_DO"."Name"', '"SubSelect"."Count"'));

		$query->setFrom('"SQLQueryTest_DO"');

		$query->addLeftJoin(

			'(SELECT "Title", COUNT(*) AS "Count" FROM "SQLQueryTestBase" GROUP BY "Title" HAVING "Title" NOT LIKE ?)',

			'"SQLQueryTest_DO"."Name" = "SubSelect"."Title"',

			'SubSelect',

			20,

			array('%MyName%')

		);

		$query->addWhere(array('"SQLQueryTest_DO"."Date" > ?' => '2012-08-08 12:00'));

		$this->assertSQLEquals('SELECT "SQLQueryTest_DO"."Name", "SubSelect"."Count"

			FROM "SQLQueryTest_DO" LEFT JOIN (SELECT "Title", COUNT(*) AS "Count" FROM "SQLQueryTestBase"

		   GROUP BY "Title" HAVING "Title" NOT LIKE ?) AS "SubSelect" ON "SQLQueryTest_DO"."Name" =

		   "SubSelect"."Title"

			WHERE ("SQLQueryTest_DO"."Date" > ?)', $query->sql($parameters)

		);

		$this->assertEquals(array('%MyName%', '2012-08-08 12:00'), $parameters);

		$query->execute();

	}

	/**

	 * Test deprecation of SQLQuery::getWhere working appropriately