Kengne-yvana commented on PR #5320: URL: https://github.com/apache/fineract/pull/5320#issuecomment-3756041813
@adamsaghy While it may not seem common, OF/of is used in specific SQL clauses and features: - MariaDB/MySQL: OF/of is a reserved word used in features like the Information Schema and certain cursor/locking operations. - PostgreSQL: While often a non-reserved keyword, it is still used in standard SQL-92/SQL3 syntax (e.g., in FETCH or FORUPDATE OF clauses), which can cause the parser to fail when it's used as an unquoted alias. - Cross-Platform Conflict: Even if one database allows it, Fineract is designed to be database-agnostic. Using OF/of as an alias is considered a "Bad Grammar" risk because it breaks the SQL parser on systems that strictly follow these reserved lists. One can rename the alias to any other valid name as long as it is not a reserved keyword. https://www.google.com/url?sa=i&source=web&rct=j&url=https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-keywords-table&ved=2ahUKEwjW9a3zhY6SAxWtR0EAHY5eGOQQqYcPegYIAQgPEAM&opi=89978449&cd&psig=AOvVaw33qoeYTUSHWsURAMw07FtV&ust=1768583718133000 And lastly reserved keywords are processed by the database engine's parser the same way regardless of case(OF/of ) -- 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]
