[
https://issues.apache.org/jira/browse/AIRFLOW-3804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16759876#comment-16759876
]
jack commented on AIRFLOW-3804:
-------------------------------
[~ashb] you misread :) I know that I'm missing quoting. This isn't a debug
issue.
The query should be:
{code:java}
SELECT * FROM table where modifiedTS>'2000-01-01 00:00:00' and modifiedTS<=
'2019-02-04 13:55:21'
{code}
But that is not the issue.
The issue is that operator report success for a query that has syntax error :
{code:java}
SELECT * FROM table where modifiedTS>2000-01-01 00:00:00 and modifiedTS<=
2019-02-04 13:55:21
{code}
The operator should fail for this query but it doesn't.
It seems like no matter which query you will run it will be success.
> 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
> Priority: Major
>
> 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.
>
> 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
(v7.6.3#76005)
