cloudflare / cloudflare/sqlalchemy-clickhouse

Error in Nullable fields

Open
#18 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
325
Forks
101
PR merge metrics
No merged PRs in 30d

Description

Hello.

I have problems when I do a Select with fields declared as Nullable in a ClickHouse Database.

Field1 String,
Field2 Nullable(String),

Example:
SELECT Field1 FROM Table1 --> WORKS !!

SELECT Field1, Field2 FROM Table1 ERROR!!! -- "No field class for Nullable(String)"

![image](https://user-images.githubusercontent.com/23501646/35154701-8096f6d0-fd2b-11e7-9009-508eddcce125.png)

Contributor guide

Open the contributing guide

Research direction

No source files or tests are named. Start by reproducing the SELECT against a ClickHouse table containing String and Nullable(String) fields, then trace how the returned Nullable(String) type is mapped; done means selecting both fields succeeds without the reported error.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.