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

Copy as SQL Insert with 'null' string produces NULL instead #3275

Open
sjharrison opened this issue Apr 18, 2024 · 1 comment
Open

Copy as SQL Insert with 'null' string produces NULL instead #3275

sjharrison opened this issue Apr 18, 2024 · 1 comment

Comments

@sjharrison
Copy link

Please answer the questions below, it helps us to keep track of the issue. Please do not ignore it or your issue will be closed.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0):
    Postgresql 15.4

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81):
    5.9.6 (546)

  3. The steps to reproduce this issue:

With a non-nullable jsonb column, insert a STRING of 'null'
Query the row, copy as SQL Insert, and it will be trying to insert a null value instead of a string 'null'

Noted: If the bug is related to data, please attach an example SQL data.

@huyphams
Copy link
Contributor

huyphams commented Apr 24, 2024

So the jsonb accepts the "null" as string? let me check it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants