public inbox for [email protected]  

help / color / mirror / Atom feed

From: ProfiVPS Support <[email protected]>
To: [email protected]
Subject: Strange update behaviour
Date: Thu, 22 Jun 2023 23:49:15 +0200
Message-ID: <[email protected]> (raw)

Hi Gentz,

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

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

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

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

  And I constantly face a result when the device_state is updated, 
changets and updatets are populated, but the device_alertstate remains 
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ás

---
Olcsó Virtuális szerver:
http://www.ProfiVPS.hu

Támogatás: [email protected]

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Strange update behaviour
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox