Inconsequent behaviour of GUI during inserting a row in a table with default values of columns and/or for date columns
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 9h
- Merged PRs (30d)
- 189
Description
#### System information:
- Operating system (distribution) and version
Linux Mint, CentOS
- DBeaver version
The last, 21.1.3
- Additional extensions
No
#### Connection specification:
- Database name and version
Oracle 10, Postgres 13
- Driver name
Standard maven artifacts from collection of DBeaver
- Do you use tunnels or proxies (SSH, SOCKS, etc)?
No
#### Describe the problem you're observing:
There is a table with date column (affected both date, time, timestamp) and with default value both in Oracle and Postgres like table from https://github.com/dbeaver/dbeaver/issues/13360.
1. If we are inserting into table through GUI, after inserting there is no default value in corresponding cell, need a refreshing of data grid.
2. If we are inserting a date/timestamp/time data, SQL `insert` use citation from corresponding cell, no translation of string format like during output
#### Steps to reproduce, if exist:
1. Create table like in https://github.com/dbeaver/dbeaver/issues/13360 in Postgres and something similar in Oracle
2. Try to use GUI for incomplete insert with no data in some corresponding cells. The end for error No 1.
3. Try to set international YYYY-MM-DD format for date output to data grid or some other format, different from native format of the DB.
4. Try to insert a date value in format of output. It will be an error, but the DB (Oracle or Postgres) will require date string in format of DB, not in format of cell or data grid of GUI of DBeaver.
#### Include any warning/errors/backtraces from the logs
Contributor guide
Assessment
This issue has not been assessed yet.