miniob 子查询

select * from ssq_1 where id in (select ssq_2.id from ssq_2);

  • failed to receive response from observer. reason=Failed to receive from server. poll return POLLHUP=16 or POLLERR=str(event & select.POLLERR)
    failed to receive response from observer. reason=Failed to receive from server. poll return POLLHUP=16 or POLLERR=str(event & select.POLLERR)
    – below are some requests executed before(partial) –
    – init data
    CREATE TABLE ssq_1(id int, col1 int, feat1 float);
    CREATE TABLE ssq_2(id int, col2 int, feat2 float);
    CREATE TABLE ssq_3(id int, col3 int, feat3 float);
    CREATE TABLE ssq_4(id int, col4 char(20));
    INSERT INTO ssq_1 VALUES (97, 86, 27.73);
1 个赞

是在执行这条sql 的时候 observer 挂掉了,可以参考第五条 参赛必读 | 2024 OceanBase 数据库大赛