Skip to content

when the subquery is listed as * and is a union query, create view exceptions #2063

@wenyh1

Description

@wenyh1
  • dble version:<= 3.20.10.99
  • preconditions :
    all tables are sharding:
    create table test1(id int,code varchar(10));
    create table test2(id int,code varchar(10));
  • configs:

sharding.xml

 <schema name="testdb">
    <shardingTable name="test1" shardingNode="dn1,dn2" function="func_jumpHash" shardingColumn="id"/>
    <shardingTable name="test2" shardingNode="dn1,dn2" function="func_jumpHash" shardingColumn="id"/>
</schema>
  • steps:
    step1. create view test_view(id,name) AS select * from test1 union select * from test2;
  • expect result:
    1. success
  • real result:
    1. ERROR 1222 (HY000): The Column_list Size and Select_statement Size Not Match
  • supplements:
    1.

Metadata

Metadata

Assignees

Labels

autotest-addedthe case has append to autotestresolveproblem has been fixed by developer

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions