UnitTests on MySQL 5.1.22-rc-community - Run: 228 Failures: 43 Errors: 20

[based]

Test Results with MySQL 5.1.22-rc-community:

Context:

OS: Windows XP SP2. At the same time uploading a schema and data in the MySQL database

(.\ upload_schema.sql).

To get the UnitTest working, I copied and renamed the libMySQL.dll to the mysql unit test directory.

Run: 228 Failures: 43 Errors: 20

1) test: MySqlFdoApplySchemaTest.TestSchema (F) line: 1778 .\Common\FdoApplySch maTest.cpp

"pMessage && wcscmp( pMessage, L"MetaClass schema F_MetaClass is read-only; ca

not modify it ") == 0"

2) test: MySqlFdoApplySchemaTest.TestOverrides (F) line: 1187 .\Common\UnitTest til.cpp

"RDBMS: Invalid default value for 'featid' ... Schema ForeignBased has errors;

cannot apply it "

3) test: MySqlFdoApplySchemaTest.TestOverrideErrors (F) line: 1568 .\Common\Uni TestUtil.cpp

"Output file MySql_17556_MySql_17556_apply_schema_overrides_err1.txt differs f

om expected output file apply_schema_overrides_err1_master.txt"

4) test: MySqlFdoApplySchemaTest.TestLT (F) line: 1187 .\Common\UnitTestUtil.cp

"RDBMS: Data truncation error."

5) test: MySqlFdoApplySchemaTest.TestConfigDoc (F) line: 1187 .\Common\UnitTest til.cpp

"RDBMS: Data truncation error. ... Schema Acad has errors; cannot apply it "

6) test: MySqlFdoCapabilityTest.Connection (F) line: 50 .\Src\TestCommonMiscUti .cpp

"RDBMS: Data truncation error. [RDBMS: Data truncation error.]"

7) test: MySqlFdoConnectTest.query (F) line: 50 .\Src\TestCommonMiscUtil.cpp

"RDBMS: Data truncation error."

8) test: MySqlFdoDeleteTest.FeatureDelete (F) line: 1187 .\Common\UnitTestUtil. pp

"RDBMS: Data truncation error."

9) test: MySqlFdoImportExportTest.Test1 (F) line: 1568 .\Common\UnitTestUtil.cp

"Output file MySql_17556_impexp_err1.txt differs from expected output file imp

xp_err1_master.txt"

10) test: MySqlFdoImportExportTest.Test5_6_7 (F) line: 1568 .\Common\UnitTestUt l.cpp

"Output file MySql_17556_impexp_err7.txt differs from expected output file imp

xp_err7_master.txt"

11) test: MySqlFdoInsertTest.insert (F) line: 50 .\Src\TestCommonMiscUtil.cpp

"RDBMS: Data truncation error."

12) test: MySqlFdoInsertTest.insertEmptyProps (F) line: 50 .\Src\TestCommonMisc til.cpp

"RDBMS: Data truncation error."

13) test: MySqlFdoInsertTest.insert3 (F) line: 1187 .\Common\UnitTestUtil.cpp

"RDBMS: Data truncation error."

14) test: MySqlFdoInsertTest.insertBoundary (F) line: 1187 .\Common\UnitTestUti .cpp

"RDBMS: Data truncation error."

15) test: MySqlFdoInsertTest.insertDate (F) line: 1187 .\Common\UnitTestUtil.cp

"RDBMS: Data truncation error."

16) test: MySqlFdoInsertTest.smartPointerInsert (F) line: 50 .\Src\TestCommonMi cUtil.cpp

"RDBMS: Data truncation error."

17) test: MySqlFdoInsertTest.insertFlushTest (F) line: 50 .\Src\TestCommonMiscU il.cpp

"RDBMS: Data truncation error."

18) test: MySqlFdoInsertTest.insertAutoGen (F) line: 50 .\Src\TestCommonMiscUti .cpp

"RDBMS: Data truncation error. [RDBMS: Data truncation error.]"

19) test: MySqlFdoInsertTest.insertNonExistProp (F) line: 1954 .\Common\FdoInse tTest.cpp

"wcsncmp(ex->GetExceptionMessage(), L"Property 'GEOMETRY' not found", 29) == 0

20) test: MySqlFdoMultiThreadTest.QueryTest (F) line: 50 .\Src\TestCommonMiscUt l.cpp

"RDBMS: Data truncation error."

21) test: MySqlFdoMultiThreadTest.InsertTest (F) line: 50 .\Src\TestCommonMiscU il.cpp

"RDBMS: Data truncation error."

22) test: MySqlFdoMultiThreadTest.CombinationTest (F) line: 50 .\Src\TestCommon iscUtil.cpp

"RDBMS: Data truncation error."

23) test: MySqlFdoSchemaRollbackTest.Test_nnyn (F) line: 1187 .\Common\UnitTest til.cpp

"RDBMS: Data truncation error. ... Schema Acad has errors; cannot apply it "

24) test: MySqlFdoSchemaTest.Test_Defect802102 (F) line: 1187 .\Common\UnitTest til.cpp

"Unable to load the FDO Provider: Le module spÚcifiÚ est introuvable. "

25) test: MySqlFdoSelectTest.non_feature_subset_query (F) line: 50 .\Src\TestCo monMiscUtil.cpp

"RDBMS: Data truncation error. [RDBMS: Data truncation error.]"

26) test: MySqlFdoSelectTest.feature_subset_query (F) line: 50 .\Src\TestCommon iscUtil.cpp

"RDBMS: Data truncation error."

27) test: MySqlFdoSelectTest.feature_query (F) line: 50 .\Src\TestCommonMiscUti .cpp

"RDBMS: Data truncation error."

28) test: MySqlFdoSelectTest.non_feature_query (F) line: 50 .\Src\TestCommonMis Util.cpp

"RDBMS: Data truncation error. [RDBMS: Data truncation error.]"

29) test: MySqlFdoSelectTest.spatial_query (F) line: 50 .\Src\TestCommonMiscUti .cpp

"RDBMS: Data truncation error."

30) test: MySqlFdoSelectTest.spatial_query_defect792377 (E)

"caught unknown exception"

31) test: MySqlFdoSelectTest.spatial_query_defect880310 (E)

"caught unknown exception"

32) test: MySqlFdoSelectTest.feature_object_query (F) line: 50 .\Src\TestCommon iscUtil.cpp

"RDBMS: Data truncation error."

33) test: MySqlFdoSelectTest.feature_select_obj_distinct (F) line: 50 .\Src\Tes CommonMiscUtil.cpp

"RDBMS: Data truncation error. [RDBMS: Data truncation error.] [RDBMS: Data tr

ncation error.]"

34) test: MySqlFdoSelectTest.feature_geom_query (F) line: 50 .\Src\TestCommonMi cUtil.cpp

"RDBMS: Data truncation error."

35) test: MySqlFdoSelectTest.concurrent_select (F) line: 50 .\Src\TestCommonMis Util.cpp

"RDBMS: Data truncation error. [RDBMS: Data truncation error.]"

36) test: MySqlFdoSelectTest._secondComputedIdTest (F) line: 50 .\Src\TestCommo MiscUtil.cpp

"RDBMS: Data truncation error."

37) test: MySqlFdoUpdateTest.Update (F) line: 50 .\Src\TestCommonMiscUtil.cpp

"RDBMS: Data truncation error."

38) test: MySqlFdoUpdateTest.UpdateAttributesOnly (F) line: 50 .\Src\TestCommon iscUtil.cpp

"RDBMS: Data truncation error."

39) test: MySqlFdoUpdateTest.UpdateObjectProperty (F) line: 50 .\Src\TestCommon iscUtil.cpp

"RDBMS: Data truncation error."

40) test: MySqlFdoUpdateTest.FdoUpdateTestTypes (F) line: 50 .\Src\TestCommonMi cUtil.cpp

"RDBMS: Data truncation error."

41) test: MySqlFdoUpdateTest.UpdateMultiIdFeatureClass (F) line: 1187 .\Common\ nitTestUtil.cpp

"RDBMS: Data truncation error. ... RDBMS: Data truncation error."

42) test: MySqlFdoUpdateTest.UpdateNlsIdFeatureClass (F) line: 1187 .\Common\Un tTestUtil.cpp

"RDBMS: Data truncation error. ... RDBMS: Data truncation error."

43) test: MySqlFdoUpdateTest.testForeignDataStore (F) line: 1187 .\Common\UnitT stUtil.cpp

"RDBMS: Data truncation error. ... RDBMS: Data truncation error."

44) test: MySqlSchemaMgrTests.testGenDefault (F) line: 1187 .\Common\UnitTestUt l.cpp

"RDBMS: Data truncation error. ... RDBMS: Data truncation error."

45) test: MySqlSchemaMgrTests.testGenKeys (F) line: 1187 .\Common\UnitTestUtil. pp

"RDBMS: Data truncation error. ... RDBMS: Data truncation error."

46) test: MySqlFdoAdvancedSelectTest.compIdentFilterTest (E)

"setUp() failed"

47) test: MySqlFdoAdvancedSelectTest.compIdentPropertyTest (E)

"setUp() failed"

48) test: MySqlFdoAdvancedSelectTest.orderByTest (E)

"setUp() failed"

49) test: MySqlFdoAdvancedSelectTest.groupByTest (E)

"setUp() failed"

50) test: MySqlFdoAdvancedSelectTest.functionTest (E)

"setUp() failed"

51) test: MySqlFdoAdvancedSelectTest.selectDistinctTest (E)

"setUp() failed"

52) test: MySqlFdoAdvancedSelectTest.TestDefect779194 (E)

"setUp() failed"

53) test: MySqlFdoAdvancedSelectTest.TestDefect785616 (E)

"setUp() failed"

54) test: MySqlFdoAdvancedSelectTest.getDataTypeTest (E)

"setUp() failed"

55) test: MySqlFdoAdvancedSelectTest.groupByorderByTest (E)

"setUp() failed"

56) test: MySqlFdoAdvancedSelectTest.checkDataReaderContentOnSelAggRequestWithA grFunction (E)

"setUp() failed"

57) test: MySqlFdoAdvancedSelectTest.checkDataReaderContentOnSelAggRequestWithN mCharFunction (E)

"setUp() failed"

58) test: MySqlFdoAdvancedSelectTest.checkFeatureReaderContentOnSelRequestWithA grFunction (E)

"setUp() failed"

59) test: MySqlFdoAdvancedSelectTest.checkFeatureReaderContentOnSelRequestWithN mCharFunction (E)

"setUp() failed"

60) test: MySqlFdoAdvancedSelectTest.TestMaxBoolProperty (E)

"setUp() failed"

61) test: MySqlFdoAdvancedSelectTest.TestUpperDateProperty (E)

"setUp() failed"

62) test: MySqlFdoAdvancedSelectTest.TestCeillInt64Property (E)

"setUp() failed"

63) test: MySqlFdoAdvancedSelectTest.TestLowerOnStringProperty (E)

"setUp() failed"

[based]

I noticed that the schema are named with a windows username. One of the schema has unwanted character at the end : fdo_chandesris_no_metadata