Project

General

Profile

Download (10.7 KB) Statistics
| Revision:

root/trunk/validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql @ 12403

# Date Author Comment
12403 02/24/2014 12:30 AM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: can't double-JOIN like in MySQL (`JOIN a JOIN b ON a_conds AND b_conds`), so split double-JOIN into two JOINs w/ own ON clauses
12402 02/24/2014 12:28 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: removed `LIMIT 10` to match output queries
12401 02/24/2014 12:26 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: updated table names to match our renamings
12398 02/24/2014 12:21 AM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: can't double-JOIN like in MySQL (`JOIN a JOIN b ON a_conds AND b_conds`), so split double-JOIN into two JOINs w/ own ON clauses
12397 02/24/2014 12:16 AM Aaron Marcuse-Kubitza

added validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql, modified from bien3_validations_salvias_db_original.sql using the steps at http://wiki.vegpath.org/Aggregating_validations_refactoring