insert into t_trajectory values (st_traj_fromGeoJSON( '{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"time":"2018-10-09 07:30:41.0"},"geometry":{"type":"Point","coordinates":[108.93430687732173,34.2154503607423]}},{"type":"Feature","properties":{"time":"2018-10-09 07:30:56.0"},"geometry":{"type":"Point","coordinates":[108.93428701026465,34.21445074385308]}}],"properties":{"oid":"9ae8398a7748c9c5ed8ad60f7c5436d7","tid":"9ae8398a7748c9c5ed8ad60f7c5436d72018-10-09 07:30:41.0"}}' ));
insert into t_roadSegment values (st_rs_fromGeoJSON('{"type":"Feature","properties":{"endId":70832,"level":3,"startId":70831,"rsId":100320,"speedLimit":50.0,"lengthInMeter":50.57964091335451,"direction":1},"geometry":{"type":"LineString","coordinates":[[108.88093234592,34.1634619140625],[108.881090494792,34.1630268012153]]}}'));
select from t_trajectory;
select from t_roadSegment;
select from t_trajectory where trajectory20 = st_traj_fromGeoJSON( '{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"time":"2018-10-09 07:30:41.0"},"geometry":{"type":"Point","coordinates":[108.93430687732173,34.2154503607423]}},{"type":"Feature","properties":{"time":"2018-10-09 07:30:56.0"},"geometry":{"type":"Point","coordinates":[108.93428701026465,34.21445074385308]}}],"properties":{"oid":"9ae8398a7748c9c5ed8ad60f7c5436d7","tid":"9ae8398a7748c9c5ed8ad60f7c5436d72018-10-09 07:30:41.0"}}' );
select from t_roadSegment where roadSegment21 = st_rs_fromGeoJSON('{"type":"Feature","properties":{"endId":70832,"level":3,"startId":70831,"rsId":100320,"speedLimit":50.0,"lengthInMeter":50.57964091335451,"direction":1},"geometry":{"type":"LineString","coordinates":[[108.88093234592,34.1634619140625],[108.881090494792,34.1630268012153]]}}');
轨迹和路段，不带where直接查询可以正常返回，加了对应字段的等值查询条件后查询报错 示例SQL create table t_trajectory (trajectory20 trajectory); create table t_roadSegment (roadSegment21 roadSegment);
insert into t_trajectory values (st_traj_fromGeoJSON( '{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"time":"2018-10-09 07:30:41.0"},"geometry":{"type":"Point","coordinates":[108.93430687732173,34.2154503607423]}},{"type":"Feature","properties":{"time":"2018-10-09 07:30:56.0"},"geometry":{"type":"Point","coordinates":[108.93428701026465,34.21445074385308]}}],"properties":{"oid":"9ae8398a7748c9c5ed8ad60f7c5436d7","tid":"9ae8398a7748c9c5ed8ad60f7c5436d72018-10-09 07:30:41.0"}}' )); insert into t_roadSegment values (st_rs_fromGeoJSON('{"type":"Feature","properties":{"endId":70832,"level":3,"startId":70831,"rsId":100320,"speedLimit":50.0,"lengthInMeter":50.57964091335451,"direction":1},"geometry":{"type":"LineString","coordinates":[[108.88093234592,34.1634619140625],[108.881090494792,34.1630268012153]]}}'));
select from t_trajectory; select from t_roadSegment;
select from t_trajectory where trajectory20 = st_traj_fromGeoJSON( '{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"time":"2018-10-09 07:30:41.0"},"geometry":{"type":"Point","coordinates":[108.93430687732173,34.2154503607423]}},{"type":"Feature","properties":{"time":"2018-10-09 07:30:56.0"},"geometry":{"type":"Point","coordinates":[108.93428701026465,34.21445074385308]}}],"properties":{"oid":"9ae8398a7748c9c5ed8ad60f7c5436d7","tid":"9ae8398a7748c9c5ed8ad60f7c5436d72018-10-09 07:30:41.0"}}' ); select from t_roadSegment where roadSegment21 = st_rs_fromGeoJSON('{"type":"Feature","properties":{"endId":70832,"level":3,"startId":70831,"rsId":100320,"speedLimit":50.0,"lengthInMeter":50.57964091335451,"direction":1},"geometry":{"type":"LineString","coordinates":[[108.88093234592,34.1634619140625],[108.881090494792,34.1630268012153]]}}');