[
https://issues.apache.org/jira/browse/DRILL-8128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matthias Rosenthaler updated DRILL-8128:
----------------------------------------
Description:
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}
was:
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}
> 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
>
>
> 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}
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
