Hi everyone, am I the only one that have the feeli...
# suiteql
l
Hi everyone, am I the only one that have the feeling that the database engine has changed in the last two/three weeks ? I have queries that previously worked fine in production (for 3 years already!) and suddenly return no results or errors. The similarity between these queries is a comparaison with a null value. Where I previously had something like «  custsomething = null » in my where conditions, I now have to use « custsomething is null ». I am not saying that the = null was the correct way to do it, but I find it strange that all of a sudden I have so many issues. And they seem to have appeared after the pre-release maintenance. Am I going crazy here ? (Note, I have seen this behavior on multiple accounts, unrelated to each other)
e
Haven't noticed, but do you happen to know if the affected accounts were upgraded to 2024.1?
l
They were not but all of them had the pre-upgrade maintenance
👍 1
n
@Loïc Beaujean we had the same problem. SQL in portlet just stopped working due to maintenance on production account (SB hadn't been updated and was working fine) they fixed in a couple days.
s
I had queries starting to time out after the maintenance update. My pet theory is that they didn't recreate all indexes properly but its just a guess.