Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

1.9 KB
Raw Blame
- description: Uncorrelated Subquery In From Clause
  statement: SELECT A, B, C, D FROM (SELECT * FROM T1) T;
  defaultDatabase: SNOWFLAKE
  ignoreCaseSensitive: true
  metadata: |-
    {
      "name":  "SNOWFLAKE",
      "schemas":  [
        {
          "name": "PUBLIC",
          "tables":  [
            {
              "name":  "T1",
              "columns":  [
                {
                  "name":  "A"
                },
                {
                  "name":  "B"
                },
                {
                  "name":  "C"
                },
                {
                  "name":  "D"
                }
              ]
            }
          ]
        }
      ]
    }
  querySpan:
    type: 1
    results:
        - name: A
          sourcecolumns:
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: A
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: B
          sourcecolumns:
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: B
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: C
          sourcecolumns:
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: C
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: D
          sourcecolumns:
            - server: ""
              database: SNOWFLAKE
              schema: PUBLIC
              table: T1
              column: D
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: SNOWFLAKE
          schema: PUBLIC
          table: T1
          column: ""
    predicatecolumns: []