Skip to content

bug: INSERT of object (Variant) with Null values fails #13640

@yahyaakli

Description

@yahyaakli

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

I am trying to insert an object to a column of type VARIANT with a null value (None in my python script) and I get this error:

ERROR: (1304): e6f67857-467d-4aa8-800b-44cf4da7a73a: 001007 (22023): invalid type [TO_OBJECT(A)] for parameter 'TO_OBJECT'

Expected Behavior

No response

How are you starting LocalStack?

With a docker-compose file

Steps To Reproduce

I am orchestrating localstack through docker-compose

services:
  localstack:
    extends:
      file: ../../.docker/templates/docker-compose.yaml
      service: localstack
    volumes:
      - ~/var/lib/localstack:/~var/lib/localstack
    env_file:
      - .env

Then run
docker compose -f ./tests/integration/compose.yaml build
docker compose -f ./tests/integration/compose.yaml up -d

Environment

- OS: Mac
- LocalStack:
  LocalStack version: latest
  LocalStack Docker image sha: sha256:b10d4627a112317e24ba28e16af9a2b49357ca58f4ee684313addd0ff0878ccd
  LocalStack build date: 2026-01-22T16:28:00.632921Z

Anything else?

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    Snowflake: generalIssues related to LocalStack for Snowflake emulatorstatus: backlogTriaged but not yet being worked ontype: bugBug report

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions