List:Cluster« Previous MessageNext Message »
From:Ph.D. Joseph E. Sacco Date:October 1 2004 5:33pm
Subject:ps_7ndb test
View as plain text  
System:
* powermac with dual G4 533MHz cpu's, 1Gb RAM, SCSI disks
* YDL-3.0.1 [2.4.25-ben1 kernel]
* gcc-3.2.2
* BK source: up through changeset 1.2032
================================================================
The ps_7ndb test fails on a PPC.  

All but one of the "failures" are not actual failures, but are the
result of ordering differences in the output from select statements run
on big and little endian machines. These are easily corrected by adding
"sort by" clauses to the queries.

There is one case where the results actually differ:

*** 444,450 ****
  limit 1 ';
  execute stmt1 ;
  a     b
! 2     two
  prepare stmt1 from ' select a,b from t1
  limit ? ';
  ERROR 42000: You have an error in your SQL syntax; check the manual
that corresponds to your
MySQL server version for the right syntax to use near '?' at line 2
--- 444,450 ----
  limit 1 ';
  execute stmt1 ;
  a     b
! 3     three
  prepare stmt1 from ' select a,b from t1
  limit ? ';
  ERROR 42000: You have an error in your SQL syntax; check the manual
that correspo

-- 
Joseph E. Sacco, Ph.D. <jsacco[at]earthlink[dot]net>

Thread
ps_7ndb testPh.D. Joseph E. Sacco1 Oct