oracle 测试不能执行会报【ORA-00936: missing expression】 #1686
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
3 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: xorm/xorm#1686
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?
排查跟踪发现select [id] from .....
core/db.go`
去掉[]之后就可以正常。生成的时候带了[]
150行加入
query = strings.Replace(query, "[", "", -1)
query = strings.Replace(query, "]", "", -1)
`
后就正常。
Have you tried latest version?
yes, version1.0.1
Use
SetQuotePolicy(dialects.QuotePolicyNone)
could avoid the problem.@FlyingOnion Thanks! This is a workround currently.
这个是oracleQuoter的问题,oracle的sql用中括号、反引号都不行。大多数情况下去掉quoter可以解决问题,但还有个问题是oracle的表名在无引号时case insensitive,均视为全大写,但有引号时case sensitive。
TableName
全大写时无影响,但不全大写的情况会报错。