Changes between Version 92 and Version 93 of DatabaseBasedAnalysis

Timestamp:

08/07/18 19:28:05 (6 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis

@@ -432 +432 @@
    @Dist    := @Norm*0.0117193246260285378 AS Dist,
    PI()*Width*Length*0.0117193246260285378*0.0117193246260285378 AS Area,
-   @LX      := TRUNCATE((CosDelta*@DY - SinDelta*@DX)/@Norm, 6),
-   @LY      := TRUNCATE((CosDelta*@DX + SinDelta*@DY)/@Norm, 6),
+   @LX      := LEAST(GREATEST((CosDelta*@DY - SinDelta*@DX)/@Norm, -1), 1),
+   @LY      := LEAST(GREATEST((CosDelta*@DX + SinDelta*@DY)/@Norm, -1), 1),
    @Alpha   := ASIN(@LX) AS Alpha,
    @Sign    := SIGN(@LY) AS Sign,
@@ -527 +527 @@
             @Norm    := SQRT(@DX*@DX + @DY*@DY),
             @Dist    := @Norm*0.0117193246260285378 AS Dist,
-            @LX      := TRUNCATE((CosDelta*@DY - SinDelta*@DX)/@Norm, 6),
-            @LY      := TRUNCATE((CosDelta*@DX + SinDelta*@DY)/@Norm, 6),
+            @LX      := LEAST(GREATEST((CosDelta*@DY - SinDelta*@DX)/@Norm, -1), 1),
+            @LY      := LEAST(GREATEST((CosDelta*@DX + SinDelta*@DY)/@Norm, -1), 1),
             @Alpha   := ASIN(@LX) AS Alpha,
             @Sign    := SIGN(@LY) AS Sign,
@@ -658 +658 @@
                             SELECT -- 3
                                 Weight, M3Long, SlopeLong, Leakage1, WdivL, Norm,
-                                TRUNCATE((CosDelta*DY - SinDelta*DX)/Norm, 6) AS LX,
-                                TRUNCATE((CosDelta*DX + SinDelta*DY)/Norm, 6) AS LY
+                                LEAST(GREATEST((CosDelta*DY - SinDelta*DX)/Norm, -1), 1) AS LX,
+                                LEAST(GREATEST((CosDelta*DX + SinDelta*DY)/Norm, -1), 1) AS LY
                             FROM 
                             ( -- Table2
@@ -898 +898 @@
                             SELECT -- 3
                                 Weight, M3Long, SlopeLong, Leakage1, WdivL, Norm,
-                                TRUNCATE((CosDelta*DY - SinDelta*DX)/Norm, 6) AS LX,
-                                TRUNCATE((CosDelta*DX + SinDelta*DY)/Norm, 6) AS LY
+                                LEAST(GREATEST((CosDelta*DY - SinDelta*DX)/Norm, -1), 1) AS LX,
+                                LEAST(GREATEST((CosDelta*DX + SinDelta*DY)/Norm, -1), 1) AS LY
                             FROM
                                 Table2