Re: [sqlite] Permissions issue with SQLite

2011-09-22 Thread Magnus Thor Torfason
On 9/22/2011 10:25, Dan Kennedy wrote: For new versions, new db files are created with the permissions specified by compilation option SQLITE_DEFAULT_FILE_PERMISSIONS. Subject to umask of course. http://www.sqlite.org/compile.html#default_file_permissions Thanks for your help. But I take it

[sqlite] Permissions issue with SQLite

2011-09-22 Thread Magnus Thor Torfason
Hi, I'm having a permission issue with SQLite on my institution's computing grid/cluster. When I create a file using touch (or any other program for that matter, it correctly receives '-rw-rw' as the permission. However, when I create it from SQLite, it gets created with '-rw-r-' (gr

Re: [sqlite] No error on selecting non-grouped column

2011-09-16 Thread Magnus Thor Torfason
On 9/14/2011 15:29, Jay A. Kreibich wrote: Most RDBMS systems will throw an error if you don't group or aggregate column references, but SQLite trust you to know what you're doing. Personally I've always found this to be very useful, as I often have queries that lead to great frustat

[sqlite] No error on selecting non-grouped column

2011-09-14 Thread Magnus Thor Torfason
I have this database of employees. A simple select looks like this: > select ename, job from emp order by job; "ENAME", "JOB" == "SCOTT", "ANALYST" "FORD", "ANALYST" "SMITH", "CLERK" "ADAMS", "CLERK" "JAMES", "CLERK" "MILLER", "CLERK" "JONES", "MANAGER" "BLAKE",