diff options
| author | drh <> | 2025-07-02 20:46:02 +0000 |
|---|---|---|
| committer | drh <> | 2025-07-02 20:46:02 +0000 |
| commit | aa54d7a0ca03a4df516f25e66ff3c4801be07a7b (patch) | |
| tree | 83046107de2c6df3b78abbf75d845c78a85c9194 /test/json101.test | |
| parent | eb27359e5e6e0258947ef85124229ca632d838af (diff) | |
| parent | a3ee3860a2bef9f44561093b5e39d9160840671b (diff) | |
| download | sqlite-aa54d7a0ca03a4df516f25e66ff3c4801be07a7b.tar.gz sqlite-aa54d7a0ca03a4df516f25e66ff3c4801be07a7b.zip | |
Merge in the exists-to-join optimization that has been modified
to relax the requirement of having an indexed join constraint.
FossilOrigin-Name: 1c1aef2b7feae29066d0330699ab634ef41f5b60cdcd479a60cb1a5409553138
Diffstat (limited to 'test/json101.test')
| -rw-r--r-- | test/json101.test | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/test/json101.test b/test/json101.test index e22902f86..7582d14a6 100644 --- a/test/json101.test +++ b/test/json101.test @@ -892,15 +892,15 @@ do_execsql_test json101-13.100 { INSERT INTO t2(id,json) VALUES(4,'{"value":4}'); INSERT INTO t2(id,json) VALUES(5,'{"value":5}'); INSERT INTO t2(id,json) VALUES(6,'{"value":6}'); - SELECT * FROM t1 CROSS JOIN t2 + SELECT *, 'NL' FROM t1 CROSS JOIN t2 WHERE EXISTS(SELECT 1 FROM json_each(t1.json,'$.items') AS Z WHERE Z.value==t2.id); -} {1 {{"items":[3,5]}} 3 {{"value":3}} 1 {{"items":[3,5]}} 5 {{"value":5}}} +} {1 {{"items":[3,5]}} 3 {{"value":3}} NL 1 {{"items":[3,5]}} 5 {{"value":5}} NL} do_execsql_test json101-13.110 { - SELECT * FROM t2 CROSS JOIN t1 + SELECT *, 'NL' FROM t2 CROSS JOIN t1 WHERE EXISTS(SELECT 1 FROM json_each(t1.json,'$.items') AS Z WHERE Z.value==t2.id); -} {3 {{"value":3}} 1 {{"items":[3,5]}} 5 {{"value":5}} 1 {{"items":[3,5]}}} +} {3 {{"value":3}} 1 {{"items":[3,5]}} NL 5 {{"value":5}} 1 {{"items":[3,5]}} NL} # 2018-05-16 # Incorrect fullkey output from json_each() |