[jira] (DRILL-8128) ORDER BY DESC is not working for JDBC mariadb storage plugin

["Matthias Rosenthaler (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-8128 ]


    Matthias Rosenthaler deleted comment on DRILL-8128:
    ---------------------------------------------

was (Author: matthros):
Further drill 1.19 rest api returns the timestamp as integer now, before it was a formatted date-string

> ORDER BY DESC is not working for JDBC mariadb storage plugin
> ------------------------------------------------------------
>
>                 Key: DRILL-8128
>                 URL: https://issues.apache.org/jira/browse/DRILL-8128
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JDBC
>    Affects Versions: 1.19.0
>            Reporter: Matthias Rosenthaler
>            Priority: Major
>             Fix For: 1.20.0
>
>         Attachments: drill_error.png, drillbit_log.png
>
>
> If I try to use a ORDER BY DESC clause for my jdbc mariadb storage plugin, it always fails with the attached error message.
> ORDER BY ASC is working perfectly.
>  
> I am using mariadb-java-client-3.0.3.jar and mariadb v {{{}10.5.4{}}}{*}{{*}}
> edit: If I add a where clause the query is also working, although the result set contains all results like without the clause:
> {code:java}
> SELECT * FROM `sql.medat`.`measurement` as m  WHERE TO_DATE( m.`begin`)  >= TO_DATE( '08.02.1970', 'dd.MM.yyyy') AND TO_DATE( m.`begin`) <= TO_DATE( '08.02.2030', 'dd.MM.yyyy') ORDER BY `begin` DESC{code}
> while this one produces the same error:
> {code:java}
> SELECT * FROM `sql.medat`.`measurement` as m  WHERE `begin` > DATE_SUB(NOW(), interval '1' month)  ORDER BY `begin` DESC{code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)