public function run()
{
$this->requireDataset('Heroes');
r\db('Heroes')->table('marvel')->indexCreate('test', function ($x) {
return r\expr('5');
})->run($this->conn);
r\db('Heroes')->table('marvel')->indexWait('test')->run($this->conn);
$this->checkQueryResult(r\db('Heroes')->table('marvel')->between('5', '5', array('index' => 'test'))->count(), 0.0);
$this->checkQueryResult(r\db('Heroes')->table('marvel')->between('5', '5', array('index' => 'test', 'right_bound' => 'closed'))->count(), 3.0);
$this->checkQueryResult(r\db('Heroes')->table('marvel')->between('A', 'Z')->count(), 3.0);
$this->checkQueryResult(r\db('Heroes')->table('marvel')->between('I', 'J')->count(), 1.0);
$this->checkQueryResult(r\db('Heroes')->table('marvel')->between('I', 'I')->count(), 0.0);
$this->checkQueryResult(r\db('Heroes')->table('marvel')->between(r\minval(), 'J')->count(), 1.0);
$this->checkQueryResult(r\db('Heroes')->table('marvel')->between('J', r\maxval())->count(), 2.0);
$this->checkQueryResult(r\db('Heroes')->table('marvel')->between(r\minval(), r\maxval())->count(), 3.0);
r\db('Heroes')->table('marvel')->indexDrop('test')->run($this->conn);
}
public function testBetweenMinMax()
{
$res = $this->db()->table('marvel')->between(\r\minval(), \r\maxval())->count()->run($this->conn);
$this->assertEquals(3.0, $res);
}
