tolebiermekov opened a new pull request, #44210: URL: https://github.com/apache/airflow/pull/44210
Oracle SQL does not permit the use of the AS keyword when aliasing subqueries. While AS is valid for column and table aliases in some contexts, subquery aliases must not include the keyword AS. This PR addresses this limitation in the SQLTableCheckOperator. Changes: Updated the SQLTableCheckOperator to handle Oracle-specific SQL syntax by omitting the AS keyword for subquery aliases. Introduced a check to determine the database type, ensuring this adjustment is applied only for Oracle SQL. Added relevant unit tests to ensure compatibility across supported databases. Closes: Closes [#44135](https://github.com/apache/airflow/issues/44135). Notes: This change ensures that Airflow's SQLTableCheckOperator works seamlessly with Oracle SQL while maintaining compatibility with other databases. -- 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]
