diff options
| author | Daniel Hader <[email protected]> | 2026-06-05 19:29:40 -0500 |
|---|---|---|
| committer | Daniel Hader <[email protected]> | 2026-06-05 19:29:40 -0500 |
| commit | c071aca5c5c16d56aafe38ace2b2c158e1b875fc (patch) | |
| tree | aa947a0f6fa53be3de6fb879aa5c4d96bc087cf1 /src/database/sql/fetch_display_submissions.sql | |
| parent | 3ac68b8b59f150e08731a62026ce3ac825655614 (diff) | |
server text sanitation, username/email filters, and code length measurement
Diffstat (limited to 'src/database/sql/fetch_display_submissions.sql')
| -rw-r--r-- | src/database/sql/fetch_display_submissions.sql | 5 |
1 files changed, 3 insertions, 2 deletions
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; |