Transation is open behind the scene and not committed?

[SafwanHak]

1.7. Running the following script will create 2 Users. As you can see Luca has #11:0 while Joe has RID #11:-2. As you can see I don't start a transaction in my script but it seems that one of the commands is creating one. Because if I exit my console and come back and do a select, only User Luca is still available. Joe is lost.

select from User
----+------+----+-------+-----------+----------
#   |@RID  |name|out_has|out_livesIn|out_speaks

----+------+----+-------+-----------+----------
0   |#11:0 |Luca|[0]    |[0]        |[0]
1   |#11:-2|Joe |null   |null       |[0]

script:

#drop database if already exists
drop database remote:locahost/touca root pass;

#create touca database
create database remote:localhost/touca root pass local;

#reconnect
connect remote:localhost/touca root pass;

#create classes/Vectors
create class User extends V;
create class Language extends V;
create class Label extends V;
create class Email extends V;
create class City extends V;

#create Links/Edges
create class has extends E;
create class speaks extends E;
create class is extends E;
create class translatesTo extends E;
create class livesIn extends E;

#index
create property speaks.out LINK;
create property speaks.in LINK;
CREATE INDEX unique_speaks ON speaks (in, out) UNIQUE;

#create User Data
create vertex User set name = 'Luca';
create vertex User set name = 'Joe';

#create Language Data
create vertex Language set name = 'En-uk';
create vertex Language set name = 'En-us';
create vertex Language set name = 'Fr-fr';
create vertex Language set name = 'Ru-ru';
create vertex Language set name = 'Ar-sy';

#create Label Data
create vertex Label set name = 'Hello';
create vertex Label set name = 'Salut';
create vertex Label set name = 'Ciao';
create vertex Label set name = 'Good day';
create vertex Label set name = 'Bonjour';
create vertex Label set name = 'Hallo';
create vertex Label set name = 'Marhaba';
create vertex Label set name = 'Salut2';

#emails
create vertex Email set email = 'Luca@gmail.com';
create vertex Email set email = 'Luca@hotmail.com';

#edges for emails
create edge has from (select from User where name = 'Luca') to (select from Email where email = 'Luca@gmail.com');
create edge has from (select from User where name = 'Luca') to (select from Email where email = 'Luca@hotmail.com');

#City
create vertex City set name = 'Montreal';
create vertex City set name = 'Toronto';
create vertex City set name = 'New York';
create vertex City set name = 'Roma';

#edges for City
create edge livesIn from (select from User where name = 'Luca') to (select from City where name = 'Roma');
create edge livesIn from (select from User where name = 'Luca') to (select from City where name = 'Montreal');


#create the links between the User->Language
create edge speaks from (select from User where name = 'Luca') to (select from Language where name = 'En-uk');
create edge speaks from (select from User where name = 'Luca') to (select from Language where name = 'En-us');
create edge speaks from (select from User where name = 'Luca') to (select from Language where name = 'Fr-fr');
create edge speaks from (select from User where name = 'Luca') to (select from Language where name = 'Ar-sy');

create edge speaks from (select from User where name = 'Joe') to (select from Language where name = 'En-uk');
create edge speaks from (select from User where name = 'Joe') to (select from Language where name = 'En-us');

#create the links between label and language
create edge is from (select from Label where name = 'Hello') to (select from Language where name = 'En-uk');
create edge is from (select from Label where name = 'Hello') to (select from Language where name = 'En-us');
create edge is from (select from Label where name = 'Salut') to (select from Language where name = 'Fr-fr');
create edge is from (select from Label where name = 'Salut2') to (select from Language where name = 'Fr-fr');
create edge is from (select from Label where name = 'Ciao') to (select from Language where name = 'It-it');
create edge is from (select from Label where name = 'Good day') to (select from Language where name = 'En-uk');
create edge is from (select from Label where name = 'Bonjour') to (select from Language where name = 'Fr-fr');
create edge is from (select from Label where name = 'Hallo') to (select from Language where name = 'Ru-ru');
create edge is from (select from Label where name = 'Marhaba') to (select from Language where name = 'Ar-sy');

#create the links between labels
create edge translatesTo from (select from Label where name = 'Hello') to (select from Label where name = 'Good day') SET ncount = 3;
create edge translatesTo from (select from Label where name = 'Hello') to (select from Label where name = 'Hallo') SET ncount = 2;
create edge translatesTo from (select from Label where name = 'Hello') to (select from Label where name = 'Salut') SET ncount = 5;
create edge translatesTo from (select from Label where name = 'Hello') to (select from Label where name = 'Salut2') SET ncount = 7;
create edge translatesTo from (select from Label where name = 'Hello') to (select from Label where name = 'Ciao') SET ncount = 10;
create edge translatesTo from (select from Label where name = 'Good day') to (select from Label where name = 'Bonjour');
create edge translatesTo from (select from Label where name = 'Bonjour') to (select from Label where name = 'Marhaba');
create edge translatesTo from (select from Label where name = 'Hallo') to (select from Label where name = 'Marhaba');
create edge translatesTo from (select from Label where name = 'Salut') to (select from Label where name = 'Hallo') SET ncount = 1;
create edge translatesTo from (select from Label where name = 'Salut') to (select from Label where name = 'Salut2') SET ncount = 4;

[enisher]

Fixed in 1.7-SNAPSHOT