FerreroJeremy/ln2sql

Not working to perform joins

vasharma1 opened this issue · 3 comments

vasharma1 commented

The english statement 'What is the name of the professor who is teaching the field Algorithm ?' does not work. There comes an error saying 'there is at least one column 'field' which is not reachable from 'professor'.

FerreroJeremy commented

Thank you for your interest in ln2sql. Unfortunately, I'm not going forward with the project.

In addition, FYI, the pypi version is really not updated; it does not include most of features of the github version, the same goes for the release versions and especially for the python 2.X version. Maybe your problem comes from here.

I'm so sorry not to be able to help you more.

jps1001 commented

@vasharma1 That is because the sql dump file does not contain the relation between primary key and foreign key. You have to define your ALTER TABLE statements. And then add :
ALTER TABLE professor
ADD CONSTRAINT professor_ibfk_1 FOREIGN KEY (idProf) REFERENCES teaching (idProf);

Thanks.

  • 👍1
aitoehigie commented

Sad to see this project has been abandoned

  • 😕1