ORA-01735: 无效的 ALTER TABLE 选项 (Sync2) #1138

New Issue

lunny · 2018-11-09T08:42:39Z

wahaha666 commented

2018-11-09 08:42:39 +00:00

(Migrated from github.com)

if err := engine.Sync2(&His{}); err != nil {
fmt.Println(err)
}
xorm log:
[xorm] [info] 2018/11/09 16:31:07.894126 [SQL] ALTER TABLE "His" ADD "JHJH" VARCHAR2(255) NULL ;
prints error: ORA-01735: 无效的 ALTER TABLE 选项

Then I copy the log's sql and run:
if _, err := engine.Exec("ALTER TABLE "His" ADD "JHJH" VARCHAR2(255) NULL ;"); err != nil {
fmt.Println(err)
}
it prints the same error!
When I remove the semicolon，there was no error printed. （unnecessary semicolon）

if err := engine.Sync2(&His{}); err != nil { fmt.Println(err) } xorm log: [xorm] [info] 2018/11/09 16:31:07.894126 [SQL] **ALTER TABLE "His" ADD "JHJH" VARCHAR2(255) NULL ;** prints error: **ORA-01735**: 无效的 ALTER TABLE 选项 Then I copy the log's sql and run: if _, err := engine.Exec("ALTER TABLE \"His\" ADD \"JHJH\" VARCHAR2(255) NULL ;"); err != nil { fmt.Println(err) } it prints the **same error!** When I remove the semicolon，there was no error printed. （**unnecessary semicolon**）

lunny added this to the 1.1.1 milestone 2020-03-03 12:53:23 +00:00

lunny added the

db

oracle

label 2021-06-06 13:18:35 +00:00

lunny modified the milestone from 1.1.1 to (deleted)

2021-06-07 08:26:41 +00:00

lunny removed this from the (deleted) milestone 2023-07-26 01:23:28 +00:00

Sign in to join this conversation.

No Milestone

No Assignees

1 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#1138