Stream::count returns 1

[minborg]

A user reports 1 always being returned from:

jpaStreamer.stream(SomeEntity.class).count();

But the table in question contains a large number of rows. This was using Oracle DB.

[ParthaNath28]

The sql query which is printed in the console once when I enable show-sql and that is working fine. When I change the count logic to return jpaStreamer.stream(Entity.class).toList().stream().count(); it is giving me correct record count but the performance is very slow. It took me 3 minutes to return the count of 24 thousand records perhaps may be due to the fact of object streaming of the entire record set.

[doriangrelu]

I have the same issue with an H2 Database...