[sqlite] How to Online Backup In-Memory DB with SQL?

SQLite Online Backup API such as sqlite3_backup***, it's very convenient to backup In-Memory DB to disk. If sqlite also provide SQL to do this, it will bring more convenience for some scenarios, such as pysqlite in python. ___ sqlite-users mailing l

[sqlite] Why "select count(distinct f1, f2) fro m tbl_test" can not work?

tbl_test maybe like this: create table tbl_test(f1, f2, f3); Now, I want to get the num of records which (f1, f2) are distinct. I try "select count(distinct f1, f2) from tbl_test", but error occur: SQL error: wrong number of arguments to function count() although, I can do like this, but I thi

Re: [sqlite] Problem with cast(xx as YY)

> Don't complain that SQLite's cast works the other way than SQL Server > or MySQL. SQLite behaves in a very unique way when the type-related > matters are a concern. And you better tell as how behavior of cast() > is different from 3.3.4. Thanks a lot! Actually, The 'select' return same result in

[sqlite] Problem with cast(xx as YY)

type after call cast(f1 as int). The behavior of cast(XX as YY) is not the same as the old version, such as 3.3.4, and also different to SQL Server or MYSQL. Is this a bug? or a characteristic of sqlite? I hope for your response, t