Problem with Export/Import of Views with function(s) in the GROUP BY Section

We are having problem with importing of exported views with functions in the GROUP BY section. They get transferred but not compiled, and we have to manually correct it. We are running V8.03 and V8.04 and problem occurs in either of these versions. Here is the example:

CREATE OR REPLACE VIEW a_view
  ( a_col, b_col, c_col, d_col, a_sum) AS   SELECT a_col, b_col, a_fn (x_col) c_col, b_fn (x_col,y_col) d_col,

        SUM(amount) a_sum FROM a_table
GROUP BY a_col, b_col, a_fn (x_col), b_fn (x_col,y_col) ;

Any hints? Thanks in advance.

Adam Tadj
adamt_at_hsltd.com

Opinions expressed or questions asked are mine, not of my employer. Received on Mon Jun 15 1998 - 00:00:00 CEST