Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

incorrect result of function 'count' #7283

Closed
schernolyas opened this issue Mar 29, 2017 · 12 comments
Closed

incorrect result of function 'count' #7283

schernolyas opened this issue Mar 29, 2017 · 12 comments
Assignees
Milestone

Comments

@schernolyas
Copy link

OrientDB Version: 3.0.0-SNAPSHOT

Java Version: 1.8

OS: Ubunto 16.10

Expected behavior

query "select count(@Rid) as c from Customer where bKey=1" must returns one.

Actual behavior

query "select count(@Rid) as c from Customer where bKey=1" must returns zero.
query "select from Customer where bKey=1" returns correct list of documents.

Steps to reproduce

execute query

@luigidellaquila luigidellaquila self-assigned this Mar 29, 2017
@luigidellaquila luigidellaquila added this to the 3.0-M1 milestone Mar 30, 2017
@schernolyas
Copy link
Author

Hi @luigidellaquila !

May be it helps to You. My module executes these queries during transaction.

I assume that function 'count' count committed objects only. but ...

@luigidellaquila
Copy link
Member

Hi @schernolyas

Thank you very much, it's definitely a valuable information! In V 3.0 the executor also considers documents created in current tx, so probably the issue is related to this. I'll let you know soon

Thanks

Luigi

@schernolyas
Copy link
Author

Hi @luigidellaquila !

Okey. I migrate my integration module from OrientDB 2.2 to OrientDB 3.0. And I have about 250 tests.
I will send to You information about bugs in release 3.0

@luigidellaquila
Copy link
Member

Hi @schernolyas

Thank you very much, very appreciated, early feedback on 3.0 is critical to reach a good level of stability on the GA

Thanks

Luigi

@luigidellaquila
Copy link
Member

Hi @schernolyas

I just tried it on latest snapshot and it seems to work fine. I tried it on demodb with the following query:

select count(@rid) as c from Countries where Id = 1

Do you have a specific dataset to reproduce the problem? Or maybe it's just already fixed?

Thanks

Luigi

@schernolyas
Copy link
Author

Hi @luigidellaquila !

Did you check it in transacton? Hibernate OGM do everything in transaction.

But okey. I will update my snapshot of OrientDB and recheck.

Self-fixed bugs ... is cool!

@luigidellaquila
Copy link
Member

Hi @schernolyas

I doubt it's self fixed 😆 maybe we did some changes in last few days that also impacted this. Develop branch is very active, so you can expect things to be fixed over night.

I didn't try it in tx, I'm doing it now. I'll let you know soon

Thanks

Luigi

@luigidellaquila
Copy link
Member

Ok, I tried it in tx, no luck on reproducing the issue unfortunately.
If you could reproduce it with plain Java or SQL it would help a lot on fixing

Thanks

Luigi

@schernolyas
Copy link
Author

Hi @luigidellaquila !

I see that you need additional information about the bug.
How I can set DEBUG logging level for OrientDB?

@schernolyas
Copy link
Author

P.S. I start OrientDB as in-memory database.

@schernolyas
Copy link
Author

Hi @luigidellaquila !

I rechecked. My last commit is commit cd19bce
I see that function 'count' fine.

self-fixed bug :)

@luigidellaquila
Copy link
Member

Great!!! I like self-fixing bugs 😄

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

3 participants