function test_4_null() { DB::query("UPDATE accounts SET password = NULL WHERE username=%s", 'Bart'); $all = DB::query("SELECT * FROM accounts ORDER BY id ASC"); $ages = DBHelper::verticalSlice($all, 'age', 'password'); $this->assert(count($ages) === 5); $this->assert($ages[''] === '15'); $passwords = DBHelper::reIndex($all, 'password'); $this->assert(count($passwords) === 5); $this->assert($passwords['']['username'] === 'Bart'); $this->assert($passwords['']['password'] === NULL); }