get empty using select

Bug #1578895 reported by bzcode on 2016-05-06
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Spider for MySQL
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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers