Re: [sqlite] UNION ALL with queries that have a different number ofcolumns

Clay Trychta wrote: > SELECT * FROM( > SELECT * FROM( >SELECT k FROM test_table > ) > UNION ALL > SELECT * FROM( >SELECT k, v FROM test_table > ) > ) > > I would think that unioning two selects which have a different number > of columns would return an error. If I

[sqlite] UNION ALL with queries that have a different number of columns

I've run into a case where a sqlite query I'm expecting to return an error is actually succeeding and I was wondering if anyone could point out why this query is valid. CREATE TABLE test_table( k INTEGER, v INTEGER ); INSERT INTO test_table( k, v ) VALUES( 4, 5 ); SELECT * FROM( SELECT *

Re: [sqlite] how to process password

Encryption is very hard to do right, so in general, let someone else do it. We use SEE (http://www.hwaci.com/sw/sqlite/see.html) with the key generated from a password by PBKDF2 and a high number of iterations. Previously, columns were encrypted with OS functions that made it impossible to move

Re: [sqlite] EXT : open database on Linux. Already db created on Mac.

You familiar with the sqlite3 shell? sqlite-shell here: http://www.sqlite.org/sqlite-shell-linux-x86-3071300.zip sqlite3 filename Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems

Re: [sqlite] EXT : Unknown module FTS4

You probably have another shared library in your path that is getting loaded first. Since you said shared library and not DLL I assume you're using Unix of some sort? Run "ldd" on your GUI app and see what library it says it will use. Also, you should have either strace or truss which can

[sqlite] open database on Linux. Already db created on Mac.

Hi All, What is the procedure to open the sqlite3 database file in Linux Terminal which is already created on Mac. Thanks in advance. Regards, ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] how to process password

I need insert any my bank-card information to sqlite db, so when I insert the car number like '3312' and car password like '7711', but I wanna nobody can see the password, so I create a function encode('7711','key') and decode(select from stable where carnum=3312, 'key') to see the password,

[sqlite] Unknown module FTS4

Hello, I have a weird problem. I am working on a shared library, written using C and a GUI application written on C++. GUI application uses the shared library. This shared library uses SQLite amalgamation and links statically. GUI also uses SQLite for some configuration purpose. It is also

Re: [sqlite] Handling concurrent read request to SQLite

On Thu, Jul 26, 2012 at 11:37 AM, Simon Slavin wrote: > > Have you set a timeout ? If you haven't the SQLite functions never back > off and retry when they find the database locked, they just immediately > return an error. > Thanks a lot. I didn't know about this feature.