Yilin Xia

Split the recursion `Anc` into two will solve the problem ``` %%logica Lowest_Common_Ancestors_with_Name @Engine("sqlite"); @AttachDatabase("mgdb","mgdb.db"); @Dataset("advised"); @Dataset("person"); @Dataset("dissertation"); Adv_Stu(advisor:, student:author) :- Advised(did:x, advisor:),Dissertation(did:y, author:), x=y; @Recursive(Anc_1,33); Anc_1(ancestor:advisor, student:m) distinct :-...

Using Ground will also resolve the error ``` %%logica Lowest_Common_Ancestors_with_Name @Engine("sqlite"); @AttachDatabase("mgdb","mgdb.db"); @Ground(Adv_Stu); Adv_Stu(advisor:, student:author) :- Advised(did:x, advisor:),Dissertation(did:y, author:), x=y; @Recursive(Anc,33); @Ground(Anc); Anc(ancestor:advisor, student:m) distinct :- Adv_Stu(advisor:, student:m), m=63244; Anc(ancestor:x,...

@EvgSkv I compared the SQL in Colab and Jupyter Colab ``` SELECT JSON_EXTRACT(JSON_OBJECT('child', mydata_ParentTable.child), "$.child") AS col0 FROM mydata.ParentTable AS mydata_ParentTable; ``` JupyterLab ``` SELECT JSON_EXTRACT(mydata_ParentTable, "$.child") AS col0 FROM...

the update works! and the one i used is version: 1.3.1415926

2. DuckDB is using True and False for Boolean instead of 0 and 1. When running the test `psql_bool_test`, we need ensure that it is comparable.

@jhuff-ccsw Hi, we are currently developing a website for Logica and here is the cheatsheet for imperatives https://logica-web.github.io/usrguide/imperatives.html

To resolve this, we should use ``` @Engine("duckdb"); Example(QuoteIt("case")); ```

@EvgSkv I just realized I forgot the `QuoteIt` usage under Sqlite, could you please add it here for record : ) Thanks PS: Is there a reason we use `QuoteIt`...