[sqlite] 3.6.23 segmentation fault with trigger and DEFAULT VALUES

Hi, dear sqlite-list. I am a newbie with sqlite. I found a bug lately, like this: CREATE TABLE stuff (id INTEGER PRIMARY KEY DEFAULT 1); CREATE TRIGGER stuff_insert_trg BEFORE INSERT ON stuff BEGIN SELECT * FROM stuff; END; insert into stuff DEFAULT VALUES; It will be

Re: [sqlite] 3.6.23 segmentation fault with trigger and DEFAULT VALUES

On 7 Jun 2010, at 9:49am, 陶渊俊 wrote: > It will be segmentation fault. Which operating system are you running ? Are you running your code in the command-line program or with your own program ? If you are running your own program, are you accessing SQLite with the C functions, or are you using

Re: [sqlite] 3.6.23 segmentation fault with trigger and DEFAULT VALUES

Information on this page: http://www.sqlite.org/lang_createtrigger.html Reads: The "INSERT INTO *table* DEFAULT VALUES" form of the INSERTstatement is not supported. I do not think it is a problem/defect/bug. What say? On Mon, Jun 7, 2010 at

[sqlite] sql api for ufs

Subject says it all. I'm looking for a sql (like) api for ufs. I'd like to SELECT by device, inode, size, group, etc. If all the fs stat data was the db schema, I'd like a query engine that makes indexes of the meta data for fast queries, access to the file data, and queries of offline devices,

Re: [sqlite] Oracle connection

for clearification: the roots of the question: business needs; our client has a big Oracle infrastructure. Now they want, in relation to their infrastructure a litte App based on SQlite. as I mentioned earlier: to copy data from an Oracle DB to another Oracle DB there is just one single line

Re: [sqlite] 3.6.23 segmentation fault with trigger and DEFAULT VALUES

On Mon, Jun 07, 2010 at 02:53:26PM +0530, Harsha scratched on the wall: > Information on this page: http://www.sqlite.org/lang_createtrigger.html > > Reads: > >The "INSERT INTO *table* DEFAULT VALUES" form of the > INSERTstatement is not >

Re: [sqlite] sql api for ufs

On Sun, 6 Jun 2010 19:50:27 -0700, George Georgalis wrote: >Subject says it all. I'm looking for a sql (like) api for ufs. >I'd like to SELECT by device, inode, size, group, etc. If all >the fs stat data was the db schema, I'd like a query engine that >makes indexes of the

Re: [sqlite] sql api for ufs

On Mon 07 Jun 2010 at 05:07:43 PM +0200, Kees Nuyt wrote: > >That could be implemented as an appication with a set of >virtual tables, backed by the readdir() and stat() system >calls. >I haven't heard of any implementation, although fossil

Re: [sqlite] sql api for ufs

Hi George Have you looked at SQLite? I use it to catalog my files and find out where the little so-and-sos are! I use Rexx to do all that stuff. I have a rexx snippet that will track file creation/modification/delete. Unfortunately, I do not know how to adapt it for my system so I have to do a

[sqlite] last_insert_rowid & INTEGER PRIMARY KEY columns

The tcl interface spec says: > The "last_insert_rowid" method returns an integer which is the ROWID of > the most recently inserted database row. So if I have db eval {CREATE TABLE t(the_key INTEGER PRIMARY KEY, data TEXT)} and I db eval {INSERT INTO t VALUES(NULL, 'foo')} then does

Re: [sqlite] last_insert_rowid & INTEGER PRIMARY KEY columns

Eric Smith wrote: > The tcl interface spec says: > >> The "last_insert_rowid" method returns an integer which is the ROWID of >> the most recently inserted database row. > > So if I have > > db eval {CREATE TABLE t(the_key INTEGER PRIMARY KEY, data TEXT)} > > and I > > db

Re: [sqlite] 3.6.23 segmentation fault with trigger and DEFAULT VALUES

This is my first time to reply email of gmane-news. so if there is anything wrong, please forgive me. >Which operating system are you running ? >Are you running your code in the command-line program or with your own program ? >If you are running your own program, are you accessing