34
36%

Ran 15 Jan 2015 05:34AM UTC

Jobs 1

Files 16

Run time 9s

Badge

Embed ▾

pending completion

Build # 34

Build Type

Pull #54

travis-ci

Committed by

jasonmp85

Commit Message

Fix multi-shard SELECT to pull only needed columns

Adds a new test to verify that the remote SQL generated during a multi-
shard SELECT contains only columns needed for the local portion of
query execution. Previously, columns referenced by WHERE clauses would
always be pulled because the local portion of execution retained the
WHERE quals from the original query. Now the remote query leaves those
columns empty unless they are referenced by an aggregate, GROUP BY,
ORDER BY, or directly in the target list. To make this new approach
work, the local execution no longer retains WHERE quals: they are
removed entirely before the sequential scan of the temp table.

Pull Request Pull Request #54: Fix multi-shard SELECT to pull only needed columns

Run Details

1901 of 2042 relevant lines covered (93.1%)

102.43 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
76	88.19	0.22%	pg_shard.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	34.1 (PGVERSION=9.4)	15 Jan 2015 05:34AM UTC	16	93.1	Travis Job 34.1

Source Files on build 34

Coverage	∆	File	Lines	Relevant	Covered	Missed	Hits/Line

citusdata / pg_shard / 34
36%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 34

citusdata / pg_shard / 34 36%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 34

citusdata / pg_shard / 34
36%

README BADGES
x