79688466

Date: 2025-07-03 07:57:50
Score: 4.5
Natty:
Report link

I'm facing the same problem, but unable to solve it. Using spring boot 3.4.5, r2dbc-postgresql 1.0.7. My query looks like:

               select test.id,
                      test.name,
                      test.description,
                      test.active,                     
                      count(q.id) as questions_count
               from test_entity test
                        left join test_question q on q.test_entity_id = test.id
               group by test.id, test.name, test.description, test.active

I tried many variants of spelling questions_count, but always get null.

I even tried to wrap this query into

select mm.* (
       ...
       ) mm

But that doesn't help.

I'm using R2dbcRepository with @Query annotation, and interface for retrieving result set.

Reasons:
  • Blacklisted phrase (1): m facing the same problem
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Me too answer (2.5): I'm facing the same problem
  • User mentioned (1): @Query
  • Low reputation (1):
Posted by: Egor Shestukhin