Project

General

Profile

Bug #2812

Query crashes mapping program when concept relationships are logically inconsistent

Added by Robert Peet about 13 years ago. Updated almost 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
atlas
Target version:
Start date:
04/07/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2812

Description

When I try to map Rubus leviculus I get what looks like an infinite loop. See error messages below.

Error: [Microsoft][ODBC Microsoft Access Driver] Query is too complex. Get Distribution from ODBC by name: select purename,source,state,county,cultivated from source,distribution where ( ( source='CVS' AND (purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' )) OR ( source='NCNHP' AND (purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' )) OR ( source='RAB' AND (purename='Rubus flagellaris' )) OR ( source='USDA' AND (purename='Rubus celer' OR purename='Rubus clarus' OR purename='Rubus flagellaris' OR purename='Rubus flagellaris' OR purename='Rubus iniens' OR purename='Rubus leviculus' OR purename='Rubus nefrens' OR purename='Rubus obvius' OR purename='Rubus particularis' OR purename='Rubus pernagaeus' OR purename='Rubus scambens' OR purename='Rubus sewardianus' OR purename='Rubus whartoniae' )) OR ( source='NCSC' AND (purename='Rubus akermanii' OR purename='Rubus cathartium' OR purename='Rubus celer' OR purename='Rubus clarus' OR purename='Rubus cordifrons' OR purename='Rubus deamii' OR purename='Rubus decor' OR purename='Rubus enslenii' OR purename='Rubus felix' OR purename='Rubus flagellaris' OR purename='Rubus hypolasius' OR purename='Rubus imperiorum' OR purename='Rubus iniens' OR purename='Rubus leviculus' OR purename='Rubus longipes' OR purename='Rubus nefrens' OR purename='Rubus obvius' OR purename='Rubus particularis' OR purename='Rubus pernagaeus' OR purename='Rubus rosagnetis' OR purename='Rubus scambens' OR purename='Rubus sewardianus' OR purename='Rubus subinnoxius' OR purename='Rubus tetricus' OR purename='Rubus whartoniae' )) OR ( source='WEWO' AND (purename='Rubus akermanii' OR purename='Rubus cathartium' OR purename='Rubus celer' OR purename='Rubus clarus' OR purename='Rubus cordifrons' OR purename='Rubus deamii' OR purename='Rubus decor' OR purename='Rubus enslenii' OR purename='Rubus felix' OR purename='Rubus flagellaris' OR purename='Rubus hypolasius' OR purename='Rubus imperiorum' OR purename='Rubus iniens' OR purename='Rubus leviculus' OR purename='Rubus longipes' OR purename='Rubus nefrens' OR purename='Rubus obvius' OR purename='Rubus particularis' OR purename='Rubus pernagaeus' OR purename='Rubus rosagnetis' OR purename='Rubus scambens' OR purename='Rubus sewardianus' OR purename='Rubus subinnoxius' OR purename='Rubus tetricus' OR purename='Rubus whartoniae' )) OR ( source='X-ILL' AND (purename='Rubus akermanii' OR purename='Rubus cathartium' OR purename='Rubus celer' OR purename='Rubus clarus' OR purename='Rubus cordifrons' OR purename='Rubus deamii' OR purename='Rubus decor' OR purename='Rubus enslenii' OR purename='Rubus felix' OR purename='Rubus flagellaris' OR purename='Rubus hypolasius' OR purename='Rubus imperiorum' OR purename='Rubus iniens' OR purename='Rubus leviculus' OR purename='Rubus longipes' OR purename='Rubus nefrens' OR purename='Rubus obvius' OR purename='Rubus particularis' OR purename='Rubus pernagaeus' OR purename='Rubus rosagnetis' OR purename='Rubus scambens' OR purename='Rubus sewardianus' OR purename='Rubus subinnoxius' OR purename='Rubus tetricus' OR purename='Rubus whartoniae' )) OR ( source='CPE' AND (purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' OR purename='Rubus enslenii' )) OR ( source='NCU' AND (purename='Rubus akermanii' OR purename='Rubus cathartium' OR purename='Rubus celer' OR purename='Rubus clarus' OR purename='Rubus cordifrons' OR purename='Rubus deamii' OR purename='Rubus decor' OR purename='Rubus enslenii' OR purename='Rubus felix' OR purename='Rubus flagellaris' OR purename='Rubus hypolasius' OR purename='Rubus imperiorum' OR purename='Rubus iniens' OR purename='Rubus leviculus' OR purename='Rubus longipes' OR purename='Rubus nefrens' OR purename='Rubus obvius' OR purename='Rubus particularis' OR purename='Rubus pernagaeus' OR purename='Rubus rosagnetis' OR purename='Rubus scambens' OR purename='Rubus sewardianus' OR purename='Rubus subinnoxius' OR purename='Rubus tetricus' OR purename='Rubus whartoniae' )) ) AND source.distribution=distribution.distribution AND distribution.bad=FALSE

History

#1 Updated by xianhua liu about 13 years ago

fixed

#2 Updated by Robert Peet about 13 years ago

fixed, but I do not know how.

The source of this error appears to have been the logical inconsistency of two concept relations where one outside concept was included in each of two accepted Weakley concepts.

We now need to search for additional logical inconsistences in the Weakley concepts.

#3 Updated by Robert Peet almost 13 years ago

fixed

#4 Updated by Redmine Admin over 7 years ago

Original Bugzilla ID was 2812

Also available in: Atom PDF