Giraphne / sqlvis

Python package to visualise SQL queries as graphs
MIT License
38 stars 7 forks source link

Problem regarding BETWEEN and IN ('a', 'b', 'c') #5

Open YoungAndY2m opened 3 months ago

YoungAndY2m commented 3 months ago

Hi, thank you so much for this fantastic visualization project!

I'm working on a school project that uses this sqlvis to visualize our query. We use Flask so as to create a web application. However, when it comes to query using "BETWEEN ... AND ..." and "sth. IN ('a', 'b', 'c')", it raises an error:

visualize.js:44453 Uncaught TypeError: Cannot set properties of undefined (setting 'refs') at extractAllowedRefs (visualize.js:44453:12) at visualize (visualize.js:43730:3) at visualizeMain (visualize.js:45747:5) at Object.execCb (require.min.js:1:16727) at e.check (require.min.js:1:10499) at e. (require.min.js:1:12915) at require.min.js:1:1542 at require.min.js:1:13376 at each (require.min.js:1:1020) It seems that ast is undefined (parse_sql result).

Would you take a look at it and perhaps shed light on how to solve the problem? Thank you very much!