12502166363
74%
BABEL_5_X_DEV: 77%

Ran 26 Dec 2024 09:50AM UTC

Jobs 1

Files 114

Run time 1min

Badge

Embed ▾

Committed 26 Dec 2024 09:22AM UTC coverage: 73.8%. Remained the same

Build # 12502166363

Build Type

push

github

Committed by

web-flow

Commit Message

Fix sys.columnproperty ordinal (#3316)

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

43167 of 58492 relevant lines covered (73.8%)

146063.79 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	12502166363.1	26 Dec 2024 09:50AM UTC	114	73.8	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 12502166363
74%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12502166363

babelfish-for-postgresql / babelfish_extensions / 12502166363 74% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12502166363

babelfish-for-postgresql / babelfish_extensions / 12502166363
74%
BABEL_5_X_DEV: 77%

README BADGES
x