 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
judahr
Joined: 09 Mar 2007
Posts: 319
Country: United States |
|
 [7.3.433 Pro] Merge Join hint issue |
 |
 |
 |
Select field1
from Table1 t1
inner MERGE join table2 t2
on t1.field1 = t2.field1
where t1.
|
I would expect the columns from t1 to show. However they don't. If I remove the word merge, it works as expected. It is valid syntax. Inner HASH join works fine. Seems it is getting confused by the merge.
|
|
| Thu Oct 29, 2015 10:01 am |
  |
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
 |
|
Seems it is getting confused by the merge |
I'm surprised it's working accidentally with HASH. SA currently doesn't support that kind of new join syntax yet. It understands INNER JOIN, JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL JOIN only, it also recognizes old comma-separated list syntax.
I guess when it finds MERGE keyword, it expects to find a valid MERGE statement after that.
|
|
| Thu Oct 29, 2015 10:20 am |
|
|
judahr
Joined: 09 Mar 2007
Posts: 319
Country: United States |
|
| |
|
its the first time I've seen this. and probably my only query that has this to solve a really bad plan.
|
|
| Thu Oct 29, 2015 10:50 am |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
