Opened 7 years ago
Last modified 7 years ago
#934 closed task
Fix GenericRdbms unit test baseline — at Initial Version
Reported by: | jng | Owned by: | jng |
---|---|---|---|
Priority: | major | Milestone: | |
Component: | GenericRdbms API | Version: | |
Severity: | 3 | Keywords: | |
Cc: | External ID: |
Description
There's a whole series of backlogged patches against various GenericRdbms-based FDO providers (primarily for OSGeo.PostgreSQL
and OSGeo.SQLServerSpatial
) that I'd like to see applied, but before I do that, I want to make sure the GenericRdbms test suite baseline is all tests passing.
Currently, this is not the case. With this environment:
- SQL Server 2017 (on Linux)
- MySQL 5.5
- PostgreSQL 9.5/PostGIS 2.4
We have the following failures:
SQL Server:
!!!FAILURES!!! Test Results: Run: 274 Failures: 4 Errors: 0 1) test: SqlServerFdoApplySchemaTest.TestSchema (F) line: 1663 Common\UnitTestUtil.cpp "Output file SQLServerSpatial_8759_apply_schema_test6_LPhF.xml differs from expected output file SQLServerSpatial_8759_apply_schema_test6_master.txt" 2) test: SqlServerFdoApplySchemaTest.TestOverrideErrors (F) line: 1663 Common\UnitTestUtil.cpp "Output file SQLServerSpatial_8759_SQLServerSpatial_8759_apply_schema_overrides_err1SP.txt differs from expected output file apply_schema_overrides_err1SP_master.txt" 3) test: SqlServerFdoApplySchemaTest.TestNoMeta (F) line: 1663 Common\UnitTestUtil.cpp "Output file SQLServerSpatial_8759_SQLServerSpatial_8759_apply_no_meta_err2.txt differs from expected output file apply_no_meta_err2_master.txt" 4) test: SqlServerSchemaMgrTests.testConfigError (F) line: 2051 Common\SchemaMgrTests.cpp "pMessage && expectedMessage.ICompare(pMessage) == 0"
PostgreSQL:
!!!FAILURES!!! Test Results: Run: 131 Failures: 4 Errors: 0 1) test: PostGisFdoSpatialContextTest.testAxes (F) line: 190 PostGis\PostGisFdoSpatialContextTest.cpp "wrong part of WKT removed, see log" 2) test: PostGisSchemaMgrTests.testGenDefault (F) line: 1663 Common\UnitTestUtil.cpp "Output file PostGIS_8391_gen_default1.xml differs from expected output file PostGIS_8391_gen_default1_PostGIS_master.txt" 3) test: PostGisFdoApplySchemaTest.TestSchema (F) line: 1663 Common\UnitTestUtil.cpp "Output file PostGIS_8391_apply_schema_test6_LPhF.xml differs from expected output file PostGIS_8391_apply_schema_test6_master.txt" 4) test: PostGisFdoApplySchemaTest.TestNoMeta (F) line: 1663 Common\UnitTestUtil.cpp "Output file PostGIS_8391_apply_no_meta_test1.xml differs from expected output file PostGIS_8391_apply_no_meta_test1_master.xml"
MySQL:
!!!FAILURES!!! Test Results: Run: 244 Failures: 2 Errors: 1 1) test: MySqlFdoApplySchemaTest.TestSchema (F) line: 1223 Common\UnitTestUtil.cpp "RDBMS: Duplicate entry 'aCxdATA-Acad' for key 'f_classdef_schnm_idx' " 2) test: MySqlFdoApplySchemaTest.TestOverrideErrors (F) line: 1663 Common\UnitTestUtil.cpp "Output file MySql_10680_MySql_10680_apply_schema_overrides_err1.txt differs from expected output file apply_schema_overrides_err1_master.txt" 3) test: MySqlReaderTest.TestExceptionalCase (E) "caught unknown exception"
Most of these failures can be fixed by:
- General: Removing whitespace around certain master text files that are not present in the generated result
- General: Adding source file/line number to the
<error>
element of toapply_schema_test6_master.txt
- MySQL: Un-expected exception due to running a SQL query using a table name in incorrect case.
Note:
See TracTickets
for help on using tickets.