{"data":{"status":"fail","left":{"rows":6,"distinctKeys":4,"nullKeyRows":1,"maxMultiplicity":2,"unique":false},"right":{"rows":6,"distinctKeys":5,"nullKeyRows":0,"maxMultiplicity":2,"unique":false},"observedCardinality":"many-to-many","outputRows":{"inner":5,"left":8,"right":8,"full":11,"selected":8},"multiplicationFactor":1.3333333333333333,"unmatched":{"leftKeys":2,"rightKeys":3,"leftRows":3,"rightRows":3,"leftSample":[2,"007"],"rightSample":[4,"7"," 1"]},"fanOut":[{"key":3,"leftRows":2,"rightRows":2,"outputRows":4}],"coercionHazards":[{"kind":"type","left":1,"right":" 1"},{"kind":"leading-zeros","left":"007","right":"7"}],"witnesses":[{"ruleId":"key-coercion-hazard","detail":"1 and \" 1\" differ only by type; a typed join will not match them","expected":1,"actual":" 1"},{"ruleId":"key-coercion-hazard","detail":"\"007\" and \"7\" differ only by leading-zeros; a typed join will not match them","expected":"007","actual":"7"},{"ruleId":"right-not-unique","detail":"right key 3 appears 2 times","path":"/right/keys/2","expected":1,"actual":2},{"ruleId":"row-multiplication","detail":"left join yields 8 rows from 6 preserved rows; key 3 alone yields 4","path":"/expect/noRowMultiplication","expected":6,"actual":8}],"versions":{"join-semantics":"SQL equi-join: NULL never equals NULL (ISO/IEC 9075 three-valued comparison); output rows = sum over shared keys of left rows x right rows, plus unpreserved rows for outer joins","key-equality":"strict by JSON type and exact string unless normalize is supplied"},"limits":["Only the supplied keys are analysed; a sample of at most 5 unmatched keys per side is returned.","Counts mode accepts row counts up to 1,000,000 per key and 5,000 distinct keys."],"deterministic":true},"_provenance":{"version":"writerslogic-provenance/1","issuer":"did:web:agents.writerslogic.com","verify":{"endpoint":"POST /api/v1/verify-provenance","did":"did:web:agents.writerslogic.com"},"manifest":{"format":"application/json","instance_id":"xmp:iid:e367b160-4c46-410c-80bd-47254730d35b","claim_generator_info":[{"name":"WritersLogic x402 Agent Hub","version":"2.0.0"}],"title":"Row multiplication, unmatched keys and uniqueness violations before a table join","assertions":[{"label":"c2pa.actions.v2","data":{"actions":[{"action":"c2pa.created","when":"2026-11-06T01:30:23.021Z","softwareAgent":{"name":"writerslogic-agent-hub/join-cardinality","version":"2.0.0"},"digitalSourceType":"http://cv.iptc.org/newscodes/digitalsourcetype/algorithmicMedia","parameters":{"endpoint":"POST /api/v1/join-cardinality","inputDigest":{"alg":"sha256","hash":"49c54643710b3fd2f943b7b9062d907abf6e149ed03fbef0a544e61c5415f2a5","canonicalization":"JCS"}}}]}},{"label":"c2pa.hash.data","data":{"alg":"sha256","hash":"8778ddc6bf2ec7d18e12a8ae8e47233b7dd74f1a9e119c5a59772c43f5276ea7","name":"jcs-canonical-json(data)"}}]},"credential":{"@context":["https://www.w3.org/ns/credentials/v2"],"id":"urn:uuid:b57e1f1f-5a66-4416-b347-e0f82f0ac92e","type":["VerifiableCredential","AgentOutputCredential"],"issuer":"did:web:agents.writerslogic.com","validFrom":"2026-11-06T01:30:23.021Z","credentialSubject":{"id":"urn:sha256:8778ddc6bf2ec7d18e12a8ae8e47233b7dd74f1a9e119c5a59772c43f5276ea7","agent":"join-cardinality","endpoint":"POST /api/v1/join-cardinality","outputDigest":{"alg":"sha256","value":"8778ddc6bf2ec7d18e12a8ae8e47233b7dd74f1a9e119c5a59772c43f5276ea7","canonicalization":"JCS"},"inputDigest":{"alg":"sha256","value":"49c54643710b3fd2f943b7b9062d907abf6e149ed03fbef0a544e61c5415f2a5","canonicalization":"JCS"},"manifestDigest":{"alg":"sha256","value":"47e715387b6ce9d74a3961fd362681355095e28de143ee2a8a1d023a577397bf","canonicalization":"JCS"},"ingredients":[],"payment":{"scheme":"api-key","network":"eip155:8453","payer":"sample"}},"proof":{"type":"DataIntegrityProof","cryptosuite":"eddsa-jcs-2022","created":"2026-11-06T01:30:23.021Z","verificationMethod":"did:web:agents.writerslogic.com#key-1","proofPurpose":"assertionMethod","proofValue":"zez7kXBRWbutd2TKaYKY7cqw6sAzU9ycPSh8RikSD9xSEWt4ATjNz2XcbsxKqmx3aJpk44FWopEtkNE1tmqQ71d5"}},"ethSignature":{"type":"EIP-191","signer":"did:pkh:eip155:8453:0x3DBd42560cA7a7E448A2c7DfC9E785526189411f","address":"0x3DBd42560cA7a7E448A2c7DfC9E785526189411f","message":"writerslogic-provenance:3a73252305486fbf13a63417207bf761f518f33e1b83bedaf85c9414ed90ae4b","signature":"0x76a1358141fbb48cee2ded046467e94a585cffc4e0478b894407d919b223a7b3046285db7783cb352762843c0f0bc5639cb5d0a65ce774073c96b58e6616d1721b"}}}