不幸的是,公用表表达式和with子句只能在Linux3.6中使用,但是我的开源应用程序的用户正在使用SQLite 3.2,我不能强迫他们更新整个SQLite系统来获得新的包。0 AS level, collectionID, collectionName, parentCollectionID, CAST(collectionID AS VARCHAR(128)) AS Sort/' || CAST(c.collectionID AS VARCHAR) AS VARCHAR(128))
FROM collections