[MDEV-22288] JSON_TABLE: ORDINALITY column starts from 0 instead of 1 Created: 2020-04-18  Updated: 2020-04-20  Resolved: 2020-04-20

Status: Closed
Project: MariaDB Server
Component/s: JSON
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-17399 Add support for JSON_TABLE Closed

 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)


Generated at Thu Feb 08 09:13:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.