Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Schema inference does not work when having Materialized columns. #51817

Closed
ucasfl opened this issue Jul 5, 2023 · 0 comments · Fixed by #51825
Closed

Schema inference does not work when having Materialized columns. #51817

ucasfl opened this issue Jul 5, 2023 · 0 comments · Fixed by #51825
Assignees
Labels

Comments

@ucasfl
Copy link
Collaborator

ucasfl commented Jul 5, 2023

CREATE TABLE test
(
    `n1` UInt32,
    `n2` UInt32 MATERIALIZED murmurHash3_32(n1)
)
ENGINE = MergeTree
ORDER BY n1

Query id: 4901fc56-0d31-466a-bec5-c1bc8f2fdfd3

Ok.

0 rows in set. Elapsed: 0.009 sec. 

:) insert into test select * from generateRandom();

INSERT INTO test SELECT *
FROM generateRandom()

Query id: 8525398b-c023-487c-9a5f-e22663ca761a


0 rows in set. Elapsed: 0.002 sec. 

Received exception from server (version 23.6.1):
Code: 20. DB::Exception: Received from localhost:9000. DB::Exception: Number of columns doesn't match. (NUMBER_OF_COLUMNS_DOESNT_MATCH)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
1 participant