12502173129
76%
BABEL_5_X_DEV: 77%

Ran 26 Dec 2024 09:48AM UTC

Jobs 1

Files 115

Run time 1min

Badge

Embed ▾

Committed 26 Dec 2024 09:22AM UTC coverage: 74.87% (+0.003%) from 74.867%

Build # 12502173129

Build Type

push

github

Committed by

web-flow

Commit Message

Fix sys.columnproperty ordinal (#3315)

In sys.columnproperty, the query for ordinal was incorrect. We put the order by clause outside `row_number() OVER()` clause which means the row_number() was called before ordering the result leading to random output.

As a fix move ORDER BY clause to inside OVER()

Additional an example to show that `row_number() OVER()` clause is executed before outside `ORDER BY`.
```
babelfish_db=# select a, row_number() over() from (select unnest(ARRAY[99, 1]) as a) order by a;
 a  | row_number 
----+------------
  1 |          2
 99 |          1
(2 rows)

babelfish_db=# select a, row_number() over(order by a) from (select unnest(ARRAY[99, 1]) as a);
 a  | row_number 
----+------------
  1 |          1
 99 |          2
(2 rows)
```

Task: BABEL-5495
Signed-off-by: Tanzeel Khan <tzlkhan@amazon.com>

Run Details

46706 of 62383 relevant lines covered (74.87%)

166533.13 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	12502173129.1	26 Dec 2024 09:48AM UTC	115	74.87	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 12502173129
76%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12502173129

babelfish-for-postgresql / babelfish_extensions / 12502173129 76% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12502173129

babelfish-for-postgresql / babelfish_extensions / 12502173129
76%
BABEL_5_X_DEV: 77%

README BADGES
x