0034209: DB consistency error with function index with 2 or more parameters separated by blank space or not

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #34209		[ Back to Issue ]
Summary	0034209: DB consistency error with function index with 2 or more parameters separated by blank space or not

Revision	2016-10-17 14:01 by inigosanchez
Steps To Reproduce	1.- Apply the attached patch in issue 0033581. It defines a function called OBEQUALS inside the prescripts* files, which is linked to a new index in FIN_PAYMENT table. Note than functionExpression is defined with a blank space between parameters: + <index-column name="functionBasedColumn" functionExpression="OBEQUALS(GENERATED_CREDIT, USED_CREDIT)"/> 2.- Run ant smartbuild -Dlocal=no (or install source). Verify it works fine. 3.- Set Core in development. 4.- Run ant export.database. Verify the index definition has changed. This creates a db consistency problem Please note that this code is working fine for Postgresql (9.3) Otherwise, If you define this functionExpression without blank space between parameters, the problem is raised in db consistency of postgresql: For this case functionExpression is defined without a blank space between parameters: + <index-column name="functionBasedColumn" functionExpression="OBEQUALS(GENERATED_CREDIT,USED_CREDIT)"/> Repeat steps defined above. See attached file to see the results of the export database: try-dbcons-pgsql-differences

Revision	2016-10-17 14:01 by inigosanchez
Description	A new function is defined in the prescript-Oracle.sql. This function is linked to a function index in any table. The install source and update database processes are working fine, however the export database modifies the function index definition. See attached file: try-dbcons-oracle-differences.

Revision	2016-10-14 12:53 by inigosanchez
Description	A new function is defined in the prescript-Oracle.sql. This function is linked to a function index in any table. The install source and update database processes are working fine, however the export database modifies the function index definition in Oracle only. See attached file: try-dbcons-oracle-differences.

Revision	2016-10-14 12:53 by inigosanchez
Steps To Reproduce	1.- Apply the attached patch in issue 0033581. It defines a function called OBEQUALS inside the prescripts* files, which is linked to a new index in FIN_PAYMENT table. *Note than functionExpression is defined with a blank space between parameters: + <index-column name="functionBasedColumn" functionExpression="OBEQUALS(GENERATED_CREDIT, USED_CREDIT)"/> 2.- Run ant smartbuild -Dlocal=no (or install source). Verify it works fine. 3.- Set Core in development. 4.- Run ant export.database. Verify the index definition has changed. This creates a db consistency problem Please note that this code is working fine for Postgresql (9.3)

Revision	2016-10-14 12:53 by inigosanchez
Steps To Reproduce	1.- Apply the attached patch in issue 0033581. It defines a function called OBEQUALS inside the prescripts* files, which is linked to a new index in FIN_PAYMENT table. *Note than functionExpression is defined with a blank space between parameters: + <index-column name="functionBasedColumn" functionExpression="OBEQUALS(GENERATED_CREDIT, USED_CREDIT)"/> 2.- Run ant smartbuild -Dlocal=no (or install source). Verify it works fine. 3.- Set Core in development. 4.- Run ant export.database. Verify the index definition has changed. This creates a db consistency problem Please note that this code is working fine for Postgresql (9.3)