-
Notifications
You must be signed in to change notification settings - Fork 8
Closed
Description
currently the config pages fail to insert records if text fields (such as name or description) contain the '@' character.
the resulting output from sqlquery.cgi was:
got request with user: 'root', db: 'daq', '
INSERT INTO configurations (time, name, version, description, author, data)
VALUES ( now(), 'webtest', (select COALESCE(MAX(version)+1,0) FROM configurations WHERE name='webtest'),
' hello this is an information message ..![][]<>?/`~'@'', 'marcus', '{"five":5}'::jsonb)
'
query return: 'ERROR: operator is not unique: unknown @ unknown
LINE 4: ...ello this is an information message ..![][]<>?/`~'@'', 'marc...
^
HINT: Could not choose a best candidate operator. You might need to add explicit type casts.'
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels