Connect tables ignore PK, fail upon select or statistics collection

install soname 'ha_connect';

create table t (a int, primary key(a)) ENGINE=Connect table_type=bin;

insert into t values (1),(1);

select * from t;

drop table t;

uninstall soname 'ha_connect';

insert into t values (1),(1);

Warnings:

Warning	1105	Index is not unique

select * from t;

bug.connect1                             [ fail ]

        Test ended at 2023-08-10 20:34:26

CURRENT_TEST: bug.connect1

mysqltest: At line 5: query 'select * from t' failed: 1296: Got error 122 'Open error 2 in mode rb on /dev/shm/var/mysqld.1/data/./test/t.bnx: No such file or directory' from CONNECT

install soname 'ha_connect';

create table t (a int, primary key(a), b int) ENGINE=Connect table_type=bin;

insert into t values (1,10),(1,20);

select * from t;

drop table t;

uninstall soname 'ha_connect';

insert into t values (1,10),(1,20);

Warnings:

Warning	1105	Index is not unique

select * from t;

a	b

1	10

1	20

install soname 'ha_connect';

create table t (a int, primary key(a), b int not null, key(b)) ENGINE=Connect table_type=bin;

insert into t values (1,10),(1,20);

analyze table t persistent for all;

drop table t;

uninstall soname 'ha_connect';

insert into t values (1,10),(1,20);

Warnings:

Warning	1105	Index is not unique

analyze table t persistent for all;

bug.connect1                             [ fail ]

        Test ended at 2023-08-10 20:36:00

CURRENT_TEST: bug.connect1

mysqltest: At line 5: query 'analyze table t persistent for all' failed: 2013: Lost connection to MySQL server during query

index_init CONNECT: Open error 2 in mode rb on /dev/shm/var_auto_i9Lv/mysqld.1/data/./test/t.bnx: No such file or directory

mysqld: /data/src/10.4/sql/handler.cc:3051: int handler::ha_index_first(uchar*): Assertion `inited==INDEX' failed.

230810 20:35:59 [ERROR] mysqld got signal 6 ;

#9  0x00007ffa23a53df2 in __GI___assert_fail (assertion=0x55a2daa04100 "inited==INDEX", file=0x55a2daa08380 "/data/src/10.4/sql/handler.cc", line=3051, function=0x55a2daa0c1c0 "int handler::ha_index_first(uchar*)") at ./assert/assert.c:101

#10 0x000055a2d8dca2fd in handler::ha_index_first (this=0x61d0002012a8, buf=0x6190000866b8 "") at /data/src/10.4/sql/handler.cc:3051

#11 0x000055a2d882bb3a in collect_statistics_for_index (thd=0x62b00005b208, table=0x62000003c088, index=1) at /data/src/10.4/sql/sql_statistics.cc:2554

#12 0x000055a2d882ce0c in collect_statistics_for_table (thd=0x62b00005b208, table=0x62000003c088) at /data/src/10.4/sql/sql_statistics.cc:2738

#13 0x000055a2d8a36868 in mysql_admin_table (thd=0x62b00005b208, tables=0x62b000062330, check_opt=0x62b000060478, operator_name=0x55a2da7c7f00 "analyze", lock_type=TL_READ_NO_INSERT, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x55a2d8dd4f24 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0x0, is_cmd_replicated=true) at /data/src/10.4/sql/sql_admin.cc:926

#14 0x000055a2d8a3b08c in Sql_cmd_analyze_table::execute (this=0x62b000062a38, thd=0x62b00005b208) at /data/src/10.4/sql/sql_admin.cc:1390

#15 0x000055a2d8624e35 in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:6216

#16 0x000055a2d86306af in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b000062228 "analyze table t persistent for all", length=34, parser_state=0x7ffa1bd5b860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8010

#17 0x000055a2d860697a in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x629000230209 "", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857

#18 0x000055a2d86034e9 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378

#19 0x000055a2d8a02a48 in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420

#20 0x000055a2d8a0235f in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324

#21 0x000055a2d9671dd4 in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869

#22 0x00007ffa23aa7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#23 0x00007ffa23b285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81