yuqi1129 opened a new issue, #14523:
URL: https://github.com/apache/gravitino/issues/14523

   ### Version
   main branch
   
   ### Describe what's wrong
   PostgreSQL schema-comment lookup concatenates schema names into SQL, and 
several table DDL statements do not escape embedded identifier quotes. Existing 
native table names also fail deletion name validation before reaching correctly 
quoted DDL.
   
   ### Error message and/or stacktrace
   Malformed SQL or unintended interpretation of embedded quotes in existing 
PostgreSQL object names.
   
   ### How to reproduce
   Load an existing schema containing an apostrophe, or alter an existing table 
whose name contains a double quote. Existing legal native names should be 
handled as data and identifiers, respectively. Drop/purge entry validation must 
allow provider-validated existing names without relaxing creation rules.
   
   ### Additional context
   Tracks https://github.com/datastrato/gravitino-enterprise/issues/3124 and 
https://github.com/datastrato/gravitino-enterprise/issues/3145. Scope: schema 
metadata lookup and PostgreSQL table DDL; arbitrary native-name schema 
CREATE/DROP and general column-name validation are separate work.
   


-- 
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.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to