Menu

#393 Designer: reversing query never ends

2016.11
closed
PAscal
Bug (150)
1
2016-11-30
2016-11-14
PAscal
No

Starting with 2016.10 release
reversing following query never ends ...

SELECT * FROM AAA AL1, LBV AL2, BBB AL3, CCC AL4, DDD AL5, EEE AL6, FFF AL7, GGG AL8, KKK AL9, LLL AL10, MMM AL11, NNN AL12, OOO AL13 
WHERE AL10.cde = AL1.cde  AND  AL10.app = AL1.app  AND  AL10.cde1 = AL1.cde1  AND  AL10.cde2 = AL1.cde2  AND  AL10.cde3 = AL1.cde3  AND  AL10.dt = AL1.dt  AND  AL1.cde = AL11.cde  AND  AL1.do = AL11.do  AND  AL1.do_dt = AL11.do_dt  AND  AL12.cde = AL1.cde  AND  AL12.do = AL1.do  AND  AL12.do_dt = AL1.do_dt  AND  AL1.cde = AL13.cde  AND  AL1.app = AL13.app  AND  AL1.cde1 = AL13.cde1  AND  AL1.cde2 = AL13.cde2  AND  AL1.cde3 = AL13.cde3  AND  AL1.dt = AL13.dt  AND AL2.cde=AL1.cde AND AL2.app=AL1.app AND AL2.cde1=AL1.cde1 AND AL2.cde2=AL1.cde2 AND AL2.cde3=AL1.cde3 AND AL2.dt=AL1.dt AND AL3.ca=AL2.ca AND AL4.cde=AL1.cde AND AL4.cc=AL1.lcc AND AL1.cde=AL5.cde AND AL1.cc=AL5.cc AND AL5.cde=AL6.cde AND AL5.p=AL6.p AND AL5.A=AL4.A AND AL7.f=AL3.f AND AL3.m=AL8.m AND AL9.cde=AL4.cde AND AL9.A=AL4.A AND AL1.fac=AL9.cc

Discussion

  • PAscal

    PAscal - 2016-11-15
    • status: open --> commited
    • assigned_to: PAscal
     
  • PAscal

    PAscal - 2016-11-30
    • status: commited --> closed
     

Log in to post a comment.