"ALTER TABLE RENAME TO" does not work with tables in upper casee

Hi Community

I think I have discovered a bug in the ALTER TABLE RENAME TO command.  It does not seem to be able to handle capital letters when the spark property “spark.sql.caseSensitive” is sat to “true”. In my company we have had tables in upper case and therefor we have this property to “true” in our Spark environment.

We are able to work with our table using upper case letters (create tables /read and write). However the ALTER TABLE TABLE_A RENAME TO TABLE_B does not work in upper case – only in lower case.

Anyone have the same issue and found a solution if you want to rename to upper case table name? As I see it the command has a bug.

Below I include two examples from a spark notebook (remember to set spark.sql.caseSensitive = True in environment). Appendix A will fail – renaming “upper case table name” to “new upper case table name”. Appendix B will run ok – renaming “upper case table name” to new “lower case table name”.

Appendix A – this code will fail.

%%sql

/*

1. 1. having set spark.sql.caseSensitive = True (in spark environment)
2. 2. this does now work when we rename using capital letters
3. 3. Youe will get the error DELTA_TABLE_NOT_FOUND
4. 4. you will se the table A_TEST_RENAME_1 (in upper case) under manged tables

and then at the same time a_test_rename (in lower case) under Unidentified  

*/

create table A_TEST (number_1 decimal(10,0));

insert into A_TEST values(1);

select * from A_TEST;

alter table A_TEST rename to A_TEST_RENAME_1;

select * from A_TEST_RENAME_1;

Appendix B – this code will run

%%sql

/*

1. 1. having set spark.sql.caseSensitive = True (in spark environment)
2. 2. this works fine when we rename using renaming to lower case case naming in the rename

*/

create table A_TEST2 (number_1 decimal(10,0));

insert into A_TEST2 values(1);

select * from A_TEST2;

alter table A_TEST2 rename to a_test2_rename_2;

select * from a_test2_rename_2;