HHH-19453 Fix sequence information extraction on DB2 for i

beikov · beikov · commit 2b7969b074e5 · 2025-08-08T14:06:48.000+02:00
diff --git a/hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/DB2iLegacyDialect.java b/hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/DB2iLegacyDialect.java
@@ -123,7 +123,7 @@ public SequenceSupport getSequenceSupport() {
 	@Override
 	public String getQuerySequencesString() {
 		if ( getVersion().isSameOrAfter(7,3) ) {
-			return "select distinct sequence_name from qsys2.syssequences " +
+			return "select distinct sequence_schema as seqschema, sequence_name as seqname, START, minimum_value as minvalue, maximum_value as maxvalue, increment from qsys2.syssequences " +
 					"where current_schema='*LIBL' and sequence_schema in (select schema_name from qsys2.library_list_info) " +
 					"or sequence_schema=current_schema";
 		}
diff --git a/hibernate-core/src/main/java/org/hibernate/dialect/DB2iDialect.java b/hibernate-core/src/main/java/org/hibernate/dialect/DB2iDialect.java
@@ -120,7 +120,7 @@ public SequenceSupport getSequenceSupport() {
 	@Override
 	public String getQuerySequencesString() {
 		if ( getVersion().isSameOrAfter(7,3) ) {
-			return "select distinct sequence_name from qsys2.syssequences " +
+			return "select distinct sequence_schema as seqschema, sequence_name as seqname, START, minimum_value as minvalue, maximum_value as maxvalue, increment from qsys2.syssequences " +
 					"where current_schema='*LIBL' and sequence_schema in (select schema_name from qsys2.library_list_info) " +
 					"or sequence_schema=current_schema";
 		}

Original file line number	Diff line number	Diff line change
`@@ -123,7 +123,7 @@ public SequenceSupport getSequenceSupport() {`
`123`	`123`	`@Override`
`124`	`124`	`public String getQuerySequencesString() {`
`125`	`125`	`if ( getVersion().isSameOrAfter(7,3) ) {`
`126`		`- return "select distinct sequence_name from qsys2.syssequences " +`
	`126`	`+ return "select distinct sequence_schema as seqschema, sequence_name as seqname, START, minimum_value as minvalue, maximum_value as maxvalue, increment from qsys2.syssequences " +`
`127`	`127`	`"where current_schema='*LIBL' and sequence_schema in (select schema_name from qsys2.library_list_info) " +`
`128`	`128`	`"or sequence_schema=current_schema";`
`129`	`129`	`}`
Original file line number	Diff line number	Diff line change
`@@ -120,7 +120,7 @@ public SequenceSupport getSequenceSupport() {`
`120`	`120`	`@Override`
`121`	`121`	`public String getQuerySequencesString() {`
`122`	`122`	`if ( getVersion().isSameOrAfter(7,3) ) {`
`123`		`- return "select distinct sequence_name from qsys2.syssequences " +`
	`123`	`+ return "select distinct sequence_schema as seqschema, sequence_name as seqname, START, minimum_value as minvalue, maximum_value as maxvalue, increment from qsys2.syssequences " +`
`124`	`124`	`"where current_schema='*LIBL' and sequence_schema in (select schema_name from qsys2.library_list_info) " +`
`125`	`125`	`"or sequence_schema=current_schema";`
`126`	`126`	`}`