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

MaterializeMySQL -- Code: 47, e.displayText() = DB::Exception: Missing columns #25794

Closed
th997 opened this issue Jun 28, 2021 · 0 comments
Closed
Assignees
Labels
comp-mysql experimental feature Bug in the feature that should not be used in production

Comments

@th997
Copy link

th997 commented Jun 28, 2021

mysql

CREATE TABLE datatest.test1 (
  id int(11) NOT NULL AUTO_INCREMENT,
  c1 varchar(32) NOT NULL,
  c2 varchar(32),
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

insert into datatest.`test1`(c1,c2) values ('a','b');
insert into datatest.`test1`(c1) values ('c');

clickhouse (version 21.6.5.37 (official build))

CREATE DATABASE datatest ENGINE = MaterializeMySQL('localhost:3306', 'datatest', 'root', 'xxx');

query

select count(c1) from datatest.test1 where c2='b';

throw error

Code: 47, e.displayText() = DB::Exception: Missing columns: 'c2' while processing query: '_sign = 1, c1, c2', required columns: '_sign' 'c1' 'c2' '_sign' 'c1' 'c2' (version 21.6.5.37 (official build))
@th997 th997 added the bug Confirmed user-visible misbehaviour in official release label Jun 28, 2021
@alexey-milovidov alexey-milovidov added experimental feature Bug in the feature that should not be used in production comp-mysql and removed bug Confirmed user-visible misbehaviour in official release labels Jun 28, 2021
@tavplubix tavplubix self-assigned this Jun 28, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
comp-mysql experimental feature Bug in the feature that should not be used in production
Projects
None yet
Development

No branches or pull requests

3 participants