$this->assertEquals(2, $DB->count_records($table->getName()));
$this->assertEquals(1, $DB->count_records($table->getName(), ['nullable1' => 1]));
+ $this->assertEquals(1, $DB->count_records($table->getName(), ['nullable1' => null]));
// And it should be possible to insert a duplicate.
$DB->insert_record($tablename, (object) ['notnull1' => 1, 'nullable1' => null, 'nullable2' => null]);
$this->assertEquals(3, $DB->count_records($table->getName()));
$this->assertEquals(1, $DB->count_records($table->getName(), ['nullable1' => 1]));
+ $this->assertEquals(2, $DB->count_records($table->getName(), ['nullable1' => null]));
// Same, but with only one of the nullable columns being null.
$DB->insert_record($tablename, (object) ['notnull1' => 1, 'nullable1' => 1, 'nullable2' => null]);
$this->assertEquals(4, $DB->count_records($table->getName()));
$this->assertEquals(2, $DB->count_records($table->getName(), ['nullable1' => 1]));
+ $this->assertEquals(2, $DB->count_records($table->getName(), ['nullable1' => null]));
$DB->insert_record($tablename, (object) ['notnull1' => 1, 'nullable1' => 1, 'nullable2' => null]);
$this->assertEquals(5, $DB->count_records($table->getName()));
$this->assertEquals(3, $DB->count_records($table->getName(), ['nullable1' => 1]));
+ $this->assertEquals(2, $DB->count_records($table->getName(), ['nullable1' => null]));
}