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		[ All Revisions ] [ 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-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)