Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

binary、polygon、multiPolygon、geometryCollection字段查询报错 #286

Open
ihongyang opened this issue Jun 29, 2022 · 2 comments
Open
Assignees
Labels
bug Something isn't working

Comments

@ihongyang
Copy link
Contributor

create table t_binary (binary9 binary);
create table t_polygon (polygon15 polygon);
create table t_MultiPolygon (MultiPolygon18 MultiPolygon);
create table t_GeometryCollection (GeometryCollection19 GeometryCollection);

insert into t_binary values (st_asWKB(st_geomfromwkt("Point(10 20)")));
insert into t_polygon values (st_PolygonFromWkt("POLYGON ((1 2, 1 4, 3 4, 3 2, 1 2))"));
insert into t_MultiPolygon values (st_mPolygonFromWkt("MULTIPOLYGON(((1 1,5 1,5 5,1 5,1 1),(2 2,2 3,3 3,3 2,2 2)),((6 3,9 2,9 4,6 3)))"));
insert into t_GeometryCollection values (st_GeomFromWkt("GEOMETRYCOLLECTION(MULTIPOINT(-2 3,-2 2), LINESTRING(5 5,10 10), POLYGON((-7 4.2,-7.1 5,-7.1 4.3,-7 4.2)))"));

select * from t_binary ;
select * from t_polygon ;
select * from t_MultiPolygon ;
select * from t_GeometryCollection ;

image

@ihongyang ihongyang added the bug Something isn't working label Jun 29, 2022
@zaiyuan-ljw
Copy link
Contributor

这部分的异常是因为插入的数据其实是字节数组,这块儿在引擎侧是可以展示的,但是到了客户端有问题,可能需要鹏哥看一下,需不需要在服务层的数据转发时,添加一些规则。 @jimolonely

@ihongyang
Copy link
Contributor Author

ihongyang commented Aug 1, 2022

@jimolonely 辛苦鹏哥协助看下这个问题,目前polygon、multiPolygon、geometryCollection这三种类型,插入数据后还是查询报错
binary类型,不插入输入的情况下,查询就报错了
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants