On Wed, 29 Jul 2020 at 15:40, Julien Rouhaud <rjuju...@gmail.com> wrote:
> On Wed, Jul 29, 2020 at 2:42 PM Fujii Masao <masao.fu...@oss.nttdata.com> > wrote: > > > > > > Or, we should extend the existing query normalization to handle also DDL? > > +1, introducing DDL normalization seems like a better way to go in the > long run. Defining what should and shouldn't be normalized can be > tricky though. > In principle, the only thing that really needs to be normalised is SAVEPOINT/CURSOR names which are essentially random strings which have no effect on the result. Most other stuff is material to the query. That said, I think "aggregate by tag" has value all by itself. Being able to collapse all CREATE TABLES into a single line can be useful in some situations. Ideally the results of FETCH "cursor" should be combined with the DECLARE, but I really don't know how to go about that. Have a nice day, -- Martijn van Oosterhout <klep...@gmail.com> http://svana.org/kleptog/
