MIME-Version: 1.0
Date: Thu, 22 Jun 2023 23:49:15 +0200
From: ProfiVPS Support <support@profivps.hu>
To: pgsql-sql@lists.postgresql.org
Subject: Strange update behaviour
User-Agent: Roundcube Webmail/1.4.11
Message-ID: <257ece670da80be9e2d08126aba9c641@profivps.hu>
Organization: ProfiVPS.hu
Content-Type: multipart/alternative;
 boundary="=_d627b4fb29eb398d28edba00f53bd679"
Archived-At: 
 <https://www.postgresql.org/message-id/257ece670da80be9e2d08126aba9c641%40profivps.hu>
Precedence: bulk

--=_d627b4fb29eb398d28edba00f53bd679
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: quoted-printable

Hi Gentz,

   I'm in a dire need of help, because this bug is killing me for weeks=20
now.

   I got a function, and that function has a simple update query in it:

UPDATE app_devices SET device_state =3D p_values[1], device_updateTs =3D=20
NOW(),
device_changets =3D CASE WHEN device_state <> p_values[1] THEN NOW() ELSE=
=20
device_changets END,
device_alertstate =3D CASE WHEN device_state <> p_values[1] THEN 0 ELSE=20
device_alertstate END
WHERE device_id=3Ddev_id;

  The device_alertstate's default value is 200. update and changets are=20
null by default.

  And I constantly face a result when the device_state is updated,=20
changets and updatets are populated, but the device_alertstate remains=20
on the default 200.

   As far as I can tell from the second round and forward it works well.

   I am simply not able to come up with any reasons for this to happen.

Thank you very much in advance!

Bests,

Andr=C3=A1s

---
Olcs=C3=B3 Virtu=C3=A1lis szerver:
http://www.ProfiVPS.hu

T=C3=A1mogat=C3=A1s: Support@ProfiVPS.hu
--=_d627b4fb29eb398d28edba00f53bd679
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset=UTF-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset=
=3DUTF-8" /></head><body style=3D'font-size: 10pt; font-family: Verdana,Gen=
eva,sans-serif'>
<p>Hi Gentz,&nbsp;</p>
<p>&nbsp; I'm in a dire need of help, because this bug is killing me for we=
eks now.&nbsp;</p>
<p>&nbsp; I got a function, and that function has a simple update query in =
it:&nbsp;</p>
<p>UPDATE app_devices SET device_state =3D p_values[1], device_updateTs =3D=
 NOW(),<br />device_changets =3D CASE WHEN device_state &lt;&gt; p_values[1=
] THEN NOW() ELSE device_changets END,<br />device_alertstate =3D CASE WHEN=
 device_state &lt;&gt; p_values[1] THEN 0 ELSE device_alertstate END<br />W=
HERE device_id=3Ddev_id;</p>
<p><br /></p>
<p>&nbsp;The device_alertstate's default value is 200. update and changets =
are null by default.&nbsp;</p>
<p>&nbsp;And I constantly face a result when the device_state is updated, c=
hangets and updatets are populated, but the device_alertstate remains on th=
e default 200.&nbsp;</p>
<p>&nbsp; As far as I can tell from the second round and forward it works w=
ell.&nbsp;</p>
<p>&nbsp; I am simply not able to come up with any reasons for this to happ=
en.&nbsp;</p>
<p><br /></p>
<p>Thank you very much in advance!</p>
<p>Bests,&nbsp;</p>
<p>Andr&aacute;s</p>
<div id=3D"signature">
<div class=3D"pre" style=3D"margin: 0; padding: 0; font-family: monospace">=
---<br />Olcs&oacute; Virtu&aacute;lis szerver:<br /><a href=3D"http://www=
=2EProfiVPS.hu" target=3D"_blank" rel=3D"noopener noreferrer">http://www.Pr=
ofiVPS.hu</a><br /><br />T&aacute;mogat&aacute;s: <a href=3D"mailto:Support=
@ProfiVPS.hu">Support@ProfiVPS.hu</a></div>
</div>
</body></html>

--=_d627b4fb29eb398d28edba00f53bd679--