2023年4月4日DuckDB物理计划连接分析

  
    
 use memory;
    
  
    
 create table b(b1 int, b2 varchar(2), primary key(b1)) ;
    
  
    
 create table a(a1 int, a2 varchar(2), foreign key(a1) references b(b1)) ;
    
  
    
 create table c(c1 int, c2 varchar(2)) ;
    
  
    
 create table d(d1 int, d2 varchar(2)) ;
    
  
    
 insert into a values(1, 'a1');
    
  
    
 insert into a values(null, 'a2');
    
  
    
 insert into a values(3, 'a3');
    
  
    
 insert into b values(1, 'b1');
    
  
    
 insert into b values(2, 'b2');