[MDEV-15975] PL/SQL parser does not understand historical queries - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL)
Fix Version/s: 10.3.7
Component/s: Parser, Versioned Tables
Labels:
None

Description

I don't know if it should actually work. If not, please pass it over to documentation.

MariaDB [test]> SET sql_mode=ORACLE;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> SELECT * FROM t FOR SYSTEM_TIME ALL;

ERROR 1064 (42000): 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 'SYSTEM_TIME ALL' at line 1

Attachments

Issue Links

is blocked by

MDEV-16202 Latest changes made erroneously some keywords reserved in sql_mode=ORACLE

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2018-04-22 14:22

Alexander Barkov made changes - 2018-05-17 11:21

Field	Original Value	New Value
Link		This issue is blocked by ~~MDEV-16202~~ [ ~~MDEV-16202~~ ]

Alexander Barkov made changes - 2018-05-18 11:49

issue.field.resolutiondate

2018-05-18 11:49:24.0

2018-05-18 11:49:24.396

Alexander Barkov made changes - 2018-05-18 11:49

Fix Version/s		10.3.7 [ 23005 ]
Fix Version/s	10.3 [ 22126 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:47

Workflow

MariaDB v3 [ 86714 ]

MariaDB v4 [ 154219 ]

People

Assignee:: Alexander Barkov

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-04-22 14:22

Updated:: 2018-05-18 11:49

Resolved:: 2018-05-18 11:49

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server