[coverage] Conformance findings: METADATA-035,METADATA-036

Bắt đầu với diff của tests/ trong coverage PR và lần theo session.getTables() cho METADATA-035, kiểm tra hành vi của tableTypes rỗng. Sau đó, kiểm tra đường dẫn metadata SEA cho METADATA-036 và cách xử lý việc đóng statement của nó. Hoàn tất khi các trường hợp xfail được tham chiếu chuyển sang xanh cho cả hành vi của tableTypes=[] và các CLOSED metadata statements.

Summary

Surfaced by the multi-language coverage fan-out while conformance-testing these SPEC-IDs against databricks/databricks-sql-nodejs. 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-nodejs) is fixed, then flips green as a tripwire.

Findings

• METADATA-035 [thrift, sea]: session.getTables() treats an empty tableTypes array as "match none" and returns 0 rows instead of behaving like a null filter and matching ALL table types (adbc-drivers/hiveserver2#72)
  • failing test: getTables — tableTypes=[] (empty, non-null) matches ALL table types [xfail: driver bug] [thrift], getTables — tableTypes=[] (empty, non-null) matches ALL table types [xfail: driver bug] [sea] (see the coverage PR diff under tests/)
• METADATA-036 [sea]: the SEA metadata path sends a redundant CloseStatement DELETE even when the metadata ExecuteStatement response reported status.state=CLOSED; the driver's regular-query path honors the terminal state correctly, so this is metadata-specific
  • failing test: METADATA-036 — metadata statement close honors ExecuteStatement status.state [sea] (see the coverage PR diff under tests/)

Context

• The behavior was first fixed in a DIFFERENT driver — reference PR: https://github.com/databricks/databricks-sql-kernel/pull/183 — which seeded the shared language-neutral spec. This issue tracks the same conformance gap in databricks/databricks-sql-nodejs; the reference PR is for cross-referencing the intended behavior, NOT a change to this repo.
• Coverage PR carrying the reproducing xfail test(s): https://github.com/databricks/databricks-driver-test/pull/1021