feature_02_table_access

Feature: Table access

테이블을 추적합니다.

Supported Language

✔ = 지원하는 기능
❌ = 지원하지 않는 기능
⚠ = 지원 예정

MySql	PostgreSql	JSql	Oracle	SqlServer
✔	✔	✔	✔	✔

Case 1. Select all columns in table

Example Query

SELECT * FROM sample_table

Database

Database.Table = sample_db.sample_table

Columns = sample_column1, sample_column2

Expected QSI Tree

• IQsiDerivedTableNode
  • Columns
    • IQsiColumnsDeclarationNode
      • Columns
        • IQsiAllColumnNode
  • Source
    • IQsiTableAccessNode
      • Identifier = sample_table

Analyze Result

• sample_column1 (derived)
  • sample_column1 (table: sample_db.sample_table)
    • Reference : sample_db.sample_table
• sample_column2 (derived)
  • sample_column2 (table: sample_db.sample_table)
    • Reference : sample_db.sample_table

sample_table에서 *을 사용해서 전체 컬럼을 선택했으므로 sample_db의 sample_column1, sample_column2가 추적되게 됩니다.

Case 2. Select column by column name

Example Query

SELECT sample_column1, sample_column3 FROM sample_table

Database

---

Database.Table = sample_db.sample_table

Columns = sample_column1, sample_column2, sample_column3

---

Expected QSI Tree

• IQsiDerivedTableNode
  • Columns
    • IQsiColumnsDeclarationNode
      • Columns
        • IQsiDeclaredColumnNode
          • Name = sample_column1
        • IQsiDeclaredColumnNode
          • Name = sample_column3
  • Source
    • IQsiTableAccessNode
      • Identifier = sample_table

Analyze Result

• sample_column1 (derived)
  • sample_column1 (table: sample_db.sample_table)
    • Reference : sample_db.sample_table
• sample_column3 (derived)
  • sample_column3 (table: sample_db.sample_table)
    • Reference : sample_db.sample_table

sample_table에서 sample_column1과 sample_column3를 선택했으므로 두 컬럼만 추적됩니다.