NexusDB Pty Ltd

DROP ROUTINE IF EXISTS "BITOR";
CREATE FUNCTION BITOR (N1 INTEGER, N2 INTEGER)
RETURNS INTEGER
BEGIN
  DECLARE nReturnValue,nS,nTemp Integer DEFAULT 0;

  WHILE (N1 > 0 OR N2 > 0) AND nS < 32 DO
    IF MOD(N1,2) <> 0 OR MOD(N2,2) <> 0 THEN 
      SET nTemp = 1;
    ELSE 
      SET nTemp = 0;
    END IF;
    
    SET nReturnValue = nReturnValue + (nTemp * POWER(2,nS));
    SET N1 = N1 / 2;
    SET N2 = N2 / 2;
    SET nS = nS + 1;
  END WHILE;
  RETURN nReturnValue;
END