Bug while fetching created models in testing

[kikky7]

• Laravel Version: 6.18.0
• PHP Version: 7.2.24
• Database Driver & Version: MySQL 5.7.28

Description:

Can't get model in testing with create method.

Steps To Reproduce:

$ad = Ad::create([
    'title' => 'This is first ad',
    'body' => '',
]);

$this->assertDatabaseHas('ads', [
    'title' => 'This is first ad',
]);

dump($ad->title);
dump(get_class($ad));
dump(is_null(Ad::first()));

$ad2 = factory(Ad::class)->create();

dump($ad2->title);
dump(get_class($ad2));
dump(is_null(Ad::first()));

$user = User::create([
    'email' => 'test@example.com',
    'password' => 'secret',
    'type' => 'company',
]);

dump($user->email);
dump(get_class($user));
dump(is_null(User::where('email', 'test@example.com')->first()));

This is response:

"This is first ad"
"App\Ad"
true
"Automated optimal capacity"
"App\Ad"
false
"test@example.com"
"App\User"
false

Why first created Ad can't be fetched with Ad::first() or Ad::where('title', 'This is my first ad')->first()? It is always null...

Data is saved in database, which is confirmed with this line of code: $this->assertDatabaseHas('ads', [ 'title' => 'This is first ad', ]);

It only happens with this model (Ad); as you can see User works as expected, same as any other custom model I tried.

[staudenmeir]

What do the Ad model and its factory look like?

What's the result of dd($ad->getAttributes(), \DB::table('ads')->get());

[kikky7]

Found bug, it's my mistake. I have global scope which filters them by is_preview. Thank you! I would never find it without posting database dump here.