Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The "?" character in default field value was replaced with "$1" when using Postgresql database #17989

Closed
gigigimay opened this issue Mar 29, 2023 · 3 comments

Comments

@gigigimay
Copy link

gigigimay commented Mar 29, 2023

Describe the Bug

Directus version: 9.23.4

The "?" character in the default field values are replaced with "$1"

This issue appears to be happening when using Postgresql DB and won't happen on SQLite

To Reproduce

  1. In the data model setting, create a field within any collection with a default value that contains a question mark (?). For example, "bello?"
  2. After creating, click to open the field detail and check its default value

Actual result:
The default value is "bello$1"

Expected result:
The default value should be "bello?"

Hosting Strategy

Self-Hosted (Docker Image)

@rijkvanzanten

This comment was marked as off-topic.

@github-actions

This comment was marked as resolved.

@rijkvanzanten
Copy link
Member

This is a bug in knex. I've opened knex/knex#5626 and we'll track/resolve this over there 👍🏻

@rijkvanzanten rijkvanzanten closed this as not planned Won't fix, can't repro, duplicate, stale Jul 10, 2023
@github-actions github-actions bot locked as resolved and limited conversation to collaborators Feb 1, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
Archived in project
Development

No branches or pull requests

2 participants