Skip to content

Wrong error reported while scanning records when query contains several ordering fields #2041

Open
@NVO777

Description

Error reported while scanning such query: SELECT id, req_primary_fields FROM audit_log ORDER BY created_tstamp DESC, id ASC LIMIT 10 OFFSET 0, Error = Scan error on column index 1, name "req_primary_fields": converting NULL to string is unsupported

No error should happen here, because SELECT COUNT(id) FROM audit_log WHERE req_primary_fields IS NULL returns 0

Not sure would it be possible to reproduce it, but i attached code and log and You can analyze it
ZIP contains:
run_test.sh - how do i run the test
immu.go - Go source file
immu.log - Go test file execution output

test_20250113.zip

Environment

# run "immu* version" and copy/paste the output here

immuclient version
immuclient 1.9.4
Commit : 76cd08a
Built at: Thu, 25 Jul 2024 20:17:12 UTC

Additional info (any other context about the problem)

Activity

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

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions