search

SAP / olingo-jpa-processor-v4

The JPA Processor fills the gap between Olingo V4 and the database, by providing a mapping between JPA metadata and OData metadata, generating queries and supporting the entity manipulations.
Apache License 2.0
121 stars 76 forks source link

v2.1.3: Unit test errors #347

Open spatanjali opened 2 days ago

spatanjali commented 2 days ago

@wog48 Unable to build the v2.1.3 release branch due to the following seven unit test errors within the odata-jpa-processor module

[ERROR]   TestScalarDbFunctions.testFilterOnFunction:68 {"error":{"code":null,"message":"Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.3.v202405220658): org.eclipse.persistence.exceptions.DatabaseException\r\nInternal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PopulationDensity in statement [SELECT E0.\"CodePublisher\" S0, E0.\"CountryISOCode\" S1, E0.\"Area\" S2, E0.\"Population\" S3, E0.\"DivisionCode\" S4, E0.\"ParentDivisionCode\" S5, E0.\"ParentCodeID\" S6, E0.\"AlternativeCode\" S7, E0.\"CodeID\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") > ?)]\r\nError Code: -5501\r\nCall: SELECT E0.\"CodePublisher\" S0, E0.\"CountryISOCode\" S1, E0.\"Area\" S2, E0.\"Population\" S3, E0.\"DivisionCode\" S4, E0.\"ParentDivisionCode\" S5, E0.\"ParentCodeID\" S6, E0.\"AlternativeCode\" S7, E0.\"CodeID\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") > ?)\r\n\tbind => [1]\r\nQuery: DataReadQuery(sql=\"SELECT E0.\"CodePublisher\" S0, E0.\"CountryISOCode\" S1, E0.\"Area\" S2, E0.\"Population\" S3, E0.\"DivisionCode\" S4, E0.\"ParentDivisionCode\" S5, E0.\"ParentCodeID\" S6, E0.\"AlternativeCode\" S7, E0.\"CodeID\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") > ?)\")"}} ==> expected: <200> but was: <500>

[ERROR]   TestScalarDbFunctions.testFilterOnFunctionAndMultiply:96 {"error":{"code":null,"message":"Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.3.v202405220658): org.eclipse.persistence.exceptions.DatabaseException\r\nInternal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PopulationDensity in statement [SELECT E0.\"CodeID\" S0, E0.\"DivisionCode\" S1, E0.\"ParentCodeID\" S2, E0.\"Area\" S3, E0.\"CodePublisher\" S4, E0.\"Population\" S5, E0.\"CountryISOCode\" S6, E0.\"AlternativeCode\" S7, E0.\"ParentDivisionCode\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE ((\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") * ?) > ?)]\r\nError Code: -5501\r\nCall: SELECT E0.\"CodeID\" S0, E0.\"DivisionCode\" S1, E0.\"ParentCodeID\" S2, E0.\"Area\" S3, E0.\"CodePublisher\" S4, E0.\"Population\" S5, E0.\"CountryISOCode\" S6, E0.\"AlternativeCode\" S7, E0.\"ParentDivisionCode\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE ((\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") * ?) > ?)\r\n\tbind => [1000000.0, 100]\r\nQuery: DataReadQuery(sql=\"SELECT E0.\"CodeID\" S0, E0.\"DivisionCode\" S1, E0.\"ParentCodeID\" S2, E0.\"Area\" S3, E0.\"CodePublisher\" S4, E0.\"Population\" S5, E0.\"CountryISOCode\" S6, E0.\"AlternativeCode\" S7, E0.\"ParentDivisionCode\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE ((\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") * ?) > ?)\")"}} ==> expected: <200> but was: <500>

[ERROR]   TestScalarDbFunctions.testFilterOnFunctionAndMultiply:96 {"error":{"code":null,"message":"Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.3.v202405220658): org.eclipse.persistence.exceptions.DatabaseException\r\nInternal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PopulationDensity in statement [SELECT E0.\"CodeID\" S0, E0.\"CountryISOCode\" S1, E0.\"CodePublisher\" S2, E0.\"ParentCodeID\" S3, E0.\"DivisionCode\" S4, E0.\"AlternativeCode\" S5, E0.\"Area\" S6, E0.\"ParentDivisionCode\" S7, E0.\"Population\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE ((\"OLINGO\".\"PopulationDensity\"(?, E0.\"Population\") * ?) > ?)]\r\nError Code: -5501\r\nCall: SELECT E0.\"CodeID\" S0, E0.\"CountryISOCode\" S1, E0.\"CodePublisher\" S2, E0.\"ParentCodeID\" S3, E0.\"DivisionCode\" S4, E0.\"AlternativeCode\" S5, E0.\"Area\" S6, E0.\"ParentDivisionCode\" S7, E0.\"Population\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE ((\"OLINGO\".\"PopulationDensity\"(?, E0.\"Population\") * ?) > ?)\r\n\tbind => [13079087, 1000000.0, 1000]\r\nQuery: DataReadQuery(sql=\"SELECT E0.\"CodeID\" S0, E0.\"CountryISOCode\" S1, E0.\"CodePublisher\" S2, E0.\"ParentCodeID\" S3, E0.\"DivisionCode\" S4, E0.\"AlternativeCode\" S5, E0.\"Area\" S6, E0.\"ParentDivisionCode\" S7, E0.\"Population\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE ((\"OLINGO\".\"PopulationDensity\"(?, E0.\"Population\") * ?) > ?)\")"}} ==> expected: <200> but was: <500>

[ERROR]   TestScalarDbFunctions.testFilterOnFunctionAndMultiply:96 {"error":{"code":null,"message":"Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.3.v202405220658): org.eclipse.persistence.exceptions.DatabaseException\r\nInternal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PopulationDensity in statement [SELECT E0.\"CountryISOCode\" S0, E0.\"ParentDivisionCode\" S1, E0.\"CodeID\" S2, E0.\"Population\" S3, E0.\"DivisionCode\" S4, E0.\"AlternativeCode\" S5, E0.\"ParentCodeID\" S6, E0.\"Area\" S7, E0.\"CodePublisher\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (\"OLINGO\".\"PopulationDensity\"((E0.\"Area\" / ?), E0.\"Population\") > ?)]\r\nError Code: -5501\r\nCall: SELECT E0.\"CountryISOCode\" S0, E0.\"ParentDivisionCode\" S1, E0.\"CodeID\" S2, E0.\"Population\" S3, E0.\"DivisionCode\" S4, E0.\"AlternativeCode\" S5, E0.\"ParentCodeID\" S6, E0.\"Area\" S7, E0.\"CodePublisher\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (\"OLINGO\".\"PopulationDensity\"((E0.\"Area\" / ?), E0.\"Population\") > ?)\r\n\tbind => [1000000, 1000]\r\nQuery: DataReadQuery(sql=\"SELECT E0.\"CountryISOCode\" S0, E0.\"ParentDivisionCode\" S1, E0.\"CodeID\" S2, E0.\"Population\" S3, E0.\"DivisionCode\" S4, E0.\"AlternativeCode\" S5, E0.\"ParentCodeID\" S6, E0.\"Area\" S7, E0.\"CodePublisher\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (\"OLINGO\".\"PopulationDensity\"((E0.\"Area\" / ?), E0.\"Population\") > ?)\")"}} ==> expected: <200> but was: <500>

[ERROR]   TestScalarDbFunctions.testFilterOnFunctionAndMultiply:96 {"error":{"code":null,"message":"Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.3.v202405220658): org.eclipse.persistence.exceptions.DatabaseException\r\nInternal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PopulationDensity in statement [SELECT E0.\"ParentCodeID\" S0, E0.\"Area\" S1, E0.\"DivisionCode\" S2, E0.\"AlternativeCode\" S3, E0.\"CodePublisher\" S4, E0.\"Population\" S5, E0.\"CountryISOCode\" S6, E0.\"ParentDivisionCode\" S7, E0.\"CodeID\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE ((\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") * ?) > ?)]\r\nError Code: -5501\r\nCall: SELECT E0.\"ParentCodeID\" S0, E0.\"Area\" S1, E0.\"DivisionCode\" S2, E0.\"AlternativeCode\" S3, E0.\"CodePublisher\" S4, E0.\"Population\" S5, E0.\"CountryISOCode\" S6, E0.\"ParentDivisionCode\" S7, E0.\"CodeID\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE ((\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") * ?) > ?)\r\n\tbind => [1000000.0, 1000]\r\nQuery: DataReadQuery(sql=\"SELECT E0.\"ParentCodeID\" S0, E0.\"Area\" S1, E0.\"DivisionCode\" S2, E0.\"AlternativeCode\" S3, E0.\"CodePublisher\" S4, E0.\"Population\" S5, E0.\"CountryISOCode\" S6, E0.\"ParentDivisionCode\" S7, E0.\"CodeID\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE ((\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") * ?) > ?)\")"}} ==> expected: <200> but was: <500>

[ERROR]   TestScalarDbFunctions.testFilterOnFunctionAndProperty:56 {"error":{"code":null,"message":"Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.3.v202405220658): org.eclipse.persistence.exceptions.DatabaseException\r\nInternal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PopulationDensity in statement [SELECT E0.\"ParentDivisionCode\" S0, E0.\"DivisionCode\" S1, E0.\"ParentCodeID\" S2, E0.\"Population\" S3, E0.\"AlternativeCode\" S4, E0.\"Area\" S5, E0.\"CodePublisher\" S6, E0.\"CountryISOCode\" S7, E0.\"CodeID\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (((\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") * ?) > ?) AND (E0.\"ParentDivisionCode\" = ?))]\r\nError Code: -5501\r\nCall: SELECT E0.\"ParentDivisionCode\" S0, E0.\"DivisionCode\" S1, E0.\"ParentCodeID\" S2, E0.\"Population\" S3, E0.\"AlternativeCode\" S4, E0.\"Area\" S5, E0.\"CodePublisher\" S6, E0.\"CountryISOCode\" S7, E0.\"CodeID\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (((\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") * ?) > ?) AND (E0.\"ParentDivisionCode\" = ?))\r\n\tbind => [1000000.0, 1000, BE255]\r\nQuery: DataReadQuery(sql=\"SELECT E0.\"ParentDivisionCode\" S0, E0.\"DivisionCode\" S1, E0.\"ParentCodeID\" S2, E0.\"Population\" S3, E0.\"AlternativeCode\" S4, E0.\"Area\" S5, E0.\"CodePublisher\" S6, E0.\"CountryISOCode\" S7, E0.\"CodeID\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (((\"OLINGO\".\"PopulationDensity\"(E0.\"Area\", E0.\"Population\") * ?) > ?) AND (E0.\"ParentDivisionCode\" = ?))\")"}} ==> expected: <200> but was: <500>

[ERROR]   TestScalarDbFunctions.testFilterOnFunctionNested:110 {"error":{"code":null,"message":"Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.3.v202405220658): org.eclipse.persistence.exceptions.DatabaseException\r\nInternal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PopulationDensity in statement [SELECT E0.\"ParentCodeID\" S0, E0.\"CodeID\" S1, E0.\"Population\" S2, E0.\"ParentDivisionCode\" S3, E0.\"DivisionCode\" S4, E0.\"Area\" S5, E0.\"CodePublisher\" S6, E0.\"CountryISOCode\" S7, E0.\"AlternativeCode\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (\"OLINGO\".\"PopulationDensity\"(\"OLINGO\".\"ConvertToQkm\"(E0.\"Area\"), E0.\"Population\") > ?)]\r\nError Code: -5501\r\nCall: SELECT E0.\"ParentCodeID\" S0, E0.\"CodeID\" S1, E0.\"Population\" S2, E0.\"ParentDivisionCode\" S3, E0.\"DivisionCode\" S4, E0.\"Area\" S5, E0.\"CodePublisher\" S6, E0.\"CountryISOCode\" S7, E0.\"AlternativeCode\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (\"OLINGO\".\"PopulationDensity\"(\"OLINGO\".\"ConvertToQkm\"(E0.\"Area\"), E0.\"Population\") > ?)\r\n\tbind => [1000]\r\nQuery: DataReadQuery(sql=\"SELECT E0.\"ParentCodeID\" S0, E0.\"CodeID\" S1, E0.\"Population\" S2, E0.\"ParentDivisionCode\" S3, E0.\"DivisionCode\" S4, E0.\"Area\" S5, E0.\"CodePublisher\" S6, E0.\"CountryISOCode\" S7, E0.\"AlternativeCode\" S8 FROM \"OLINGO\".\"AdministrativeDivision\" E0 WHERE (\"OLINGO\".\"PopulationDensity\"(\"OLINGO\".\"ConvertToQkm\"(E0.\"Area\"), E0.\"Population\") > ?)\")"}} ==> expected: <200> but was: <500>