> On Aug. 7, 2014, 12:05 a.m., Maxim Khutornenko wrote:
> > src/main/resources/org/apache/aurora/scheduler/storage/db/LockMapper.xml, 
> > line 63
> > <https://reviews.apache.org/r/24432/diff/1/?file=654349#file654349line63>
> >
> >     How about INNER JOIN instead to be totally explicit?
> 
> Bill Farner wrote:
>     You and Kevin should has this one out.
> 
> Bill Farner wrote:
>     hash*
> 
> Maxim Khutornenko wrote:
>     Just don't see why we would use "LEFT OUTER JOIN" in some cases but 
> "JOIN" in others. Why second guess what "JOIN" defaults to (INNER, NATURAL or 
> CROSS)?
> 
> Kevin Sweeney wrote:
>     Personally I prefer JOIN over INNER JOIN since a modifier calls out to me 
> that there's something weird going on here and I need to go draw Venn 
> diagrams. Happy to defer, but let's standardize on one style everywhere.
> 
> Kevin Sweeney wrote:
>     In fact, for inner joins I prefer avoiding the JOIN keyword altogether 
> like
>     
>     SELECT (...) FROM A a, B b WHERE a.b_id = b.id AND (...)
>     
>     A CROSS JOIN is just:
>     
>     SELECT (...) FROM A a, B b WHERE (...)
>     
>     And a NATURAL JOIN (or any other type of "strange" join) is just:
>     
>     SELECT (...) FROM A a NATURAL JOIN B b WHERE (...)
>     SELECT (...) FROM A a (...) JOIN B b ON a.b_id WHERE (...)
> 
> Maxim Khutornenko wrote:
>     
>     | SELECT (...) FROM A a, B b WHERE a.b_id = b.id AND (...)
>     
>     This is a pre SQL-92 syntax that is not compliant with the most recent 
> SQL standards. E.g.: 
> http://stackoverflow.com/questions/1599050/ansi-vs-non-ansi-sql-join-syntax
>     
>     In addition to the above, I don't see why I should be rewriting the query 
> just to change from INNER JOIN to LEFT OUTER JOIN.

Kevin wins by force of comment length.  (read: i'm going to commit to fix this 
up, we can decide on the style async.)


- Bill


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/24432/#review49834
-----------------------------------------------------------


On Aug. 7, 2014, 12:03 a.m., Bill Farner wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/24432/
> -----------------------------------------------------------
> 
> (Updated Aug. 7, 2014, 12:03 a.m.)
> 
> 
> Review request for Aurora and Maxim Khutornenko.
> 
> 
> Bugs: AURORA-640
>     https://issues.apache.org/jira/browse/AURORA-640
> 
> 
> Repository: aurora
> 
> 
> Description
> -------
> 
> Fix incorrect join type used in LockMapper.xml.
> 
> 
> Diffs
> -----
> 
>   
> src/main/resources/org/apache/aurora/scheduler/storage/db/AttributeMapper.xml 
> deb25bddd826ba8d5fc3af6f7b853fba8d59e681 
>   src/main/resources/org/apache/aurora/scheduler/storage/db/LockMapper.xml 
> 9e1f8e683697b1af1543be332c6da550e547971e 
>   src/test/java/org/apache/aurora/scheduler/storage/db/DbLockStoreTest.java 
> 283fc7ea1c4c5c102c34894a5b3bc4d828c002ec 
> 
> Diff: https://reviews.apache.org/r/24432/diff/
> 
> 
> Testing
> -------
> 
> Modified a test case to point out the issue.
> 
> 
> Thanks,
> 
> Bill Farner
> 
>

Reply via email to