test/trace_processor/span_left_join_empty_right.sql

create table t1(
  ts BIG INT,
  dur BIG INT,
  part BIG INT,
  PRIMARY KEY (part, ts)
) without rowid;

create table t2(
  ts BIG INT,
  dur BIG INT,
  part BIG INT,
  PRIMARY KEY (part, ts)
) without rowid;

INSERT INTO t1(ts, dur, part)
VALUES
(500, 500, 100);

create virtual table sp using span_left_join(t1 PARTITIONED part, 
                                             t2 PARTITIONED part);

select * from sp;