[
https://issues.apache.org/jira/browse/AIRFLOW-3804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jarek Potiuk resolved AIRFLOW-3804.
-----------------------------------
Resolution: Fixed
> MySqlToGoogleCloudStorageOperator success when it should fail
> -------------------------------------------------------------
>
> Key: AIRFLOW-3804
> URL: https://issues.apache.org/jira/browse/AIRFLOW-3804
> Project: Apache Airflow
> Issue Type: Bug
> Components: gcp, operators
> Reporter: jack
> Priority: Major
> Fix For: 2.0.0
>
>
> Testing the following query on MySqlToGoogleCloudStorageOperator.
>
> {code:java}
> SELECT * FROM table where modifiedTS>2000-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.
>
> Not sure if it's related but I'm running the query with SQL file using :
> filename option of the operator.
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
