Skip to content

HTTP driver don't support the boolean type #396

@irtimir

Description

@irtimir

Describe the bug
If a column has a boolean type, then in Python it becomes a string.

To Reproduce

engine = create_engine('clickhouse+http://...')

t = Table(
    'table',
    Column('is_something', Boolean),
)

with engine.connect() as conn:
    query = select(t.c.is_something).select_from(t)
    result = list(conn.execute(query))
    print(result[0][0])

Expected behavior
Bool type is converted to bool

Versions

  • clickhouse-sqlalchemy v0.3.2
  • Python 3.12

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions