You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
create table test.t (col1 int not null, col2 bit(1) not null, col3 bit(8) not null, col4 tinyint not null, col5 boolean not null, col6 smallint not null, col7 integer not null, col8 mediumint not null, col9 bigint not null, col10 float not null, col11 double not null, col12 decimal(20,2) not null, col13 date not null, col14 datetime not null, col15 timestamp not null, col16 time not null, col17 year not null, col18 char(64) not null, col19 varchar(64) not null, col20 binary(64) not null, col21 varbinary(64) not null, col22 tinyblob not null, col23 tinytext not null, col24 blob not null, col25 text not null, col26 mediumblob not null, col27 mediumtext not null, col28 longblob not null, col29 longtext not null, col30 enum('male','female','both','unknown') not null, col31 set('a','b','c') not null);
SET time_zone = '+0:00'; insert into test.t values(1,B'1',B'01111100',29,1,29,29,29,29,29.9,29.9,29.9,'2021-01-01','2021-01-01 11:11:11','2021-01-01 11:11:11','11:11:11','2019','char test','varchar test','binary test','varbinary test','tinyblob test','tinytext test','blob test','text test','mediumblob test','mediumtext test','longblob test','longtext test','male','a,b'),(2,B'0',B'00111100',19,0,19,19,19,19,19.9,19.9,19.9,'2021-01-02','2021-01-02 11:11:11','2021-01-02 11:11:11','12:11:11','2010','char test 1','varchar test 1','binary test 1','varbinary test 1','tinyblob test 1','tinytext test 1','blob test 1','text test 1','mediumblob test 1','mediumtext test 1','longblob test 1','longtext test 1','female','a');
alter table test.t set tiflash replica 1;
set session tidb_isolation_read_engines='tiflash'; set tidb_allow_mpp = 1; set tidb_opt_broadcast_join = 0; set tidb_broadcast_join_threshold_count = 0; set tidb_broadcast_join_threshold_size = 0; select t1.col1, hex(t1.col2), hex(t1.col3), t2.col1, hex(t2.col2), hex(t2.col3) from test.t t1 join test.t t2 on t1.col2 = t2.col2;
The text was updated successfully, but these errors were encountered:
to reproduce:
The text was updated successfully, but these errors were encountered: