SQLite / PostgreSQL behavior difference related to the archivedDate field

[AChep]

Prerequisites

• I have searched the existing Closed AND Open Issues AND Discussions
• I have searched and read the documentation

Vaultwarden Support String

Vaultwarden Build Version

1.37.1

Deployment method

Official Container Image

Custom deployment method

No response

Reverse Proxy

Host/Server Operating System

Linux

Operating System Version

No response

Clients

CLI

Client Version

Steps To Reproduce

Updating an archived cipher through PUT /api/ciphers/{id} with:

{
  "archivedDate": null,
  ...
}

Expected Result

The official Bitwarden server does unarchvie the item in that case, so I assume that is the intended behavior.

Actual Result

Appears to unarchive the cipher on SQLite but on PostgreSQL, the same request leaves the cipher archived.

Logs

Screenshots or Videos

No response

Additional Context

No response

[AChep]

Causes AChep/keyguard-app#1526

[xiaozhubin]

android app, browser Extensions cannot show any password. And android app guide me to import password from website. Is it caused by this issues? I do have upload several attachment. It behavior normal two days ago.
And the web client can use normal.