[MDEV-22288] JSON_TABLE: ORDINALITY column starts from 0 instead of 1 - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: N/A
Fix Version/s: N/A
Component/s: JSON
Labels:
None

Description

Both MySQL 8.0 manual and the standard excerpt linked from ~~MDEV-17399~~ say that ORDINALITY column values start from 1. In MariaDB implementation, they start from 0.

bb-10.5-hf 6dfb3fab2
select * from json_table('{"a":"b"}',"$" columns(a for ordinality)) foo;
+------+
\| a \|
+------+
\| 0 \|
+------+
1 row in set (0.001 sec)

MySQL 8.0.19
select * from json_table('{"a":"b"}',"$" columns(a for ordinality)) foo;
+------+
\| a \|
+------+
\| 1 \|
+------+
1 row in set (0.00 sec)

Attachments

Issue Links

relates to

MDEV-17399 Add support for JSON_TABLE

Closed

Activity

People

Assignee:: Alexey Botchkov

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2020-04-18 14:36

Updated:: 2020-04-20 10:59

Resolved:: 2020-04-20 10:58

Git Integration

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