null/Queue-North-Website
null
/
Queue-North-Website
1
0
Fork 0
Code Issues 18 Pull Requests Packages Projects Releases Wiki Activity

P1: service_interest || null causes SQL NULL vs empty string inconsistency #9

New Issue
Open
opened 2026-05-13 20:39:37 -05:00 by null · 0 comments
null commented 2026-05-13 20:39:37 -05:00
Owner
Copy Link

Severity: P1 — High

File: server/index.js ~line 314

Problem: sanitized.service_interest || null converts empty string to null, but a whitespace-only string like " " becomes empty string after trim (not null). Behavior is inconsistent.

Impact: Data inconsistency in database — some records have NULL, some have empty string.

Fix: Use consistent null handling — always convert empty/whitespace-only strings to null.

## Severity: P1 — High **File:** server/index.js ~line 314 **Problem:** sanitized.service_interest || null converts empty string to null, but a whitespace-only string like " " becomes empty string after trim (not null). Behavior is inconsistent. **Impact:** Data inconsistency in database — some records have NULL, some have empty string. **Fix:** Use consistent null handling — always convert empty/whitespace-only strings to null.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
dev
main
v0.2.0
v0.1.1
v0.1.0
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: null/Queue-North-Website#9
No description provided.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?