java.lang.AssertionError: The update trigger 4 RTree index definition for table ADMINISTRATIVE_SUBDIVISION_S is invalid. Regex: CREATE\s+TRIGGER\s+"?rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE_update4"?\s+AFTER\s+UPDATE\s+ON\s+"?ADMINISTRATIVE_SUBDIVISION_S"?\s+WHEN\s+OLD."?\w"?\s!=\sNEW."?\w"?\s+AND\s+(\sNEW."?SHAPE"?\s+IS\sNULL\s+OR\s+ST_IsEmpty\s(\sNEW."?SHAPE"?))\sBEGIN\s+DELETE\s+FROM\s+"?rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE"?\s+WHERE\s+\w\sIN\s(\sOLD."?\w"?\s,\sNEW."?\w"?);\s*END Actual: CREATE TRIGGER rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE_update4 AFTER UPDATE OF SHAPE ON ADMINISTRATIVE_SUBDIVISION_S WHEN OLD.OBJECTID != NEW.OBJECTID AND (NEW.SHAPE IS NULL OR ST_IsEmpty (NEW.SHAPE)) BEGIN DELETE FROM rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE WHERE id IN (OLD.OBJECTID,NEW.OBJECTID); END
Test executes the following statement: `SELECT sql FROM sqlite_master WHERE type='trigger' AND name LIKE 'rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE_update%%' ORDER BY name ASC
The errorness statement is zhe one for 'update4':
CREATE TRIGGER rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE_update4
AFTER UPDATE OF SHAPE ON ADMINISTRATIVE_SUBDIVISION_S
WHEN OLD.OBJECTID != NEW.OBJECTID AND
(NEW.SHAPE IS NULL OR ST_IsEmpty (NEW.SHAPE))
BEGIN
DELETE FROM rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE
WHERE id IN (OLD.OBJECTID,NEW.OBJECTID);
END
The string OF SHAPE is not expected.
=> Is the difference from the expected pattern fine?
Test suite used for testing: Current master branch (0.4-SNAPSHOT) of https://github.com/opengeospatial/ets-gpkg12-nsg.
Error reported by test suite:
java.lang.AssertionError: The update trigger 4 RTree index definition for table ADMINISTRATIVE_SUBDIVISION_S is invalid. Regex: CREATE\s+TRIGGER\s+"?rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE_update4"?\s+AFTER\s+UPDATE\s+ON\s+"?ADMINISTRATIVE_SUBDIVISION_S"?\s+WHEN\s+OLD."?\w"?\s!=\sNEW."?\w"?\s+AND\s+(\sNEW."?SHAPE"?\s+IS\sNULL\s+OR\s+ST_IsEmpty\s(\sNEW."?SHAPE"?))\sBEGIN\s+DELETE\s+FROM\s+"?rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE"?\s+WHERE\s+\w\sIN\s(\sOLD."?\w"?\s,\sNEW."?\w"?);\s*END Actual: CREATE TRIGGER rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE_update4 AFTER UPDATE OF SHAPE ON ADMINISTRATIVE_SUBDIVISION_S WHEN OLD.OBJECTID != NEW.OBJECTID AND (NEW.SHAPE IS NULL OR ST_IsEmpty (NEW.SHAPE)) BEGIN DELETE FROM rtree_ADMINISTRATIVE_SUBDIVISION_S_SHAPE WHERE id IN (OLD.OBJECTID,NEW.OBJECTID); END
OF SHAPE
is not expected. => Is the difference from the expected pattern fine?