Somewhere between:
2016-09-03 16:23:42 672c21bcf09c5bfb67e061456a56be45409c4f34
2016-09-09 20:23:59 19e2e5950541f1a93eed994cc2b1eaf64b68e858
where the former works and the later crashes (with a wunderful new fangled
Windows 10 content free error message) ((I do not have all versions from the
fossil repository in my private repository)
also fails on head of trunk
2016-09-18 16:08:10 6bf5ba10d28f1b0a32aa9a560ae3143a1235eadb
(Compiled for Window 32-bit using MinGW gcc version 4.9.3
(x86_64-win32-sjlj-rev1, Built by MinGW-W64 project)
compiler options -m32 -s -O2 -mwin32 -pipe -falign-functions=16
-falign-loops=16 -flto
on a query of the following form:
update program
set showType = 'Special'
where showType in ('Series', 'Sports')
and program in (select distinct program
from genrlink, genre
where genrlink.genre = genre.genre
and class in ('Special', 'Olympics'));
.schema -indent
CREATE TABLE advisory(
advisory integer primary key,
advisoryname text collate nocase not null default 'Unknown' unique
);
CREATE TABLE advlink(
program text not null collate nocase,
advisory integer not null,
primary key(program, advisory)
) WITHOUT ROWID;
CREATE TABLE crew(
crew integer primary key,
surname text collate nocase not null default '',
givenname text collate nocase not null default '',
unique(surname, givenname)
);
CREATE TABLE crewlink(
program text not null collate nocase,
crew integer not null,
role integer not null,
primary key(program, role, crew)
) WITHOUT ROWID;
CREATE TABLE genre(
genre integer primary key,
class text collate nocase not null default 'Unknown' unique
);
CREATE TABLE genrlink(
program text not null collate nocase,
genre integer not null,
relevance integer not null default 0,
primary key(program, relevance, genre)
) WITHOUT ROWID;
CREATE TABLE lineup(
lineup text not null collate nocase primary key,
name text not null collate nocase default 'No Name Given',
device text not null collate nocase default 'No Device Given',
location text not null collate nocase default 'No Location Given',
postalcode text not null collate nocase default '',
type text not null collate nocase default ''
) WITHOUT ROWID;
CREATE TABLE map(
lineup text not null collate nocase,
station text not null collate nocase,
channel integer not null,
validfrom integer not null,
validto integer not null,
primary key(lineup, station, channel, validfrom, validto)
) WITHOUT ROWID;
CREATE TABLE program(
program text not null collate nocase primary key,
showType text not null collate nocase default '',
series text collate nocase,
title text collate nocase,
subtitle text collate nocase,
description text not null collate nocase default 'No Description Available',
colorCode text not null collate nocase default 'Color',
starRating text not null collate nocase default '',
originalAirDate date,
syndicatedEpisodeNumber text collate nocase,
year integer,
mpaaRating text default '' collate nocase,
runTime integer
) WITHOUT ROWID;
CREATE TABLE role(
role integer primary key,
rolename text collate nocase not null default 'Unknown Role' unique
);
CREATE TABLE schedule(
time integer not null,
endtime integer not null,
station text not null collate nocase,
program text not null collate nocase,
duration integer not null,
tvRating text not null default '' collate nocase,
stereo integer not null default 0,
ei integer not null default 0,
subtitled integer not null default 0,
hdtv integer not null default 0,
new integer not null default 0,
dolby integer not null default 0,
closeCaptioned integer not null default 0,
part integer,
parts integer,
live_tape text collate nocase,
primary key(time, station)
) WITHOUT ROWID;
CREATE TABLE station(
station text not null collate nocase primary key,
callsign text not null collate nocase,
name text not null collate nocase default 'No Name Given',
affiliate text not null collate nocase default 'Independant',
fccChannelNumber integer
) WITHOUT ROWID;
CREATE TABLE mySeries(series text collate nocase primary key) WITHOUT ROWID;
CREATE TABLE myChannels(
channel integer not null,
lineup text not null,
primary key(lineup, channel)
) WITHOUT ROWID;
CREATE TABLE myTitles(
selected text collate nocase,
title text collate nocase primary key
);
CREATE INDEX stationschedule on schedule(
station,
time,
program,
endtime,
duration
);
CREATE INDEX stationcallsign on station(callsign, station);
CREATE INDEX programTitle on program(title);
CREATE UNIQUE INDEX advisoryinverse on advisory(advisoryname, advisory);
CREATE UNIQUE INDEX advisoryforward on advisory(advisory, advisoryname);
CREATE UNIQUE INDEX advlinkinverse on advlink(advisory, program);
CREATE UNIQUE INDEX crewforward on crew(crew, surname, givenname);
CREATE UNIQUE INDEX crewinverse on crew(surname, givenname, crew);
CREATE UNIQUE INDEX crewbyrole on crewlink(role, crew, program);
CREATE UNIQUE INDEX crewbycrew on crewlink(crew, role, program);
CREATE UNIQUE INDEX genreinverse on genre(class, genre);
CREATE UNIQUE INDEX genreforward on genre(genre, class);
CREATE UNIQUE INDEX genrlinkgenre on genrlink(genre, program, relevance);
CREATE UNIQUE INDEX programPS on program(program, showType);
CREATE UNIQUE INDEX programSP on program(showType, program);
CREATE UNIQUE INDEX myChannels_CL on myChannels(channel, lineup);
CREATE UNIQUE INDEX myChannels_LC on myChannels(lineup, channel);
---
Life should not be a journey to the grave with the intention of arriving safely
in a pretty and well preserved body, but rather to skid in broadside in a cloud
of smoke, thoroughly used up, totally worn out, and loudly proclaiming "Wow!
What a Ride!"
-- Hunter S. Thompson
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
