[MDEV-32456] incorrect result of gis function in view protocol Created: 2023-10-12  Updated: 2023-12-12

Status: Open
Project: MariaDB Server
Component/s: GIS
Affects Version/s: 10.4.31, 10.5.22, 10.6.15, 10.10.6, 10.11.5, 11.0.3
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Major
Reporter: Oleksandr Byelkin Assignee: Alexey Botchkov
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-27871 View is created with wrong column nam... Stalled

 Description   

After removing disabling view protocol found incorrect result of gis finction:

--- /home/sanja/maria/git/10.4/mysql-test/main/gis.result	2023-10-12 20:35:38.674266836 +0200
+++ /home/sanja/maria/git/10.4/mysql-test/main/gis.reject	2023-10-12 20:37:25.670497807 +0200
@@ -698,10 +698,10 @@
 drop table t1;
 select (asWKT(geomfromwkb((0x000000000140240000000000004024000000000000)))) as exp;
 exp
-POINT(10 10)
+NULL
 select (asWKT(geomfromwkb((0x010100000000000000000024400000000000002440)))) as exp;
 exp
-POINT(10 10)
+NULL
 create table t1 (g GEOMETRY);
 select * from t1;
 Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr

as test case uncomment disabling of the view protocol marked #enable after MDEV-32456


Generated at Thu Feb 08 10:31:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.