#209 reverse query: syntax ON AND

2014.07
closed
PAscal
Bug (81)
2
2014-07-15
2014-06-05
PAscal
No

select
from
a
inner join b
on a.x=b.x
inner join c
on a.i=c.i
inner join d
on c.i=d.i
and a.i=d.i

seems properly reversed (graph is correct) but syntax is wrong
...
inner join d
on and a.i=d.i
and c.i=d.i

this syntax can not be reversed.

Discussion

  • PAscal
    PAscal
    2014-06-10

    • summary: reverse query: syntax is wrong with looping joins --> reverse query: syntax ON AND
    • status: open --> commited
    • assigned_to: PAscal
    • Milestone: not planned --> 2014.07
     
  • PAscal
    PAscal
    2014-07-01

    • status: commited --> tested
     
  • PAscal
    PAscal
    2014-07-15

    • status: tested --> closed