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/btree01.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/btree01.test')
| -rw-r--r-- | test/btree01.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/test/btree01.test b/test/btree01.test index 9c309760d..6e4717ae6 100644 --- a/test/btree01.test +++ b/test/btree01.test @@ -148,6 +148,9 @@ do_execsql_test btree01-2.1 { INSERT INTO t2(y) VALUES(198),(187),(100); SELECT y, c FROM t2 LEFT JOIN t1 ON y=a ORDER BY x; } {198 99 187 {} 100 50} +do_execsql_test btree01-2.2 { + SELECT y, c FROM t1 RIGHT JOIN t2 ON y=a ORDER BY x; +} {198 99 187 {} 100 50} finish_test |