Support for System Versioned Tables and Temporal Queries for MariaDB / MySQL?

Answered

Is there some time line on when we can expect support for temporal query syntax in DataGrip?

MariaDB 10.3 support system versioned tables and I want to take advantage of them. This query does not run from inside DataGrip but works fine in the mysql CLI client. As you can probably tell, there's a lot of random (and invalid) syntax and inspection highlighting.

The error in Datagrip reads

'[42000][1064] (conn=269) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 [42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use  near '' at line 1 Query is: DESC'

As far as I understand, this means that for some reason DG decides to send the DESC as its own query...?

SELECT tmp_name,
tmp_state AS hst_state,
tmp_rowStart AS hst_timestamp,
tmp_modifiedByUserPk AS hst_modifierPk,
usr_name AS hst_modifierName
FROM DHA_TempTest
FOR SYSTEM_TIME ALL
LEFT JOIN DHA_Users ON usr_primaryKey = tmp_modifiedByUserPk
WHERE tmp_primaryKey = 1
AND tmp_groupPk = 1
ORDER BY tmp_rowStart DESC;
2 comments

>> This query does not run from inside DataGrip

To execute your query one need to set "Exactly as one statement" option for selection execution:

 

I created an issue base on your request https://youtrack.jetbrains.com/issue/DBE-7213

2

Please sign in to leave a comment.