[sqlite] sqlite bug? Subquery containing like-expression in where clause with starting '%' returns no rows, but without '%' does

[Thomas Mittelstaedt]

Could this be a bug?

SELECT moz_places.id, moz_places.url, moz_places.title,
moz_bookmarks.parent    
    FROM moz_places    
    , moz_bookmarks    
     WHERE moz_places.id = moz_bookmarks.fk    and
     moz_bookmarks.parent = (select id from moz_bookmarks where title
like '%arbeit%')

returns no rows,

but using the subquery without the starting '%' returns data:

"297607","http://www.minijob-zentrale.de/DE/0_Home/node.html","Minijob-Zentrale 
- Startseite","83332"

Also just doing a 
select id from moz_bookmarks where title like '%arbeit%'
also returns several rows.

I am using sqlite3 version 3.7.14.1 under firefox 18 (Gecko 18.0.1)
using a firefox plugin called Sqlite Manager.

CREATE TABLE moz_bookmarks (id INTEGER PRIMARY KEY,type INTEGER, fk
INTEGER DEFAULT NULL, parent INTEGER, position INTEGER, title
LONGVARCHAR, keyword_id INTEGER, folder_type TEXT, dateAdded INTEGER,
lastModified INTEGER, guid TEXT)

CREATE TABLE moz_places (id INTEGER PRIMARY KEY, url LONGVARCHAR, title
LONGVARCHAR, rev_host LONGVARCHAR, visit_count INTEGER DEFAULT 0, hidden
INTEGER DEFAULT 0 NOT NULL, typed INTEGER DEFAULT 0 NOT NULL, favicon_id
INTEGER, frecency INTEGER DEFAULT -1 NOT NULL, last_visit_date INTEGER,
guid TEXT)

-- 
thomas


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users