We're updating the issue view to help you get more done. 

CreateDeleteTest and FlushIdGenTest fail with ORA-00936 on oracle

Description

org.hibernate.id.CreateDeleteTest.createAndDeleteAnEntityInTheSameTransactionTest
org.hibernate.id.FlushIdGenTest.testPersistBeforeTransaction

Both tests use the same entity org.hibernate.id.RootEntity. This entity has only primary key column universalid and nothing else.

1 2 3 4 5 6 16:40:07,685 DEBUG SQL:94 - create table RootEntity ( universalid number(19,0) generated as identity, primary key (universalid) )

INSERT into such table fails with ORA-00936: missing expression

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 16:40:07,744 DEBUG SQL:94 - insert into RootEntity values ( ) Hibernate: insert into RootEntity values ( ) 16:40:07,750 WARN SqlExceptionHelper:137 - SQL Error: 936, SQLState: 42000 16:40:07,750 ERROR SqlExceptionHelper:142 - ORA-00936: missing expression

There should be at least one other column.

Environment

oracle12c

Status

Assignee

Martin Šimka

Reporter

Martin Šimka

Fix versions

Labels

backPortable

Backport?

Suitable for new contributors

Yes, likely

Requires Release Note

None

backportDecision

None

Components

Priority

Major