diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-07-01 12:16:47 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-07-01 12:16:47 +0200 |
| commit | e186783d9e1d52cab965fe614780221a9859dd04 (patch) | |
| tree | 945ce8a341c91723589f9c2a308a2b6555414810 /crunch_global.sql | |
| parent | 21389cc83b96c5f98402b052db0333e89051f480 (diff) | |
| download | cruncher-e186783d9e1d52cab965fe614780221a9859dd04.tar.gz cruncher-e186783d9e1d52cab965fe614780221a9859dd04.zip | |
fix build regex matching
Diffstat (limited to 'crunch_global.sql')
| -rw-r--r-- | crunch_global.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/crunch_global.sql b/crunch_global.sql index d5485da..f79b9b4 100644 --- a/crunch_global.sql +++ b/crunch_global.sql @@ -45,12 +45,12 @@ join build b on (( -- only per patch global st.name = 'all' and reg.name = 'all' and - b.item_1 is not null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_1, ';', b.item_1_count, :build_regex_end) and - b.item_2 is not null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_2, ';', b.item_2_count, :build_regex_end) and - b.item_3 is not null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_3, ';', b.item_3_count, :build_regex_end) and - b.item_4 is not null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_4, ';', b.item_4_count, :build_regex_end) and - b.item_5 is not null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_5, ';', b.item_5_count, :build_regex_end) and - b.item_6 is not null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_6, ';', b.item_6_count, :build_regex_end) and + (b.item_1 is null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_1, ';', b.item_1_count, :build_regex_end)) and + (b.item_2 is null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_2, ';', b.item_2_count, :build_regex_end)) and + (b.item_3 is null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_3, ';', b.item_3_count, :build_regex_end)) and + (b.item_4 is null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_4, ';', b.item_4_count, :build_regex_end)) and + (b.item_5 is null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_5, ';', b.item_5_count, :build_regex_end)) and + (b.item_6 is null or p_s.item_grants RLIKE concat(:build_regex_start, b.item_6, ';', b.item_6_count, :build_regex_end)) and b.dimension_on = 'global' ) or b.name = 'all') |