sminnee / silverstripe-framework

		$this->assertContains('SELECT DISTINCT', $query->sql($params), 'Query contains distinct');

 	}

	public function testComparisonClauseInt() {

		DB::query("INSERT INTO \"DataQueryTest_F\" (\"SortOrder\") VALUES (2)");

		$query = new DataQuery('DataQueryTest_F');

		$query->where(DB::get_conn()->comparisonClause('"SortOrder"', '2'));

		$this->assertGreaterThan(0, $query->count(), "Couldn't find SortOrder");

		$this->resetDBSchema(true);

	}

	public function testComparisonClauseDateFull() {

		DB::query("INSERT INTO \"DataQueryTest_F\" (\"MyDate\") VALUES ('1988-03-04 06:30')");

		$this->resetDBSchema(true);

	}

	public function testComparisonClauseDateFull() {

		DB::query("INSERT INTO \"DataQueryTest_F\" (\"MyDate\") VALUES ('1988-03-04 06:30')");

		$query = new DataQuery('DataQueryTest_F');

		$query->where(DB::get_conn()->comparisonClause('"MyDate"', '1988-03-04%'));

		$this->assertGreaterThan(0, $query->count(), "Couldn't find MyDate");

		$this->resetDBSchema(true);

	}

	public function testComparisonClauseDateStartsWith() {

		DB::query("INSERT INTO \"DataQueryTest_F\" (\"MyDate\") VALUES ('1988-03-04 06:30')");

		$this->resetDBSchema(true);

	}

	public function testComparisonClauseDateStartsWith() {

		DB::query("INSERT INTO \"DataQueryTest_F\" (\"MyDate\") VALUES ('1988-03-04 06:30')");

		$query = new DataQuery('DataQueryTest_F');

		$query->where(DB::get_conn()->comparisonClause('"MyDate"', '1988%'));

		$this->assertGreaterThan(0, $query->count(), "Couldn't find MyDate");

		$this->resetDBSchema(true);

	}

	public function testComparisonClauseDateStartsPartial() {

		DB::query("INSERT INTO \"DataQueryTest_F\" (\"MyDate\") VALUES ('1988-03-04 06:30')");

		$this->resetDBSchema(true);

	}

	public function testComparisonClauseDateStartsPartial() {

		DB::query("INSERT INTO \"DataQueryTest_F\" (\"MyDate\") VALUES ('1988-03-04 06:30')");

		$query = new DataQuery('DataQueryTest_F');

		$query->where(DB::get_conn()->comparisonClause('"MyDate"', '%03-04%'));

		$this->assertGreaterThan(0, $query->count(), "Couldn't find MyDate");

		$this->resetDBSchema(true);

	}

	public function testComparisonClauseTextCaseInsensitive() {

		DB::query("INSERT INTO \"DataQueryTest_F\" (\"MyString\") VALUES ('HelloWorld')");

		$this->resetDBSchema(true);

	}

	public function testComparisonClauseTextCaseInsensitive() {

		DB::query("INSERT INTO \"DataQueryTest_F\" (\"MyString\") VALUES ('HelloWorld')");

		$query = new DataQuery('DataQueryTest_F');

		$query->where(DB::get_conn()->comparisonClause('"MyString"', 'helloworld'));

		$this->assertGreaterThan(0, $query->count(), "Couldn't find MyString");

		$this->resetDBSchema(true);

	}

	public function testComparisonClauseTextCaseSensitive() {

		DB::query("INSERT INTO \"DataQueryTest_F\" (\"MyString\") VALUES ('HelloWorld')");