diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-07-02 20:57:23 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-07-02 20:57:23 +0200 |
| commit | 2be09e2ce40e60a452d865fbec6cd969c29ea42a (patch) | |
| tree | 36b086e57ee52b810980261cea2e22859d6db7a6 /crunch_global.sql | |
| parent | c60aeb4bb9e4381182ed0c30793ea6612ceaa283 (diff) | |
| download | cruncher-2be09e2ce40e60a452d865fbec6cd969c29ea42a.tar.gz cruncher-2be09e2ce40e60a452d865fbec6cd969c29ea42a.zip | |
fix table name via env var -> sql error
Diffstat (limited to 'crunch_global.sql')
| -rw-r--r-- | crunch_global.sql | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/crunch_global.sql b/crunch_global.sql index 6fbf212..1205dfc 100644 --- a/crunch_global.sql +++ b/crunch_global.sql @@ -1,4 +1,4 @@ -insert low_priority into :crunch_table +insert low_priority into `global_point` select null, now(), @@ -45,13 +45,15 @@ join build b on (( -- only per patch global st.name = 'all' and reg.name = 'all' 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' + ( + (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') where p.api_id in (:participant_api_ids) |