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/aggnested.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/aggnested.test')
| -rw-r--r-- | test/aggnested.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/test/aggnested.test b/test/aggnested.test index 35d5f1e3a..1b8b60880 100644 --- a/test/aggnested.test +++ b/test/aggnested.test @@ -137,6 +137,17 @@ do_test aggnested-3.1 { GROUP BY curr.id1); } } {1 1} +do_test aggnested-3.1-rj { + db eval { + SELECT + (SELECT sum(value2==xyz) FROM t2) + FROM + (SELECT curr.value1 as xyz + FROM t1 AS other RIGHT JOIN t1 AS curr + GROUP BY curr.id1); + } +} {1 1} + do_test aggnested-3.2 { db eval { DROP TABLE IF EXISTS t1; |