jack created AIRFLOW-3804:
-----------------------------
Summary: MySqlToGoogleCloudStorageOperator success when it should
fail
Key: AIRFLOW-3804
URL: https://issues.apache.org/jira/browse/AIRFLOW-3804
Project: Apache Airflow
Issue Type: Bug
Reporter: jack
Testing the following query on MySqlToGoogleCloudStorageOperator.
{code:java}
SELECT * FROM table where modifiedTS>200-01-01 00:00:00 and modifiedTS<=
2019-02-04 13:55:21{code}
The operator runs smoothly and report success so airflow continue to execute
the down stream of the operator.
However this query is invalid.
Running it on MySQL will give:
{code:java}
Error Code: 1064. You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'00:00:00 and modifiedTS<= 2019-02-04 13:55:21' at line 11{code}
The operator should have *FAILD* when running this query it has syntax error.
There is probably a problem with how this operator treats the result of this
query and confuses it with valid result of no rows returned.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
