search

APSIMInitiative / APSIM710

APSIM
https://www.apsim.info
30 stars 47 forks source link

ApsimX: SQL error where two columns have the same name but different capitalisation #1346

Closed ApsimBot closed 5 years ago

ApsimBot commented 5 years ago

Legacy Bug ID: 1914 Author: Justin Date: 2014-07-07 10:50:08 +0000 UTC

CREATE TABLE AnnualOutput([SimulationID] integer,[year] integer,[Clock.Today] date,[OilPalm.Age] integer,[AnnualYield] integer,[CumulativeFrondNumber] integer,[AnnualBunches] integer,[AnnualRain] integer,[AnnualEo] integer,[AnnualNPP] integer,[AnnualDnit] integer,[AnnualFertiliser] integer,[Annualrain] integer)

Note Annualrain and AnnualRain. Allowed in the DataTable as they're different but the database is not case sensitive thus they are seen as the same.

ApsimBot commented 5 years ago

Author: hol353 Date: 2014-07-28 09:32:00 +0000 UTC

I've changed report to remove the duplicate column names (case insensitively)