get empty using select
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Spider for MySQL |
New
|
Undecided
|
Unassigned |
Bug Description
hi, i created table followed the sample:
create table tbl_b(
col_a int primary key,
col_b int,
col_c int,
col_d int,
key idx_a(col_b, col_c)
)engine=InnoDB;
create table tbl_c(
col_a int primary key,
col_c int,
col_e varchar(255),
col_f text,
key idx_b(col_c, col_f(100))
)engine=InnoDB;
create table tbl_a(
col_a int primary key,
col_b int,
col_c int,
col_d int,
col_e varchar(255),
col_f text,
key idx_a(col_b, col_c),
key idx_b(col_c, col_f(100))
)engine=VP
comment 'table_name_list "tbl_b tbl_c"';
then i insert some items.
insert into tbl_a values ( 0, 0, 0, 0, '0', '00')
insert into tbl_a values ( 1, 1, 1, 1, '1', '01')
insert into tbl_a values ( 2, 2, 2, 2, '2', '02')
insert into tbl_a values ( 3, 3, 3, 3, '3', '03')
insert into tbl_a values ( 4, 4, 4, 4, '4', '04')
insert into tbl_a values ( 5, 5, 5, 5, '5', '05')
insert into tbl_a values ( 6, 6, 6, 6, '6', '06')
insert into tbl_a values ( 7, 7, 7, 7, '7', '07')
insert into tbl_a values ( 8, 8, 8, 8, '8', '08')
insert into tbl_a values ( 9, 9, 9, 9, '9', '09')
insert into tbl_a values ( 10, 10, 10, 10, '10', '10')
then i select
select * from tbl_a; // ok, 11 rows
select * from tbl_b; // ok, 11 rows
select * from tbl_c; // ok, 11 rows
then i insert
insert into tbl_a values ( 11, 11, 11, 11, '11', '11');
then i select
select * from tbl_a; // ok, 12 rows
!!!!!!!
select * from tbl_b; // error, 11 rows
select * from tbl_c; // error, 11 rows