Renaming temporary to an part-uppercase named table fails on a MacOS case-insensitive file system

# Create the initial temporary table

CREATE TEMPORARY TABLE foo AS (SELECT 1);

# Ensure it exists

SELECT * FROM foo;

# Alter table ensuring destination name contains an uppercase alphabetic character

ALTER TABLE foo RENAME Bar;

# Both tables no longer exist

SELECT * FROM foo;

SELECT * FROM Bar;