Skip to content
This repository has been archived by the owner on Sep 4, 2018. It is now read-only.

Error while execute database query when rejudge #97

Closed
mzry1992 opened this issue Mar 15, 2014 · 1 comment · Fixed by #98
Closed

Error while execute database query when rejudge #97

mzry1992 opened this issue Mar 15, 2014 · 1 comment · Fixed by #98
Assignees
Labels
Milestone

Comments

@mzry1992
Copy link
Contributor

I'll fix it as soon as possible. @lyhypacm

@mzry1992 mzry1992 added this to the v.2.1.1 milestone Mar 15, 2014
@mzry1992 mzry1992 added the bug label Mar 15, 2014
@mzry1992 mzry1992 self-assigned this Mar 15, 2014
@mzry1992
Copy link
Contributor Author

It's seems something is wrong in hibernate, this HQL statement below

update Status set result=18 where ((contestByContestId is null) and userByUserId.userName like '%administrator%')

will translate to a incorrect SQL statement as this:

update
        status cross 
    join

    set
        result=18 
    where
        (
            contestId is null
        ) 
        and (
            userName like '%administrator%'
        )

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

Successfully merging a pull request may close this issue.

1 participant