jensenojs
commented
2 days ago 使用原来的复现方式执行结果如下所示 : https://github.com/matrixorigin/matrixone/issues/19923#issuecomment-2472300132
mysql> drop database if exists db1;
Query OK, 1 row affected (0.01 sec)
mysql> create database db1;
Query OK, 1 row affected (0.01 sec)
mysql> use db1;
Database changed
mysql> set experimental_fulltext_index=1;
Query OK, 0 rows affected (0.00 sec)
mysql> drop table if exists t1;
Query OK, 0 rows affected (0.01 sec)
mysql> create table t1(a int primary key, b varchar(200));
Query OK, 0 rows affected (0.02 sec)
mysql> insert into t1 select result, "test create big fulltext index" from generate_series(30000000) g;
Query OK, 30000000 rows affected (6.80 sec)
mysql> create fulltext index ftidx on t1 (b);
Query OK, 0 rows affected (15.65 sec)
mysql>
What type of PR is this?
Which issue(s) this PR fixes:
issue #19923
What this PR does / why we need it:
导致这个issue的原因是远端CN上的incr-service只能通过后台SQL去查还没有commit的表的数据