Auto Increment doesn't work properly in Oracle #1039

New Issue

lunny · 2018-07-16T17:56:21Z

rofly commented

2018-07-16 17:56:21 +00:00

(Migrated from github.com)

When a field has the tag "autoincr", in the insert process Xorm will always try to select the next value for the sequence from a fixed sequence, named:

https://github.com/go-xorm/xorm/blob/master/session_insert.go#L386

Instead of having an option to specify the sequence name that the value should be extracted from.

When a field has the tag "autoincr", in the insert process Xorm will always try to select the next value for the sequence from a fixed sequence, named: https://github.com/go-xorm/xorm/blob/master/session_insert.go#L386 Instead of having an option to specify the sequence name that the value should be extracted from.

lunny commented

2018-07-18 02:47:58 +00:00

Please feel free to send a PR.

yixin19 commented

2019-01-29 23:40:37 +00:00

(Migrated from github.com)

Did someone fix this issue?
I have the same problem.
ORA-01036: illegal variable name/number

Did someone fix this issue? I have the same problem. ORA-01036: illegal variable name/number

rofly commented

2019-02-02 13:03:27 +00:00

(Migrated from github.com)

I started building the code for autoincrement back in 2018, but the project i was working on was canceled and I'm no longer working with Go + Oracle.

I can take a look in the code on monday and reply here.

I started building the code for autoincrement back in 2018, but the project i was working on was canceled and I'm no longer working with Go + Oracle. I can take a look in the code on monday and reply here.

yixin19 commented

2019-02-02 14:38:03 +00:00

(Migrated from github.com)

I started building the code for autoincrement back in 2018, but the project i was working on was canceled and I'm no longer working with Go + Oracle.

I can take a look in the code on monday and reply here.

I will appreciate it if you have the code

> I started building the code for autoincrement back in 2018, but the project i was working on was canceled and I'm no longer working with Go + Oracle. > > I can take a look in the code on monday and reply here. I will appreciate it if you have the code

lunny referenced this issue

2020-03-03 12:54:20 +00:00

tag autoincr is not working #1063

lunny added the

kind

bug

label 2020-03-03 12:54:33 +00:00

lunny added this to the 1.1.1 milestone 2020-03-03 12:54:36 +00:00

lunny referenced this issue

2020-03-03 12:57:11 +00:00

OracleID自增序列不能支持。 #538

lunny added the