MaxGekk opened a new pull request #31586:
URL: https://github.com/apache/spark/pull/31586


   ### What changes were proposed in this pull request?
   Explicitly highlight that the table rename command cannot move a table 
between databases.
   
   ### Why are the changes needed?
   To inform users about actual behavior the table rename command.
   
   ### Does this PR introduce _any_ user-facing change?
   No
   
   ### How was this patch tested?
   ```sql
   spark-sql> CREATE DATABASE db1;
   spark-sql> CREATE DATABASE db2;
   spark-sql> CREATE TABLE db1.tbl1 (c0 INT);
   spark-sql> ALTER TABLE db1.tbl1 RENAME TO db2.tbl1;
   Error in query: RENAME TABLE source and destination databases do not match: 
'db1' != 'db2';
   spark-sql> ALTER TABLE db1.tbl1 RENAME TO db1.tbl2;
   spark-sql> SHOW TABLES IN db1 LIKE '*';
   db1  tbl2    false
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org

Reply via email to