zql
zql copied to clipboard
gibello
Compatibility issues
This is an amazing project, unfortunately it seems that this project is lack of maintaining and improvement. I found some issues for the normal SQL parsing, such as :
CREATE TABLE IF NOT EXISTS docs (
id int(6) unsigned NOT NULL,
rev int(3) unsigned NOT NULL,
content varchar(200) NOT NULL,
PRIMARY KEY (id,rev)
) DEFAULT CHARSET=utf8;
INSERT INTO docs (id, rev, content) VALUES
('1', '1', 'The earth is flat'),
('2', '1', 'One hundred angels can dance on the head of a pin'),
('1', '2', 'The earth is flat and rests on a bull's horn'),
('1', '3', 'The earth is like a ball.');
SELECT a.id, a.rev, a.content
FROM docs a
INNER JOIN (
SELECT id, MAX(rev) rev
FROM docs
GROUP BY id
) b ON a.id = b.id AND a.rev = b.rev;
SELECT a.*
FROM docs a
LEFT OUTER JOIN docs b
ON a.id = b.id AND a.rev < b.rev
WHERE b.id IS NULL;
