SQLite Forum

Thank you for checking DB and correcting the source.
I tried the latest version and was able to confirm that the problem has been fixed.


    % tar xf ../sqlite-snapshot-202005081822.tar.gz
    % cd sqlite-snapshot-202005081822
    % ./configure
    % make
     :
    % ./sqlite3 /tmp/production.sqlite3 
    SQLite version 3.32.0 2020-05-08 18:22:00
    Enter ".help" for usage hints.
    sqlite> SELECT COUNT(*) FROM "forwarding_addresses" LEFT OUTER JOIN "users" ON "users"."id" = "forwarding_addresses"."user_id" WHERE "forwarding_addresses"."user_id" = 21;
    2
    sqlite> SELECT COUNT(*) FROM "forwarding_addresses" LEFT OUTER JOIN "users" ON "users"."id" = "forwarding_addresses"."user_id" WHERE "users"."id" = 21;
    2
    sqlite> SELECT COUNT(*) FROM "forwarding_addresses" LEFT OUTER JOIN "users" ON "users"."id" = "forwarding_addresses"."user_id" WHERE "forwarding_addresses"."user_id" = 21 AND "users"."id" = 21;
    2

I was very troubled by an incident that resulted in the unintentional disclosure of information, and it was very helpful.

Thanks,