[MDEV-30229] In view definition (in .frm) 'multipoint' is changed to 'geometrycollection' that causes internal error Created: 2022-12-14  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Lena Startseva Assignee: Alexey Botchkov
Resolution: Unresolved Votes: 0
Labels: view-protocol

Attachments: File v1.frm    
Issue Links:
PartOf
is part of MDEV-27691 make working view-protocol Open

 Description   

Test:

select st_distance_sphere(point(0,90), multipoint(point(24,20)));
 
create view v1 as select st_distance_sphere(point(0,90), multipoint(point(24,20)));
select * from v1;
 
drop view v1;

Expected result:

st_distance_sphere(point(0,90), multipoint(point(24,20)))
7783627.7608924415
 
st_distance_sphere(point(0,90), multipoint(point(24,20)))
7783627.7608924415

Actual result:

st_distance_sphere(point(0,90), multipoint(point(24,20)))
7783627.7608924415
 
At line 4: query 'select * from v1' failed: 1815: Internal error: st_distance_sphere


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