Change the test case for #3945

[semihsalihoglu-uw]

This PR was fixing a bug with the recursive joins: https://github.com/kuzudb/kuzu/pull/3945, that was found by Prashanth (though Chang reported it) on a dataset he had. Even though the dataset surfaces the bug, instead of using user reported datasets, let's try to use simpler minimal examples to reproduce the same bug. So let's remove the dataset transfer_demo and the transfer_demo.test. Instead let's try to think of a simpler dataset that is easier to understand, with fewer nodes and edges, that reproduces the same bug and add another test to another file.

I'm not sure which test file would be appropriate to add a test. I can't find a test that tests recursive relationship patterns. We might want to add a test under tests_files/issue and put it there. @andyfengHKU can comment here.