Repository navigation
[Bug]: Some flinksql grammar errors #464
Description
Version
latest
Which SQL?
Flink
SQL content
SELECT * FROM orders ORDER BY price * quantity ASC LIMIT 10;
INSERT INTO Paimon.iov_paimon_prd.ods_track_vcos_log_prs_hi
SELECT
vin AS vin, -- 车架号
-- Kafka时间戳转毫秒级（含毫秒精度）
UNIX_TIMESTAMP(DATE_FORMAT(kafka_timestamp, 'yyyy-MM-dd HH:mm:ss')) * 1000
+ EXTRACT(MILLISECOND FROM kafka_timestamp) AS kafka_ts -- Kafka时间戳（毫秒）
FROM ods_track_vcos_log_prs_rt2
WHERE JSON_VALUE(parse_track_pb(data), '$.eid') = '1570001000';
INSERT INTO Paimon.iov_paimon_prd.ods_track_vcos_log_prs_hi
SELECT
vin AS vin, -- 车架号
-- Kafka时间戳转毫秒级（含毫秒精度）
UNIX_TIMESTAMP(DATE_FORMAT(kafka_timestamp, 'yyyy-MM-dd HH:mm:ss')) * 1000
+ EXTRACT(MILLISECOND FROM kafka_timestamp) AS kafka_ts -- Kafka时间戳（毫秒）
FROM ods_track_vcos_log_prs_rt2
WHERE JSON_VALUE(parse_track_pb(data), '$.eid' RETURNING STRING) = '1570001000';JavaScript/TypeScript code
What happened?
- ORDER BY + expression
- EXTRACT 函数
- JSON_VALUE RETURNING
https://nightlies.apache.org/flink/flink-docs-release-1.16/docs/dev/table/functions/systemfunctions/
Relevant log output
Metadata
Metadata
Assignees
Labels
No labels
Activity
fix: DTStack#464 order by + expression
fix: DTStack#464 EXTRACT function
fix: DTStack#464 order by + expression
fix: DTStack#464 EXTRACT function
fix: DTStack#464 JSON_VALUE RETURNING
fix: DTStack#464 order by + expression
fix: DTStack#464 EXTRACT function
fix: DTStack#464 JSON_VALUE RETURNING
fix: DTStack#464 order by + expression
fix: DTStack#464 EXTRACT function
fix: DTStack#464 JSON_VALUE RETURNING
Cythia828 commentedon Mar 4, 2026
JSON_VALUE相关的修复在这里做过了#459
但是没有发版，你可以操作下发个版然后将monaco-sql-languages的dt-sql-parser升级到最新版本，再去看你的SQL有什么问题
liuxy0551 commentedon Mar 5, 2026
#459 修改可以解决我的其中一个问题，支持了
RETURNING columnType，关联 PR 仅添加一个相关单测 sqlfix: DTStack#464 order by + expression
fix: DTStack#464 EXTRACT function
test: DTStack#464 flink JSON_VALUE RETURNING
fix(flink): some grammar rules (DTStack#465)
Next merge main (#468)
merge branch next to main, next version(4.5.0) content (#474)