apache / apache/grails-core

The use of interval types in PostgreSQL

Open
#13,056 0 comments 2 reactions 0 assignees View on GitHub
Dominant language
Groovy
Stars
2.9k
Forks
975
Avg merge
1d 22h
Merged PRs (30d)
92

Description

### Issue description
```
create table user_device_time
(
id bigserial
primary key,
version bigint,
device_id bigint,
user_id bigint,
user_type smallint,
time_range int8range
);
```
This is the table I created in PostgreSQL.
But the int8Range type doesn't map correctly during use, and I wonder if there is any processing in grails for this data type,Or is there any other way to deal with it

Contributor guide

Open the contributing guide

Research direction

Start with the PostgreSQL schema in the issue and reproduce how the int8range column is handled in Grails. Trace the existing PostgreSQL type mapping and determine whether int8range is supported; done means the type maps correctly or the supported way to handle it is documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
groovy, postgresql
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.