Mysql函数CONTAINS和GEOMFROMTEXT不起浸染

以是我有这种要领,它包括来自mysql的几许函数：

select *,(SELECT SUM(t_o.value) FROM tree_operations t_o WHERE t_o.operation_id = operations.id) operationTreeValue,(SELECT COUNT(t_o.id)  FROM `tree_operations` t_o WHERE t_o.operation_id = operations.id) operationTreeNumber,(CASEr                          WHEN operations.type = 'pieces' THEN (SELECT GROUP_CONCAT(p.name) FROM `pieces` p WHERE p.id IN (SELECT piece_id FROM `piece_row_operations` WHERE operation_id = operations.id))r                          WHEN operations.type = 'rows' THEN (SELECT GROUP_CONCAT(r.number) FROM `rows` r WHERE r.id IN (SELECT row_id FROM `piece_row_operations` WHERE operation_id = operations.id))r                          END) AS typeName from `operations` where operations.id IN (SELECT t_o.operation_id FROM `tree_operations` t_o WHERE t_o.tree_id IN (SELECT t.id FROM `trees` t WHERE t.coordinates IN (Contains(GeomFromText('POLYGON(49.816472 35.971209,49.7868 35.970981,49.788668 35.947219,49.15201 35.947905,49.816472 35.971209)'))))) order by `operations`.`id` desc

可是令人惊奇的是,它在处事器上不起浸染(尽量在当地完全可以)
在耗费大量时刻(在差异情形中运行查询等)之后,我无法获得任何靠得住的谜底.
我的查询有什么题目吗？照旧不回复浸染的成果？
p.s：喂授当地的mysql版本是5.7,处事器是mariadb 10.2 最佳谜底 从MySQL 5.7.6开始不保举行使某些GeomFromText()函数.

行使MariaDB @ latest&&改为行使ST_GeomFromText()和ST_(其他函数)

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!