diff options
Diffstat (limited to 'test/trace_processor/span_join/span_outer_join_unpartitioned_empty.sql')
-rw-r--r-- | test/trace_processor/span_join/span_outer_join_unpartitioned_empty.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/test/trace_processor/span_join/span_outer_join_unpartitioned_empty.sql b/test/trace_processor/span_join/span_outer_join_unpartitioned_empty.sql new file mode 100644 index 000000000..8155974b7 --- /dev/null +++ b/test/trace_processor/span_join/span_outer_join_unpartitioned_empty.sql @@ -0,0 +1,32 @@ +-- +-- Copyright 2021 The Android Open Source Project +-- +-- Licensed under the Apache License, Version 2.0 (the "License"); +-- you may not use this file except in compliance with the License. +-- You may obtain a copy of the License at +-- +-- https://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, software +-- distributed under the License is distributed on an "AS IS" BASIS, +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +-- See the License for the specific language governing permissions and +-- limitations under the License. +-- +create table t1( + ts BIG INT, + dur BIG INT, + PRIMARY KEY (ts) +) without rowid; + +create table t2( + ts BIG INT, + dur BIG INT, + PRIMARY KEY (ts) +) without rowid; + +-- t1 and t2 are empty. + +create virtual table sp using span_outer_join(t1, t2); + +select * from sp; |