Right Join

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Right Join

Marc de Hoop
Hello list,

We would like to add RIGHT JOIN support to HSQLDB. Could someone tell us
how the current left join support works? We're mostly interested in
knowing how hsqldb decides if a certain row is added to the query result
in Select.buildResult (Select.java) and the meaning of the code in lines
819-858.

yours,

Marc de Hoop and Huug Ouwersloot.

TOPdesk



-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
hsqldb-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
Reply | Threaded
Open this post in threaded view
|

Re: Right Join

Fred Toussi-2
This is doable but not very simple. The LEFT JOIN support is based on the
fact that the outer table is before the inner table in the parsing order.
You could probably parse RIGHT JOIN statements then reverse the order of the
tables for join purposes. The data structure is an array of TableFilter
objects created by Parser. The code you mention is the loop that performs
the join. This should not be altered to support RIGHT JOIN.

In any case please upload the previous work you mentioned to the patch
tracker for review.

Fred

----- Original Message -----
From: "Marc de Hoop" <[hidden email]>
To: <[hidden email]>
Sent: 10 August 2005 11:44
Subject: [Hsqldb-developers] Right Join


Hello list,

We would like to add RIGHT JOIN support to HSQLDB. Could someone tell us
how the current left join support works? We're mostly interested in
knowing how hsqldb decides if a certain row is added to the query result
in Select.buildResult (Select.java) and the meaning of the code in lines
819-858.

yours,

Marc de Hoop and Huug Ouwersloot.

TOPdesk



-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
hsqldb-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers 



-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
hsqldb-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers