Hi,

Alexandru Toth wrote:

Hi,

Not in console. But if you create a file , it will show up with command line bellow.

mclient -lsql -umonetdb 1.sql

Confirmed.

Or, is Mac OS -speciffic ?

No, also on Linux PC.

You assume here that auto-commit is re-enabled when the statements fall outside the transaction brackets. The mode change and the consequences should be clearly documented in Mapi. It may indeed be useful to fall-back to auto-commit outside explicit transaction boundaries.

regards, Martin

BR, Alex

On May 22, 2007, at 11:43 PM, Martin Kersten wrote:

...

Hi,

Bug not confirmed on my Linux PC using direct execution at the console, nor using MapiClient.

% sys.tbl_xy, sys.tbl_xy # table_name % x, y # name % int, int # type % 2, 4 # length [ 0, 0 ] [ 1, 1 ] [ 2, 2 ] [ 3, 3 ] [ 4, 4 ] [ 5, 5 ] [ 6, 6 ] [ 7, 7 ] [ -1, -100 ] [ 8, 8 ] [ 9, 9 ] [ 10, 10 ]

Alexandru Toth wrote:

...

Hi, Test script bellow has few transactions, and statements outside any transaction which are not executed (INSERT negative numbers, easy to spot). Is this a bug? Both MySQL and SQLite inserts the row with negative numbers (after replacing "start transaction" with "begin"). Save the script bellow as 1.sql

---

start transaction; create table tbl_xy (x int , y int); insert into tbl_xy values (0,0); insert into tbl_xy values (1,1); commit; start transaction; insert into tbl_xy values (2,2); insert into tbl_xy values (3,3); insert into tbl_xy values (4,4); commit; start transaction; insert into tbl_xy values (5,5); insert into tbl_xy values (6,6); insert into tbl_xy values (7,7); commit; insert into tbl_xy values (-1, -100); start transaction; insert into tbl_xy values (8,8); insert into tbl_xy values (9,9); insert into tbl_xy values (10,10); commit;

---

Execution of script: macu:~/Desktop alex$ mclient -lsql -umonetdb ~/Desktop/1.sql [ 1 ] [ 1 ] [ 1 ] [ 1 ] [ 1 ] [ 1 ] [ 1 ] [ 1 ] [ 1 ] [ 1 ] [ 1 ] [ 1 ]

---

Looking for negative numbers, none found: macu:~/Desktop alex$ mclient -lsql -umonetdb sql>select * from tbl_xy; % sys.tbl_xy, sys.tbl_xy # table_name % x, y # name % int, int # type % 2, 2 # length [ 0, 0 ] [ 1, 1 ] [ 2, 2 ] [ 3, 3 ] [ 4, 4 ] [ 5, 5 ] [ 6, 6 ] [ 7, 7 ] [ 8, 8 ] [ 9, 9 ] [ 10, 10 ] Version: MonetDB Server v5.0.0_beta2_1 BR, Alex