Project

General

Profile

Actions

Bug #2812

closed

Query crashes mapping program when concept relationships are logically inconsistent

Added by Robert Peet over 17 years ago. Updated over 17 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

Actions #1

Updated by xianhua liu over 17 years ago

fixed

Actions #2

Updated by Robert Peet over 17 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.

Actions #3

Updated by Robert Peet over 17 years ago

fixed

Actions #4

Updated by Redmine Admin over 11 years ago

Original Bugzilla ID was 2812

Actions

Also available in: Atom PDF