Skip to content

查询超级表时TIMESTAMP字段作为条件和GEOMETRY作为条件都可以正常查询,两个字段同时作为条件查询报错!!! #34534

@ZzzzzzlzzzzzZ

Description

@ZzzzzzlzzzzzZ
-- 第一个sql
select
	*
from
	vehicle_location
where
	ts >= '2026-02-07 08:00:00'
	and ts <= '2026-02-07 08:10:00'

-- 第二个sql
select
	*
from
	vehicle_location
where
	ST_Contains(ST_GeomFromText('POLYGON((116.39 39.90, 116.41 39.90, 116.41 39.92, 116.39 39.92, 116.39 39.90))'), loc)

-- 第三个sql
select
	*
from
	vehicle_location
where
	ts >= '2026-02-07 08:00:00'
	and ts <= '2026-02-07 08:10:00'
	and ST_Contains(ST_GeomFromText('POLYGON((116.39 39.90, 116.41 39.90, 116.41 39.92, 116.39 39.92, 116.39 39.90))'), loc)

vehicle_location是一个超级表, 第一条和第二条的条件可以正常执行,条件合并后的第三条sql无法执行。

TDengine TSDB-OSS 3.3.8.8

下面是vehicle_location表结构
Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions