Skip to content

round-trip error in underscore/titlecasing column names with number after underscore #2073

@unhammer

Description

@unhammer

https://github.com/unhammer/ihp-back-button-repro/tree/noRoundtripTitleScore
does
ALTER TABLE users ADD COLUMN foo_25bar TEXT DEFAULT null;
which gives
EnhancedSqlError {sqlErrorQuery = "UPDATE users SET id = ?, name = ?, foo_25bar = ? WHERE id = ? RETURNING id, name, foo_25bar", sqlErrorQueryParams = [Plain "id",Escape "test",Plain "foo25_bar",Plain "'97cb49d9-2015-4121-bf55-885ef19dc4f0'"], sqlError = SqlError {sqlState = "42703", sqlExecStatus = FatalError, sqlErrorMsg = "column \"foo25_bar\" does not exist", sqlErrorDetail = "", sqlErrorHint = "Perhaps you meant to reference the column \"users.foo_25bar\"."}}
when trying to save an edit from e.g.
http://localhost:8002/EditUser?userId=97cb49d9-2015-4121-bf55-885ef19dc4f0

Yes I know it's a strange column name :-) but it would be nice if it either 1. worked or 2. was a compilation error.

possibly related:
#1497

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions