Skip to content

bug: querying data through SQL doesn't work #172

Description

@honzakostejn

Problem

When querying data from tables, the call fails with duplicate header error. I suspect the issue is in tables where there is 5k+ records. Wasn't investigating properly.

Repro

dnx TALXIS.CLI -- environment data query sql "SELECT TOP 5 talxis_addressid FROM talxis_address" -p devbox-kos-pct24002-01
14:18:17+02:00 [INFO]  Resolved target environment 'https://devbox-kos-pct24002-01.crm4.dynamics.com' using profile 'devbox-kos-pct24002-01', connection 'devbox-kos-pct24002-01', credential 'jan.kostejn@thenetw.org' (source: CommandLine).
14:18:17+02:00 [INFO]  Resolved target environment 'https://devbox-kos-pct24002-01.crm4.dynamics.com' using profile 'devbox-kos-pct24002-01', connection 'devbox-kos-pct24002-01', credential 'jan.kostejn@thenetw.org' (source: CommandLine).
14:18:17+02:00 [INFO]  Resolved target environment 'https://devbox-kos-pct24002-01.crm4.dynamics.com' using profile 'devbox-kos-pct24002-01', connection 'devbox-kos-pct24002-01', credential 'jan.kostejn@thenetw.org' (source: CommandLine).
An item with the same key has already been added. Key: Cookie
14:18:19+02:00 [ERROR] Command failed: An item with the same key has already been added. Key: Cookie
14:18:19+02:00 [INFO]  If this is unexpected, report at https://github.com/TALXIS/tools-cli/issues
  Session: e77ec090-b8b5-40b4-a072-05f67ed4067c
  Operation: 40288463d8c5858e3ee44d13f0e512ba
  Logs: /tmp/nix-shell.xBpvLb/txc/logs/session-e77ec090-b8b5-40b4-a072-05f67ed4067c.jsonl

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions