Getting Started Tutorial join example does not work correctly

[agentofreality]

In the Drasi Server Getting Started tutorial (/docs/content/drasi-server/getting-started/_index.md) I tried to add a join-based example. However, this would not work correctly, the sample I tried to create is contained at the end of this file: /docs/content/drasi-server/getting-started/_index_with_join.md

[ruokun-niu]

@agentofreality do you recall what you were seeing initially? I just attempted run this example and I got the following error

./examples/sse-cli/target/release/drasi-sse-cli \
  --server http://localhost:8080 \
  --query messages-with-location
Creating SSE reaction 'sse-cli-f97d2b2f' for query 'messages-with-location'... done.
Streaming events (Ctrl-C to stop)...

Connected to SSE stream at http://localhost:8090/events
{
  "queryId": "messages-with-location",
  "results": [
    {
      "data": {
        "Id": "2",
        "Location": "Conference Room B",
        "Message": "Hello World",
        "Sender": "Brian Kernighan",
        "Status": "away"
      },
      "type": "ADD"
    }
  ],
  "timestamp": 1771453960327
}
{
  "queryId": "messages-with-location",
  "results": [
    {
      "data": {
        "Id": "5",
        "Location": "Home Office",
        "Message": "Good morning!",
        "Sender": "Alice",
        "Status": "online"
      },
      "type": "ADD"
    }
  ],
  "timestamp": 1771453996224
}

[ruokun-niu]

Oh I think I have uncovered another issue:
After inserting the two entries as suggested in the /docs/content/drasi-server/getting-started/_index_with_join.md, I observed the two changes listed above. However, when I stopped the server and restarted it, I got an empty result set when I used curl:

curl -s http://localhost:8080/api/v1/queries/messages-with-location/results
{"success":true,"data":[],"error":null}%    // No Data 

When I inserted another entry to the postgres db, I can see all of the results:

ruokunniu ~/Documents/drasi/ruokun/drasi-server [drasi-source-join-investigation] $ curl -s http://localhost:8080/api/v1/queries/messages-with-location/results
{"success":true,"data":[{"Id":"6","Location":"Home Office","Message":"Good morning!","Sender":"Alice","Status":"online"},{"Id":"5","Location":"Home Office","Message":"Good morning!","Sender":"Alice","Status":"online"},{"Id":"7","Location":"Home Office","Message":"Good morning!","Sender":"Alice","Status":"online"}],"error":null}%