Logs don't show the correct attributes

[matthieujabbour]

Let's use a small example:

INSERT INTO otel_logs ( Timestamp, TimestampTime, TraceId, SpanId, TraceFlags, SeverityText, SeverityNumber, ServiceName, Body, ResourceSchemaUrl, ResourceAttributes, ScopeSchemaUrl, ScopeName, ScopeVersion, ScopeAttributes, LogAttributes ) VALUES ('2026-02-19 11:56:25.573000000', '2026-02-19 11:56:25', 'b5f55ba908baa7c2ee542ea6b88e3abc', '3d6148b05c0c4b84', 1, 'info', 9, 'test', 'test', '', {'k8s.node.name':'31f87b44ce45','service.name':'test','service.version':'1.0.0'}, '', 'test.backend', '1.0.0', {}, {'value':'2'}), ('2026-02-19 11:56:25.573000000', '2026-02-19 11:56:25', 'b5f55ba908baa7c2ee542ea6b88e3abc', '3d6148b05c0c4b84', 1, 'info', 9, 'test', 'test', '', {'k8s.node.name':'31f87b44ce45','service.name':'test','service.version':'1.0.0'}, '', 'test.backend', '1.0.0', {}, {'value':'3'}), ('2026-02-19 11:56:25.573000000', '2026-02-19 11:56:25', 'b5f55ba908baa7c2ee542ea6b88e3abc', '3d6148b05c0c4b84', 1, 'info', 9, 'test', 'test', '', {'k8s.node.name':'31f87b44ce45','service.name':'test','service.version':'1.0.0'}, '', 'test.backend', '1.0.0', {}, {'value':'4'}), ('2026-02-19 11:56:25.573000000', '2026-02-19 11:56:25', 'b5f55ba908baa7c2ee542ea6b88e3abc', '3d6148b05c0c4b84', 1, 'info', 9, 'test', 'test', '', {'k8s.node.name':'31f87b44ce45','service.name':'test','service.version':'1.0.0'}, '', 'test.backend', '1.0.0', {}, {'value':'5'}), ('2026-02-19 11:56:25.573000000', '2026-02-19 11:56:25', 'b5f55ba908baa7c2ee542ea6b88e3abc', '3d6148b05c0c4b84', 1, 'info', 9, 'test', 'test', '', {'k8s.node.name':'31f87b44ce45','service.name':'test','service.version':'1.0.0'}, '', 'test.backend', '1.0.0', {}, {'value':'6'});

In traces and logs stream, these logs are "stacked vertically", and absolutely identical (showing the same LogAttributes), although their actual attributes values differ.

Thanks again for your amazing work 🥇

[wrn14897]

I believe this ticket is related to #1155. Due to the lack of uniqueness in the selected fields, when an individual line is selected, the query returns the same details.

In this example, adding LogAttributes to the SELECT statement should resolve the issue.

[matthieujabbour]

Indeed, adding LogAttributes to the SELECT statement works just fine, except in the span's events details view (as we can't change the query that's performed here).