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

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 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

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

blocks

MDEV-26161 crash in Gis_point::calculate_haversine

is duplicated by

MDEV-30461 Cannot use variables inside geometry construtors

relates to

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

split to

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

Estimated:

Not Specified

Remaining:

Logged:

6d 1.5h

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