From c071aca5c5c16d56aafe38ace2b2c158e1b875fc Mon Sep 17 00:00:00 2001
From: Daniel Hader <dhader96@gmail.com>
Date: Fri, 5 Jun 2026 19:29:40 -0500
Subject: server text sanitation, username/email filters, and code length
 measurement

---
 src/database/sql/fetch_display_submissions.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'src/database/sql/fetch_display_submissions.sql')

diff --git a/src/database/sql/fetch_display_submissions.sql b/src/database/sql/fetch_display_submissions.sql
index 5e836b3..aaceaca 100644
--- a/src/database/sql/fetch_display_submissions.sql
+++ b/src/database/sql/fetch_display_submissions.sql
@@ -3,8 +3,9 @@ submission.id AS id,
 user.username AS username,
 submission.language AS language,
 submission.details AS details,
-submission.code AS code
+submission.code AS code,
+submission.code_length as code_length
 FROM submission JOIN user
 ON user.id = submission.user_id
 WHERE submission.problem_id = ?1
-ORDER BY length(submission.code);
+ORDER BY submission.code_length;
-- 
cgit v1.2.3

