CREATE TABLE code
(
code_id varchar(255)
);
INSERT INTO code (code_id)
VALUES ('test');
SELECT t.id,
code.code_id
from (
values ('error'), ('test')
) as t (id)
left join code on code.code_id = t.id;
Q1JFQVRFIFRBQkxFIGNvZGUKKApjb2RlX2lkIHZhcmNoYXIoMjU1KQopOwoKSU5TRVJUIElOVE8gY29kZSAoY29kZV9pZCkKVkFMVUVTICgndGVzdCcpOwoKClNFTEVDVCB0LmlkLCAKICAgICAgIGNvZGUuY29kZV9pZApmcm9tICgKICB2YWx1ZXMgKCdlcnJvcicpLCAoJ3Rlc3QnKQopIGFzIHQgKGlkKSAKICBsZWZ0IGpvaW4gY29kZSBvbiBjb2RlLmNvZGVfaWQgPSB0LmlkOw==