Skip to content

Commit 525da02

Browse files
LUKASZ104LUKASZ104
authored andcommitted
Partition should not be across column name but a full table set.
1 parent 367958d commit 525da02

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

source/expectations/data_values/ut_cursor_details.tpb

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -201,7 +201,7 @@ create or replace type body ut_cursor_details as
201201
for i in (
202202
select parent_name, access_path, display_path, has_nested_col,
203203
transformed_name, hierarchy_level,
204-
row_number() over (partition by parent_name,transformed_name order by column_position) as new_position, xml_valid_name,
204+
row_number() over (order by column_position) as new_position, xml_valid_name,
205205
column_name, column_type, column_type_name, column_schema,
206206
column_len, column_precision ,column_scale ,is_sql_diffable, is_collection,value(x) col_info
207207
from table(l_result.cursor_columns_info) x

0 commit comments

Comments
 (0)