[MDEV-27666] User variable not parsed as geometry variable in geometry function - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
Fix Version/s: 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3, 11.3.2, 11.4.1
Component/s: GIS, Server
Labels:
None

Description

Repeatable with

set @g=  point(1, 1);

select ST_AsWKT(GeometryCollection(Point(44, 6), @g));

ERROR 1367 (22007) at line 1: Illegal non geometric '@`g`' value found during parsing

The same bug exists in MySQL 8.0 with slightly different error message (note braces).

ERROR 1367 (22007) at line 1: Illegal non geometric '(@`g`)' value found during parsing

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

10.4-test.diff
4 kB
2024-01-22 13:10
mariadb-bin-10.5.24-geom-user-var.000001
0.7 kB
2024-01-22 13:10

Issue Links

blocks

MDEV-26161 crash in Gis_point::calculate_haversine

Stalled

is duplicated by

MDEV-30461 Cannot use variables inside geometry construtors

Closed

relates to

MDEV-26506 Over-quoted JSON when combining JSON_ARRAYAGG with JSON_OBJECT

Closed

split to

MDEV-33283 Binlog Checksum is Zeroed by Zlib if Part of Event Data is Empty

Closed

Activity

Ascending order - Click to sort in descending order

Anel Husakovic created issue - 2022-01-28 13:14

Anel Husakovic made changes - 2022-01-28 13:14

Field	Original Value	New Value
Link		This issue blocks MDEV-26161 [ MDEV-26161 ]

Sergei Golubchik made changes - 2022-01-28 19:43

Priority

Blocker [ 1 ]

Major [ 3 ]

Alexey Botchkov made changes - 2022-03-22 10:38

Status

Open [ 1 ]

In Progress [ 3 ]

Julien Fritsch made changes - 2022-05-10 09:46

Priority

Major [ 3 ]

Blocker [ 1 ]

Sergei Golubchik made changes - 2022-05-10 12:50

Priority

Blocker [ 1 ]

Critical [ 2 ]

Alexander Barkov made changes - 2022-06-08 10:16

Link

This issue relates to ~~MDEV-26506~~ [ ~~MDEV-26506~~ ]

Ralf Gebhardt made changes - 2022-08-04 09:53

Fix Version/s		10.3 [ 22126 ]
Fix Version/s	10.2 [ 14601 ]

Julien Fritsch made changes - 2022-08-15 13:44

Priority

Critical [ 2 ]

Blocker [ 1 ]

Julien Fritsch made changes - 2022-08-16 13:28

Priority

Blocker [ 1 ]

Critical [ 2 ]

Julien Fritsch made changes - 2022-08-17 13:32

Priority

Critical [ 2 ]

Blocker [ 1 ]

Julien Fritsch made changes - 2022-08-18 07:10

Priority

Blocker [ 1 ]

Critical [ 2 ]

Alexey Botchkov made changes - 2022-10-25 12:17

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Alice Sherepa made changes - 2023-01-25 12:29

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.7 [ 24805 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s		10.11 [ 27614 ]

Alice Sherepa made changes - 2023-01-25 12:29

Affects Version/s		10.7 [ 24805 ]
Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]
Affects Version/s		10.11 [ 27614 ]

Alice Sherepa made changes - 2023-01-25 12:30

Link

This issue is duplicated by ~~MDEV-30461~~ [ ~~MDEV-30461~~ ]

Julien Fritsch made changes - 2023-03-03 17:25

Fix Version/s

10.7 [ 24805 ]

Julien Fritsch made changes - 2023-04-27 13:59

Fix Version/s

10.3 [ 22126 ]

Julien Fritsch made changes - 2023-04-27 14:45

Fix Version/s

10.8 [ 26121 ]

Julien Fritsch made changes - 2023-11-28 10:21

Fix Version/s

10.9 [ 26905 ]

Julien Fritsch made changes - 2023-11-28 10:27

Fix Version/s

10.10 [ 27530 ]

Julien Fritsch made changes - 2023-12-11 18:59

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Alexey Botchkov added a comment - 2023-12-14 08:26

https://github.com/MariaDB/server/commit/1b9561fde4436568e210f96837e8351227261af8

Alexey Botchkov added a comment - 2023-12-14 08:26 https://github.com/MariaDB/server/commit/1b9561fde4436568e210f96837e8351227261af8

Alexey Botchkov made changes - 2023-12-14 08:26

Assignee	Alexey Botchkov [ holyfoot ]	Alexander Barkov [ bar ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Alexander Barkov made changes - 2023-12-29 12:48

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Alexander Barkov added a comment - 2023-12-29 12:49

Hello Alexey,

I propose instead of adding a new enum for variable data type, implement this in a more generic way using Type_handler.

Please review this version:
https://github.com/MariaDB/server/commit/7d71e9901bf171fbac0f95e290b5612beedea90f

Alexander Barkov added a comment - 2023-12-29 12:49 Hello Alexey, I propose instead of adding a new enum for variable data type, implement this in a more generic way using Type_handler. Please review this version: https://github.com/MariaDB/server/commit/7d71e9901bf171fbac0f95e290b5612beedea90f

Alexander Barkov made changes - 2023-12-29 12:49

Assignee	Alexander Barkov [ bar ]	Alexey Botchkov [ holyfoot ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Alexey Botchkov added a comment - 2024-01-16 13:04

ok to push.

Alexey Botchkov added a comment - 2024-01-16 13:04 ok to push.

Alexey Botchkov made changes - 2024-01-16 13:04

Assignee	Alexey Botchkov [ holyfoot ]	Alexander Barkov [ bar ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Alexander Barkov made changes - 2024-01-16 16:02

issue.field.resolutiondate

2024-01-16 16:02:56.0

2024-01-16 16:02:55.599

Alexander Barkov made changes - 2024-01-16 16:02

Fix Version/s		10.5.24 [ 29517 ]
Fix Version/s		10.6.17 [ 29518 ]
Fix Version/s		10.11.7 [ 29519 ]
Fix Version/s		11.1.4 [ 29024 ]
Fix Version/s		11.2.3 [ 29521 ]
Fix Version/s		11.3.2 [ 29522 ]
Fix Version/s		11.4.1 [ 29523 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.11 [ 27614 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Julien Fritsch made changes - 2024-01-16 16:06

Fix Version/s

11.0.5 [ 29520 ]

Brandon Nesterenko made changes - 2024-01-19 17:06

Link

This issue split to ~~MDEV-33283~~ [ ~~MDEV-33283~~ ]

Alexander Barkov made changes - 2024-01-22 13:10

Attachment

mariadb-bin-10.5.24-geom-user-var.000001 [ 72830 ]

Alexander Barkov made changes - 2024-01-22 13:10

Attachment

10.4-test.diff [ 72831 ]

Alexander Barkov added a comment - 2024-01-22 13:11

Verified that 10.5->10.4 replication of user variables does not break.
The 10.4 slave ignores the extra CHUNK_DATA_TYPE_NAME chunk in the User_var_log_event.

Alexander Barkov added a comment - 2024-01-22 13:11 Verified that 10.5->10.4 replication of user variables does not break. The 10.4 slave ignores the extra CHUNK_DATA_TYPE_NAME chunk in the User_var_log_event.

People

Assignee:: Alexander Barkov

Reporter:: Anel Husakovic

Votes:: 1 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2022-01-28 13:14

Updated:: 2024-01-22 13:14

Resolved:: 2024-01-16 16:02

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration