diff options
| author | drh <> | 2022-04-13 12:34:54 +0000 |
|---|---|---|
| committer | drh <> | 2022-04-13 12:34:54 +0000 |
| commit | 94e615a6acf3a1519d98e85a6665c712edb5ea8a (patch) | |
| tree | e163e2a1f8ce85dbbcbe67a247b103f689c5f85d /test/where9.test | |
| parent | 3b79f7580a30e7a49962e9a2538498c65227a4d7 (diff) | |
| parent | 12c35ec322dc2b394a3a6d8b3997ef60574414a0 (diff) | |
| download | sqlite-94e615a6acf3a1519d98e85a6665c712edb5ea8a.tar.gz sqlite-94e615a6acf3a1519d98e85a6665c712edb5ea8a.zip | |
Add support for RIGHT and FULL OUTER JOINs.
FossilOrigin-Name: fa9d206f904280e3eafc6f4ba6c0c7325948364c62eeeb9f0fdc5825d622ec35
Diffstat (limited to 'test/where9.test')
| -rw-r--r-- | test/where9.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/test/where9.test b/test/where9.test index 429708f1f..475788153 100644 --- a/test/where9.test +++ b/test/where9.test @@ -378,9 +378,9 @@ ifcapable explain { |--SEARCH t1 USING INTEGER PRIMARY KEY (rowid=?) `--MULTI-INDEX OR |--INDEX 1 - | `--SEARCH t2 USING INDEX t2d (d=?) + | `--SEARCH t2 USING INDEX t2d (d=?) LEFT-JOIN `--INDEX 2 - `--SEARCH t2 USING COVERING INDEX t2f (f=?) + `--SEARCH t2 USING COVERING INDEX t2f (f=?) LEFT-JOIN }] } |