Support for System Versioned Tables and Temporal Queries for MariaDB / MySQL? Follow
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;
Please sign in to leave a comment.
>> 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
Thank you, Vasily. That helps!