tpg issueshttps://gitlab.inf.unibz.it/peter-moser/tpg/-/issues2017-09-17T21:00:13+02:00https://gitlab.inf.unibz.it/peter-moser/tpg/-/issues/105GROUP BY PERIOD: Does not support GROUPING SETS2017-09-17T21:00:13+02:00Moser PeterGROUP BY PERIOD: Does not support GROUPING SETS```
A=# select a, count(*) from test group by period with (ts,te) a;
a | count
---+------- ...```
A=# select a, count(*) from test group by period with (ts,te) a;
a | count
---+-------
a | 1
j | 1
a | 1
(3 rows)
A=# select a, count(*) from test group by period with (ts,te) cube(a);
ERROR: column unnamed_normalize_2.cube does not exist
```Future workhttps://gitlab.inf.unibz.it/peter-moser/tpg/-/issues/84TEMPORAL JOINS: "schema.relation.column" does not work for boundaries2017-09-17T21:00:13+02:00Moser PeterTEMPORAL JOINS: "schema.relation.column" does not work for boundaries*Created by: Piiit*
```
A=# select * from (e as e(x,y,t)
full join period with (e.t,public.f.tf) f on x=a and y=b) r ;
ERROR: i...*Created by: Piiit*
```
A=# select * from (e as e(x,y,t)
full join period with (e.t,public.f.tf) f on x=a and y=b) r ;
ERROR: invalid reference to FROM-clause entry for table "f"
LINE 2: full join period with (e.t,public.f.tf) f on x=a and y=b) r ...
^
HINT: There is an entry for table "f", but it cannot be referenced from this part of the query.
```
Belongs to #55.Future workhttps://gitlab.inf.unibz.it/peter-moser/tpg/-/issues/82TEMPORAL JOINS: Relation does not exists error, talks about a WITH item -> hi...2017-09-17T21:00:13+02:00Moser PeterTEMPORAL JOINS: Relation does not exists error, talks about a WITH item -> hide internals*Created by: Piiit*
We need to hide internal rewrites, to not confuse the user. From the input there is no WITH clause at all!
```
A=# select * from (r ...*Created by: Piiit*
We need to hide internal rewrites, to not confuse the user. From the input there is no WITH clause at all!
```
A=# select * from (r
join period with (ts,te,ts,te) s on r.b=d) r ;
ERROR: relation "r" does not exist
LINE 1: select * from (r
^
DETAIL: There is a WITH item named "r", but it cannot be referenced from this part of the query.
HINT: Use WITH RECURSIVE, or re-order the WITH items to remove forward references.
```
Belongs to #55Future workhttps://gitlab.inf.unibz.it/peter-moser/tpg/-/issues/73Wrong error hints for internal-use-only columns2017-09-17T21:00:13+02:00Moser PeterWrong error hints for internal-use-only columns*Created by: Piiit*
```
A=# select * from ((select * from rt) rt(rn, t) align rt s on true with (rn_1,a,p1,h)) x;
ERROR: column rt.rn_1 does not exist
LINE 1: ...ect * fr...*Created by: Piiit*
```
A=# select * from ((select * from rt) rt(rn, t) align rt s on true with (rn_1,a,p1,h)) x;
ERROR: column rt.rn_1 does not exist
LINE 1: ...ect * from rt) rt(rn, t) align rt s on true with (rn_1,a,p1,...
^
HINT: Perhaps you meant to reference the column "rt"."rn_0".
```
rn_0 should not be visible here!First full versionhttps://gitlab.inf.unibz.it/peter-moser/tpg/-/issues/39Group by and distinct period: Temporal bounds must be FQN, not only column names2016-09-08T10:54:33+02:00Moser PeterGroup by and distinct period: Temporal bounds must be FQN, not only column names*Created by: Piiit*
We need this to point to the correct column when multiple table references are used.
For instance:
```
select a, count(*) from e1, e2 group by period (e2.t) a;
```
Is this really the case? Needs to be checked!*Created by: Piiit*
We need this to point to the correct column when multiple table references are used.
For instance:
```
select a, count(*) from e1, e2 group by period (e2.t) a;
```
Is this really the case? Needs to be checked!Future workhttps://gitlab.inf.unibz.it/peter-moser/tpg/-/issues/36GROUP BY PERIOD: Hardcoded alias if self-normalization is used2016-09-08T10:53:40+02:00Moser PeterGROUP BY PERIOD: Hardcoded alias if self-normalization is used*Created by: Piiit*
`N(r;r)` for example needs an explicit alias for the right argument.
Code:
```
/* PEMOSER FIXME Hardcoded alias! */
((RangeVar *) normalizer->rarg)->alias = makeAlias("r_periodgroupby", NIL);
```
`r_periodg...*Created by: Piiit*
`N(r;r)` for example needs an explicit alias for the right argument.
Code:
```
/* PEMOSER FIXME Hardcoded alias! */
((RangeVar *) normalizer->rarg)->alias = makeAlias("r_periodgroupby", NIL);
```
`r_periodgroupby` must be chosen at runtime, it must be an unique alias name.Future work