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

• Type: Bug
• Status: Accepted
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.19.0
• Component/s: Storage - JDBC
• Assignee: Unassigned
• Reporter: Matthias Rosenthaler
• Created: 08/Feb/22 16:11
• Updated: 25/Feb/22 13:01

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:

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

while this one produces the same error:

SELECT * FROM `sql.medat`.`measurement` as m  WHERE `begin` > DATE_SUB(NOW(), interval '1' month)  ORDER BY `begin` DESC