Running Ruby on Rails Active Record unit tests with MariaDB 10.4.3, some of the tests failed.
I have created a rep.sql script to reproduce this failure without using Ruby on Rails.

• Steps to reproduce

1. Download 'rep.sql' from this ticket
2. Execute this rep.sql script as follows, create test database if not exist

$ mysql -uroot -D test < rep.sql 

* Expected result

*************************** 1. row ***************************

         id: 25772709

       name: sapphire

       type: NULL

looter_type: Pirate

  looter_id: 812997556

    ship_id: NULL

  parrot_id: 136705135

treasure_id: 25772709

$

• Actual result
  No record returns