12502179127
77%

Ran 26 Dec 2024 09:57AM UTC

Jobs 1

Files 115

Run time 1min

Badge

Embed ▾

Committed 26 Dec 2024 09:23AM UTC coverage: 74.855% (-0.004%) from 74.859%

Build # 12502179127

Build Type

push

github

Committed by

web-flow

Commit Message

Fix sys.columnproperty ordinal (#3314)

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

46569 of 62212 relevant lines covered (74.86%)

165717.32 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
2	73.66	-0.41%	contrib/babelfishpg_tds/src/backend/tds/tdsutils.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	12502179127.1	26 Dec 2024 09:57AM UTC	115	74.86	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 12502179127
77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 12502179127

babelfish-for-postgresql / babelfish_extensions / 12502179127 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 12502179127

babelfish-for-postgresql / babelfish_extensions / 12502179127
77%

README BADGES
x