- status: open --> closed
- assigned_to: High Performance Coder
Using the SARResults dataset. I attempted to apply calipers to s^2 to generate species -area relationships, but got the following SQL syntax error, indicating a missing conjunction:
12:50:29.063 › Async Rest API: minsky.reset [] =>Exception caught: sqlite3_stat
ement_backend::prepare: near ""s^2"": syntax error while preparing "select max(N
sp) as Nsp,"Area","Migration rate","s^2" from (select "Replicate","Area","Migrat
ion rate","s^2",Nsp from "SARResults" where "Mutation rate"='0.001000' and "Init
Num Species"='30.000000' "s^2">=0.078413 and "s^2"<=0.102106) group by "Area","
Migration rate","s^2"".
Attached dataset is too large to attach to this ticket. Uploaded to https://www.hpcoders.com.au/SARResults.sqlite
Anonymous