Polypheny-DB icon indicating copy to clipboard operation
Polypheny-DB copied to clipboard
verified publisher icon polypheny

Bad lines in query plan view

Open vogti opened this issue 4 years ago • 10 comments

There is a minor rendering bug in the query plan view of the Polypheny-UI.

Bildschirmfoto 2021-03-10 um 15 23 39

This issue can be reproduced by executing the following query in the SQL query console and opening the physical plan view:

select * from emps e1, emps e2, depts d1, depts d2 
where e1.deptno = d1.deptno and e2.deptno = d2.deptno and e1.deptno = d2.deptno and e1.deptno = d2.deptno

The query uses the demo tables available in every fresh Polypheny-DB instance.

Please be aware that the physical query plan is only shown on the first execution of a query due to the implementation caching. Either reset the implementation cache in the monitoring view or disable implementation caching entirely (Config -> Query Processing -> runtime/implementationCaching ).

vogti avatar Mar 10 '21 14:03 vogti

Hi! I would like to apply to Polypheny in the GSoC 21. To start with my contribution to the community I want to work on this issue. Could you please asign me it?

ayu023ban avatar Mar 14 '21 08:03 ayu023ban

Hi @ayu023ban, welcome to Polypheny! I have assigned the issue to you. Please follow this on how to set up Polypheny-DB in your favorite IDE and this guide on how to manually build Polypheny-UI. Feel free to ask here or open a thread in the discussions forum if you have any questions or experience any issues with setup.

vogti avatar Mar 14 '21 09:03 vogti

Hi @ayu023ban, is everything working fine? If you have any issues or need help getting started, please do not hesitate to either ask here or open a thread in the discussion forum.

vogti avatar Apr 02 '21 09:04 vogti

Hi, @vogti Can you tell me where the Java code or HTML of the generated graph is located? DB has many modules. I often don't know where to start to solve these problems.🤣

erdengk avatar Jan 13 '22 13:01 erdengk

Hi @erdengk The frontend-code of the UI lives in its own repository. The Polypheny-UI is based on Angular and follows the common structure.

vogti avatar Jan 16 '22 10:01 vogti

image No longer able to replicate this issue

C-mmon avatar Apr 09 '22 16:04 C-mmon

Hi @C-mmon The example query indeed does not show this problem anymore. However, if you expand the query, it is still present: select * from emps e1, emps e2, emps e3, depts d1, depts d2, depts d3 where e1.deptno = d1.deptno and e2.deptno = d2.deptno and e1.deptno = d2.deptno and e1.deptno = d2.deptno and e1.deptno = d3.deptno

Screenshot 2022-04-09 at 21 07 23

Do you want to take care of this issue?

vogti avatar Apr 09 '22 19:04 vogti

I would like to work on this issue and if possible can anyone explain this issue as this is my first contribution!

gvjkumar2004 avatar Jan 28 '23 18:01 gvjkumar2004

Hi @vogti My name is Alessia. I am currently a master's student at the University of Washington majoring in Information Management and want to apply to the Polypheny in the GSoC 24. To start with my contribution to the community, I'd like to work on this Bad lines in query plan view #281 issue. Could you please kindly assign it to me? Thank you : )

AlessiaTang avatar Mar 01 '24 23:03 AlessiaTang

@vogti @hennlo HI, If there aren't anyone work on this issue, I would like to work on it and I think that I can solve it after go deep on code

EslamAsHhraf avatar Mar 26 '24 19:03 EslamAsHhraf