Hello SQLite users,
Hello Dr. Hipp,
I think I have found a bug related to UNION SELECT; try this:
CREATE TABLE Test1 (fld1)
CREATE TABLE Test2 (fld2)
INSERT INTO Test1 VALUES (1)
INSERT INTO Test2 VALUES (1)
SELECT * FROM Test1 UNION SELECT * FROM Test2
And I get only one record ?
Shouldn't
UNION working correctly. UNION returns distinct values; UNION ALL returns
all rows (including duplicates).
rayB
*** Confidentiality and Privilege Notice ***
This e-mail is intended only to be read or used by the addressee. It is
confidential and may contain
On Sat, 29 May 2004, Carlos Justiniano wrote:
I'm working on an open source messaging server (MsgSrv) which is
currently using SQLite. MsgSrv'ers are a network of P2P applications,
which communicate with one another. Each communication is a single
message, which is archived in a local SQLite
Anonymous access to the SQLite CVS repository will be suspended
for 2 weeks beginning Friday, 2004-June-04. Anonymous users will
still be able to download prepackaged sources, create and modify
trouble tickets, and review source code change logs. But the
source code files in CVS will be