Skip to content
This repository has been archived by the owner on Nov 24, 2023. It is now read-only.

CREATE TABLE IF NOT EXISTS may causes error like Column count doesn't match value count: x (columns) vs y (values) #1697

Closed
lance6716 opened this issue May 16, 2021 · 1 comment · Fixed by #1699
Assignees
Labels
affected-v2.0.2 this issue/BUG affects v2.0.2 affected-v2.0.3 this issue/BUG affects v2.0.3 severity/moderate type/bug This issue is a bug report

Comments

@lance6716
Copy link
Collaborator

lance6716 commented May 16, 2021

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? If possible, provide a recipe for reproducing the error.
    https://asktug.com/t/topic/92863

    1. at upstream: create table test.t (c int primary key);
    2. start a "all" mode task
    3. at upstream: create table if not exists test.t (c1 int, c2 int); insert into test.t values (1);
    4. query-status
  2. What did you expect to see?
    no error

  3. What did you see instead?
    gen insert sqls failed, schema: test, table: t: Column count doesn't match value count: 2 (columns) vs 1 (values)"

@lance6716 lance6716 added affected-v2.0.2 this issue/BUG affects v2.0.2 affected-v2.0.3 this issue/BUG affects v2.0.3 severity/moderate type/bug This issue is a bug report labels May 16, 2021
@lance6716 lance6716 changed the title CREATE TABLE IF NOT EXISTS may causes error like Column count doesn't match value count: 2 (columns) vs 1 (values) CREATE TABLE IF NOT EXISTS may causes error like Column count doesn't match value count: x (columns) vs y (values) May 16, 2021
@Ehco1996

This comment has been minimized.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
affected-v2.0.2 this issue/BUG affects v2.0.2 affected-v2.0.3 this issue/BUG affects v2.0.3 severity/moderate type/bug This issue is a bug report
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants