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

Incorrect script is shown when editing composite columns with disabled "Show complex columns structure" #13351

Closed
Matvey16 opened this issue Jul 28, 2021 · 2 comments

Comments

@Matvey16
Copy link
Member

System information:

  • Operating system (distribution) and version Win 10
  • DBeaver version 21.1.4

Connection specification:

  • Database name and version PostgreSQL

Steps to reproduce, if exist:

--Create a composite data type
CREATE TYPE zzz AS (
	id int4,
	"name" text);

--create a table with that data type
CREATE TABLE aaa (
	id numeric NULL,
	composite zzz NULL,
	CONSTRAINT aaa_pk PRIMARY KEY (id)
);

--fill the data
INSERT INTO aaa (id,composite)
	VALUES (1, (20, NULL)),
	(2, (30, 'John')),
	(3, (40, NULL)),
	(4, (50, 'Jack'));
  1. Change some data in a composite column and look at the generated script (shown query has incorrect syntax and can't be executed in SQL editor)
  2. Persist changes and look at the query executed in query manager (valid query is executed)

ApbqPO5uNL

dbeaver_BjA5EDovEO

dbeaver_xjrBvwaLJG

@Matvey16
Copy link
Member Author

Matvey16 commented Jul 28, 2021

Can be related to #13102

@ShadelessFox ShadelessFox self-assigned this Jul 28, 2021
@tati-kru tati-kru added the sp:2 label Sep 20, 2021
ShadelessFox added a commit that referenced this issue Sep 24, 2021
serge-rider added a commit that referenced this issue Sep 27, 2021
@Matvey16 Matvey16 self-assigned this Sep 27, 2021
@Matvey16
Copy link
Member Author

Verified

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

No branches or pull requests

3 participants