`@relationDocument` referring to an optional `StreamID` yields internal server error if unset about js-composedb

[m0ar]

This PR should fix the underlying problem: ceramicnetwork/js-ceramic#2999

I'm not able to figure out the correct overrides in my package.json to avoid this error, though (NOT NULL constraint).
Might need to wait for a release to confirm :)

Error: HTTP request to 'http://localhost:7007/api/v0/streams' failed with status 'Internal Server Error': {"error":"insert into `kjzl6hvfrbw6cap4qlstwhaflqx9jw517zw5h02m4khxog6jz3t6k05apg1hr2s` (`controller_did`, `created_at`, `custom_claimID`, `first_anchored_at`, `last_anchored_at`, `stream_content`, `stream_id`, `tip`, `updated_at`) values ('did:key:z6MknoDgHEeMqKES8P5MGMUcKA16Vbti9pCf6j8tu2GztiY1', 1698229060745, NULL, NULL, NULL, '{\"comment\":\"This is a cool object!\",\"targetID\":\"kjzl6kcym7w8yap35atjuv48weys0iix2foenkillgftr4m0f5t65xg84s5pbdf\",\"targetVersion\":\"k3y52mos6605bnw2edoy57ha7aifb7nqj5bhk7lw9kkwjkwsiztbfu5vdu08k0veo\"}', 'kjzl6kcym7w8y89s19uiwu1gu4ba2dzr2kavxdx6sp75ba3jkprxl9jfayz7cf4', 'bagcqceraq73obwfexolshdx2ozggojb4vkbfrvpqqn56vc3omscuqyrtmwqa', 1698229060745) on conflict (`stream_id`) do update set `stream_id` = 'kjzl6kcym7w8y89s19uiwu1gu4ba2dzr2kavxdx6sp75ba3jkprxl9jfayz7cf4',`controller_did` = 'did:key:z6MknoDgHEeMqKES8P5MGMUcKA16Vbti9pCf6j8tu2GztiY1',`stream_content` = '{\"comment\":\"This is a cool object!\",\"targetID\":\"kjzl6kcym7w8yap35atjuv48weys0iix2foenkillgftr4m0f5t65xg84s5pbdf\",\"targetVersion\":\"k3y52mos6605bnw2edoy57ha7aifb7nqj5bhk7lw9kkwjkwsiztbfu5vdu08k0veo\"}',`tip` = 'bagcqceraq73obwfexolshdx2ozggojb4vkbfrvpqqn56vc3omscuqyrtmwqa',`last_anchored_at` = NULL,`first_anchored_at` = NULL,`updated_at` = 1698229060745 - SQLITE_CONSTRAINT: NOT NULL constraint failed: kjzl6hvfrbw6cap4qlstwhaflqx9jw517zw5h02m4khxog6jz3t6k05apg1hr2s.custom_claimID"}

[m0ar]

@dbcfd @stbrody I'm still not able to get around this on the latest version. Has ceramicnetwork/js-ceramic#2999 been included in a composedb release yet?

[stbrody]

Sorry @m0ar, unfortunately the release of this has been held up by an unrelated bug that has been preventing us from making a new release of js-ceramic (you may have noticed it's been longer than usual since we've done a release). It's a major priority of the team right now to fix that bug so we can do a Ceramic release, which will include getting out this fix for optional relations.

[m0ar]

Sorry @m0ar, unfortunately the release of this has been held up by an unrelated bug that has been preventing us from making a new release of js-ceramic (you may have noticed it's been longer than usual since we've done a release). It's a major priority of the team right now to fix that bug so we can do a Ceramic release, which will include getting out this fix for optional relations.

Makes total sense @stbrody , appreciate the context 🙏:cupcake: