diff options
| author | DaNiMoTh <jjdanimoth@gmail.com> | 2011-07-19 04:57:07 (GMT) |
|---|---|---|
| committer | Charles Yin <charles.yin@nokia.com> | 2011-07-19 04:57:07 (GMT) |
| commit | c4280dbd9bb37cca21d007f5f8b9217f80b44043 (patch) | |
| tree | ca35cfc7b1dde96027df56afa5d157ad540f7d0a /tests/auto/qtessellator | |
| parent | 2b13b3d367cb6cda48ab9183d9ad5b2eee09e129 (diff) | |
| download | Qt-c4280dbd9bb37cca21d007f5f8b9217f80b44043.zip Qt-c4280dbd9bb37cca21d007f5f8b9217f80b44043.tar.gz Qt-c4280dbd9bb37cca21d007f5f8b9217f80b44043.tar.bz2 | |
Fixed behavior on NULL foreign keys
Instead of using a simple INNER JOIN, like:
SELECT a,b,rel.c FROM table1, table2 WHERE (table1.smthing =
table2.smthing)
which doesn't show row where foreign keys are NULL, allow use of LEFT
JOIN like:
SELECT a,b,rel.c FROM table1 LEFT JOIN table2 ON table1.smthing =
table2.smthing
The trick works also for multi-relational tables.
Just remember to use the new API setJoinMode.
Signed-off-by: DaNiMoTh <jjdanimoth@gmail.com>
Change-Id: I349f9418e4859923977942add59872b000cac2c5
Task-number:QTBUG-8217
Reviewed-by:Michael Goddard
Reviewed-by:Charles Yin
Merge-request: 2576
Reviewed-by: Charles Yin <charles.yin@nokia.com>
Diffstat (limited to 'tests/auto/qtessellator')
0 files changed, 0 insertions, 0 deletions