mvhub-dev team mailing list archive

[Saroun Sek <saroun_sek@xxxxxxxxxxxxxxx>]

> This query is used in
> 
> lib-mvhub/lib/MVHub/Synonyms.pm-
> 
> put it back please.
> 
> 
> 023     -[SYNONYM_STEM_X_CONCAT_SUBMITTED_WORDS]
> 1024    -SELECT
> 1025    - our_aggregate_concat(submitted_word)
> 1026    -AS
> 1027    - submitted_words
> 1028    -FROM
> 1029    - synonym_stem
> 1030    -GROUP BY
> 1031    - synonym_id
> 1032    -ORDER BY
> 1033    - submitted_words

1042	+[SYNONYM_STEM_X_SUBMITTED_WORDS]
1043	+SELECT our_aggregate_concat(submitted_word) 
1044	+AS submitted_words 
1045	+FROM synonym_stem 
1046	+GROUP BY synonym_id
1047	+ORDER BY submitted_words

1182	     my $sql = MVHub::Utils::DB::get_sql_select_statement(
1183	-        'SYNONYM_STEM_X_CONCAT_SUBMITTED_WORDS');
1184	+        'SYNONYM_STEM_X_SUBMITTED_WORDS');

[SYNONYM_STEM_X_CONCAT_SUBMITTED_WORDS] was added after I moved the SQL to the lib.  When I merged with trunk, it conflicted, so I just deleted it.  Either way, they both contain the same SQL code.

-- 
https://code.launchpad.net/~saroun-sek/mvhub/sql_change/+merge/28658
Your team MVHub Developers is subscribed to branch lp:mvhub.