Skip to content

[coverage] Conformance findings: RESULTFETCH-205401 #548

Closed

Description

@peco-engineer-bot

Summary

Surfaced by the multi-language coverage fan-out while conformance-testing these SPEC-IDs against databricks/databricks-sql-go. Each finding is committed as an expected-failure (xfail) test in the coverage PR — the test asserts the CORRECT (post-fix) behavior and stays red until THIS driver (databricks/databricks-sql-go) is fixed, then flips green as a tripwire.

Findings

  • RESULTFETCH-205401 [sea]: kernel/SEA backend panics ("arrow: duplicate field with name") importing the C Arrow schema for a result with two same-named columns, instead of delivering both columns positionally — arrow-go's arrow.StructOf rejects duplicate field names in internal/backend/kernel/rows.go
    • failing test: TestSameNamedResultColumnsAllPreserved (see the coverage PR diff under tests/)

Reproduce & Expected

RESULTFETCH-205401 — A result whose schema contains TWO columns with the SAME name (e.g.

Reproduce:

  • Read the result POSITIONALLY (Node.js: pass rowMode: 'array' to
    executeStatement; other drivers use their native by-index accessor) and
    read the result metadata/schema. ORDER BY 1 orders by the first select
    item by ordinal — ordering by the name a would be ambiguous because both
    output columns carry that name.

Expected (per the shared spec):

  • completes without an exception
  • result has 2 column(s)
  • col 0 is named a
  • col 1 is named a
  • result has exactly 2 row(s)
  • col 0, row 0 == 0 (type Int64)
  • col 1, row 0 == '0' (type String)
  • col 0, row 1 == 1 (type Int64)
  • col 1, row 1 == '1' (type String)

Context

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions