Skip to content

关联查询时,在查询语句中输入第2个表的别名后无法引出第2个表的字段 #1908

Description

@Gary-SentrixAutomation

Chat2DB Edition

Chat2DB Local

Chat2DB Version

Chat2DB Local5.3.0

Deployment

Desktop

Operating System

Windows

Operating System Version

11

Database and Version

No response

Problem Summary

关联查询时,在查询语句中输入第2个表的别名后无法引出第2个表的字段

Steps to Reproduce

  1. 启动chat2db应用,并连接要查询的数据表
  2. 在查询面板中输入关联查询语句
    WITH static_shelf_trigger as (
    SELECT a.container_id,a.container_slot_code,a.threshold,a.work_station_id,a.capacity,a.refill_trigger,a.sku_id,b.sku_code,b.fifo_flag FROM w_static_container a,m_sku_main_data b where a.sku_id=b.id
    )

Expected Behavior

在查询语句中输入b.时无法显示别名为b的表中的字段

Actual Behavior

在查询语句中输入b.时可以显示别名为b的表中的字段

Logs

Screenshots or Additional Context

No response

Impact

Data loss

Workaround

No known workaround

Submission Checklist

  • I reproduced this on the selected Chat2DB edition.
  • I searched existing issues for duplicates.
  • I removed credentials and private data.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions