jimmy-boss opened a new issue, #66203: URL: https://github.com/apache/doris/issues/66203
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 4.1.1 ### What's Wrong? ```sql CREATE TABLE IF NOT EXISTS test_db.test_tz_v3 ( uuid varchar(256) NOT NULL COMMENT '唯一标识', created_at TIMESTAMPTZ(3) DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间' ) ENGINE=OLAP UNIQUE KEY(uuid) COMMENT '' DISTRIBUTED BY HASH(uuid) BUCKETS 2 PROPERTIES ( "storage_format" = "V3", -- 使用v3存储格式时,会出现order TIMESTAMPTZ 报错 "store_row_column" = "true" ); ``` ```sql SELECT * FROM inland_ test_db.test_tz_v3 ORDER BY updated_at DESC LIMIT 0, 20; ``` 报错： meet invalid type, type=TIMESTAMPTZ, expr=TExprNode(node_type=SLOT_REF, type=TTypeDesc(types=[TTypeNode(type=SCALAR, scalar_type=TScalarType(type=TIMESTAMPTZ, len=<null>, precision=18, scale=3, variant_max_subcolumns_count=0, variant_enable_doc_mode=0), struct_fields=<null>, contains_null=<null>, contains_nulls=<null>)], is_nullable=<null>, byte_size=-1, sub_types=<null>, result_is_nullable=<null>, function_name=<null>, be_exec_version=<null>), opcode=<null>, num_children=0, agg_expr=<null>, bool_literal=<null>, case_expr=<null>, date_literal=<null>, float_literal=<null>, int_literal=<null>, in_predicate=<null>, is_null_pred=<null>, like_pred=<null>, literal_pred=<null>, slot_ref=TSlotRef(slot_id=37, tuple_id=0, col_unique_id=37, is_virtual_slot=0), string_literal=<null>, tuple_is_null_pred=<null>, info_func=<null>, decimal_literal=<null>, output_scale=-1, fn_call_expr=<null>, large_int_literal=<null>, output_column=<null>, output_type=<null>, vector_opcode=<null>, fn=<null>, vara rg_start_idx=<null>, child_type=<null>, is_nullable=1, json_literal=<null>, schema_change_expr=<null>, column_ref=<null>, match_predicate=<null>, ipv4_literal=<null>, ipv6_literal=<null>, label=updated_at, timev2_literal=<null>, varbinary_literal=<null>, is_cast_nullable=<null>, search_param=<null>, short_circuit_evaluation=<null> ### What You Expected? 不报错 ### How to Reproduce? 建表时设置属性 "storage_format" = "V3" 且 设置一个字段为 created_at TIMESTAMPTZ(3) 在进行 select查询时使用 TIMESTAMPTZ 进行order 排序 ### Anything Else? _No response_ ### Are you willing to submit PR? - [x] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
