version字段的update生成语句有歧义 #1784
Labels
No Label
backport/done
backport/v1
blocked
db
oracle
db
sqlserver
duplicate
feature
cache
frontport/done
frontport/main
invalid
kind
breaking
kind
bug
kind
build
kind
dependencies
kind
docs
kind
driver
kind
enhancement
kind
feature
kind
performance
kind
proposal
kind
question
kind
refactor
kind
testing
need
feedback
need
test
proposal:accepted
RaspBerry Pi
regression
skip-changelog
upstream
wip
wontfix
No Milestone
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: xorm/xorm#1784
Loading…
Reference in New Issue
Block a user
No description provided.
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
建议按照参数顺序判断,优先判断参数2的version,没有再使用参数1的version?
另外,还有一个问题,应该配一个开关,设置NoAutoVersionCondition( 即修改CheckVersion变量), 自带的NoAutoCondition 无效的。
例如我是要批量更新多条记录时,version自动加到条件(where version=x),导致会出现不命中。
如 update record set status = 1 , version = version+1 where status=2 这条语句
生成出来的却是 update record set status = 1 , version = version+1 where status=2 and
version=0建议应当是
// update record set status = 1 , version = version+1 where status=2 // good
RelicOfTesla referenced this issue2020-09-16 15:46:02 +00:00