From: Neil M. <nm...@zi...> - 2000-11-26 20:55:14
|
On Tue, Nov 14, 2000 at 07:37:41AM +0100, Frank Schlottmann-Goedde wrote: > Neil McCalden schrieb: > > > I have also installed the kit on Solaris using your gtcs.gdb > > with a updated so_ltcs.gdb and the vector_12hour test passes on a > > classic server. Two tests reported a failure with your updated > > output but passed if the original results were used, which is also what > > v4 produces with the same query. > > Could you please tell me which tests failed, and if possible > provide the diffs for that failure. > Frank, Sorry for the late reply. The tests are c_isql_join_3 and c_isql_join4 the diff output from TCS is below. While I am curious to find out if the order is architecture dependent, I think solution is to add an order by clause to the queries to ensure consistency. Running global test C_SQL_JOIN_2 ... passed Running global test C_SQL_JOIN_3 ... *** failed **** Test C_SQL_JOIN_3 failed on 25-NOV-2000: initialized by FSG on 16-OCT-2000 with boilerplate QA_BP ------------------- 5 a 5 > Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 6 d 7 < Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 13 a 13 > Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ 14 d 15 < Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ 29 a 29 > Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 30 d 31 < Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 37 a 37 > Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ 38 d 39 < Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ 47,48 c 47,48 < --------------------------------------------- > ++++++++++++++++++++++++++++++++++++++++++++++++++ 54 a 54 > Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 55 d 56 < Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 62 a 62 > Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ 63 d 64 < Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------- Running global test C_SQL_JOIN_4 ... *** failed **** Test C_SQL_JOIN_4 failed on 25-NOV-2000: initialized by FSG on 16-OCT-2000 with boilerplate QA_BP ------------------- 5 a 5 > Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 6 d 7 < Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 13 a 13 > Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ 14 d 15 < Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ 29 a 29 > Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 30 d 31 < Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 37 a 37 > Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ 38 d 39 < Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ 47,48 c 47,48 < --------------------------------------------- > ++++++++++++++++++++++++++++++++++++++++++++++++++ 54 a 54 > Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 55 d 56 < Cubs Chicago Illinois ++++++++++++++++++++++++++++++++++++++++++++++++++ 62 a 62 > Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ 63 d 64 < Mets New York New York ++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------- Running global test C_SQL_JOIN_5 ... passed Running global test C_SQL_JOIN_6 ... passed -- Neil McCalden @home nm...@zi... |