test/trace_processor/span_left_join_unordered.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 a single row into t1.
INSERT INTO t1(ts, dur, part)
VALUES (500, 100, 10);

-- Insert a single row into t2.
INSERT INTO t2(ts, dur, part)
VALUES (500, 100, 5);

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

select * from sp;