Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
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
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to TODO-2305 [ TODO-2305 ] |
| Link | This issue relates to MENT-659 [ MENT-659 ] |
| Link |
This issue relates to |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 107384 ] | MariaDB v4 [ 157632 ] |