Wrong result in Machine SCADA Expert SQL query.

[Anonymous user]

Hello

I am making a SQL query to a MySQL database. 

When I run the query in MySQL, I get the right result. 

When I send the SQL statement from Machine SCADA Expert, the result is not right. 
It is like the lase WHERE clause is ignored. 

This is the Query: 

SELECT SUM(Minute_In_State) From
   (SELECT
   Time_Stamp,
   State,
   TIMESTAMPDIFF(SECOND, LAG(Time_Stamp) OVER(ORDER BY Time_Stamp), Time_Stamp)
   AS Minute_In_State
   FROM db.xyz_1_state
   ORDER BY Time_Stamp) AS T
Where State = 1;

Any suggestion why the result is different, when sent from Machine SCADA Expert?

[Anonymous user]

I found the connection string from Machine SCADA Expert, where the last WHERE clause is missing:

Connection String:'26F9D15629', Last command: 'Cursor Open SQL: 'SELECT SUM(Second_In_State) From
(SELECT
Time_Stamp,
State,
TIMESTAMPDIFF(SECOND, LAG(Time_Stamp) OVER(ORDER BY Time_Stamp), Time_Stamp)
AS Second_In_State
FROM db.xyz_1_state
ORDER BY Time_Stamp) AS T, Total Connections: 1]

So the problem must be in Machine SCADA Expert. 

[Anonymous user · Accepted solution]

The input field "SQL statement" is limited to 10 lines, the rest of the statement is not saved. 

The solution is to make the SQL statement in one line. 

This makes it way more difficult to oversee the statement, but it works.