So it seems I found a bug in the 7.0.0 (64 bit) Version.
Over the weekend I installed a new Virtuoso (6.1.7 on a Windows XP 32 bit)
added the table:
create table "DB"."DBA"."A_TRIPLETEST"
(
"G" ANY,
"S" ANY,
"P" ANY,
"O" ANY,
"Occ" DATETIME
);
+ the trigger from my former e-mail
-> every triple will be inserted just once.
Now i created a new VM: Windows XP 64
+ Virtuoso 7.0.0 + A_TRIPLETEST table + same trigger
-> which results in the formerly described double-insert behaviour
Using dbg_obj_print did not yield any other insight or behaviour.
Since I can't use 'triggers off;' I have to scale my sql-code back to 6.1
for now.
Hope these findings will be useful.
Best regards,
Markus
2013/10/24 Jürgen Jakobitsch SWC <j.jakobit...@semantic-web.at>
> hi markus,
>
> sorry, i cannot reproduce the double-insert behaviour with
> Version: 06.01.3127 .
>
> i used a copy of your code with the only difference being that i do not
> use an INSERT into another table, but a
>
> dbg_obj_print(N.S);
> dbg_obj_print(N.P);
> dbg_obj_print(N.O);
>
> this way you can also make sure there are no circular triggers for
> whatever reason.
>
> wkr jürgen
>
> On Wed, 2013-10-23 at 15:26 +0200, Markus Freudenberg wrote:
> >
> > Hello,
> >
> >
> > any trigger syntax will do, e.g.:
> >
> >
> > create trigger BLUB AFTER INSERT on DB.DBA.RDF_QUAD REFERENCING NEW AS
> > N
> > {
> > if(N.G IS NOT NULL AND N.S IS NOT NULL AND N.P IS NOT NULL AND N.O IS
> > NOT NULL)
> > {
> > INSERT INTO A_TRIPLETEST VALUES(N.G, N.S, N.P, N.O, now());
> > }
> > }
> >
> >
> > after executing this:
> >
> >
> > SPARQL
> > PREFIX : <http://test/test/>
> >
> > INSERT INTO <http://test/test>
> > {
> > :HAND001 a :HAND;
> > :fingers "4"^^xsd:integer.
> > }
> >
> >
> > ...the previously empty table A_TRIPLETEST will look like this:
> >
> >
> > G ANY S ANY P ANY O ANY Occ DATETIME
> > #i1220 #i9982721 #i1 #i9982722 2013-10-23 14:51:46
> > #i1220 #i9982721 #i9982723 4 2013-10-23 14:51:46
> > #i1220 #i9982721 #i1 #i9982722 2013-10-23 14:51:46
> > #i1220 #i9982721 #i9982723 4 2013-10-23 14:51:46
> >
> >
> > notice: no other trigger is active on this or the RDF_QUAD table
> >
> >
> > I'm playing around with triggers on the RDF_QUAD table for a while and
> > thought the double-insert is a feature since it was so commonplace.
> > I am using the pre-build 7.0 version for windows. This test was
> > performed on a freshly installed instance of virtuoso on Ubuntu to see
> > if this would happen on linux too.
> >
> >
> > Since this trigger-question is central to my bachelor-thesis, I would
> > be very grateful if someone could look into this.
> >
> >
> > Thank you,
> >
> >
> > Markus
> >
> >
> > 2013/10/23 Jürgen Jakobitsch SWC <j.jakobit...@semantic-web.at>
> > hi sebastian,
> >
> > is the source code of your trigger available to take a look at
> > it?
> >
> > in any case, a "set triggers off;" might be useful [1].
> >
> > wkr jürgen
> >
> > [1] http://docs.openlinksw.com/virtuoso/TRIGGERS.html
> >
> > On Wed, 2013-10-23 at 11:55 +0200, Sebastian Tramp wrote:
> > > On Wed, Oct 23, 2013 at 11:49:23AM +0200, Markus Freudenberg
> > wrote:
> > >
> > > Dear list and Hugh esp.,
> > >
> > > one of our students here has an issue with insert triggers,
> > can you please look
> > > into it:
> > >
> > > > I noticed, that every triple inserted in the virtuoso
> > quad-table will cause
> > > > an insert trigger to fire twice (v. 7.0). Is this intended
> > and does this
> > > > happen to any triple without exception?
> > >
> > > Best regards
> > >
> > > Sebastian Tramp
> > >
> >
> > --
> >
> > | Jürgen Jakobitsch,
> > | Software Developer
> > | Semantic Web Company GmbH
> > | Mariahilfer Straße 70 / Neubaugasse 1, Top 8
> > | A - 1070 Wien, Austria
> > | Mob +43 676 62 12 710 | Fax +43.1.402 12 35 - 22
> >
> > COMPANY INFORMATION
> > | web : http://www.semantic-web.at/
> > | foaf :
> > http://company.semantic-web.at/person/juergen_jakobitsch
> > PERSONAL INFORMATION
> > | web : http://www.turnguard.com
> > | foaf : http://www.turnguard.com/turnguard
> > | g+ :
> > https://plus.google.com/111233759991616358206/posts
> > | skype : jakobitsch-punkt
> > | xmlns:tg = "http://www.turnguard.com/turnguard#";
> >
> >
>
> --
> | Jürgen Jakobitsch,
> | Software Developer
> | Semantic Web Company GmbH
> | Mariahilfer Straße 70 / Neubaugasse 1, Top 8
> | A - 1070 Wien, Austria
> | Mob +43 676 62 12 710 | Fax +43.1.402 12 35 - 22
>
> COMPANY INFORMATION
> | web : http://www.semantic-web.at/
> | foaf : http://company.semantic-web.at/person/juergen_jakobitsch
> PERSONAL INFORMATION
> | web : http://www.turnguard.com
> | foaf : http://www.turnguard.com/turnguard
> | g+ : https://plus.google.com/111233759991616358206/posts
> | skype : jakobitsch-punkt
> | xmlns:tg = "http://www.turnguard.com/turnguard#";
>
------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
