sql: update times set block_id = 6 from pathway where times.block_id = 3;
CREATE TABLE IF NOT EXISTS times (
rowid INT,
vehicle_id TEXT,
begin_time INT,
end_time INT,
area REAL,
rect TEXT,
block_id INT,
layer_index INT
);
CREATE VIRTUAL TABLE IF NOT EXISTS pathway USING geopoly
(vehicle_id TEXT,
begin_time BIGINT,
end_time BIGINT,
area DOUBLE,
rect TEXT,
block_id BIGINT,
layer_index TINYINT);
when I exec the sql,the program will be running for ever;
It may be some error with update from when operate with geopoly or other virtual table!