PAscal
-
2016-11-15
- status: open --> commited
- assigned_to: PAscal
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