Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests
In directory 
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1972/src/test/BugDay_2005-10-06_2.9.3/Tests

Modified Files:
        CrashMe_SQL_server_crash-2.SF-921673.stable.out 
Log Message:

A sequence of group new and derives is now closed with a group.done (does
the last step ie a group.new or derive).
This makes the code in merge table a bit cleaner (more could be done later)

sql.bind and append/update/delete now have an extra (first) argument,
making them safe to use in the dataflow (ie solved using variable dependencies)
(BREAKS octopus !)

Implemented read only tables. Use 
ALTER TABLE x SET READ ONLY; 
(cannot be reverted currently)

fixed bug in limit/offset handling, now we have 64 bit wrd instead of int.

The new read only required schema changes, ie backup/restore your db.
We therefor claimed some more oid's for internal functions.



Index: CrashMe_SQL_server_crash-2.SF-921673.stable.out
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -d -r1.21 -r1.22
--- CrashMe_SQL_server_crash-2.SF-921673.stable.out     20 Jul 2009 13:56:59 
-0000      1.21
+++ CrashMe_SQL_server_crash-2.SF-921673.stable.out     27 Feb 2010 19:28:18 
-0000      1.22
@@ -28,7 +28,7 @@
 % .,   sys.schemas,    .tables,        .columns,       .columns,       
.columns,       .columns,       .,      .,      .,      .,      .columns,       
.,      .,      .,      .,      .,      .,      . # table_name
 % table_cat,   table_schem,    table_name,     column_name,    type_name,      
column_size,    decimal_digits, buffer_length,  num_prec_radix, nullable,       
remarks,        column_def,     sql_data_type,  sql_datetime_sub,       
char_octet_length,      ordinal_position,       scope_catalog,  scope_schema,   
scope_table # name
 % char,        varchar,        varchar,        varchar,        varchar,        
int,    int,    tinyint,        tinyint,        char,   char,   varchar,        
tinyint,        tinyint,        tinyint,        int,    char,   char,   char # 
type
-% 0,   3,      10,     11,     7,      4,      1,      1,      2,      0,      
0,      0,      1,      1,      1,      1,      0,      0,      0 # length
+% 0,   3,      10,     12,     7,      4,      1,      1,      2,      0,      
0,      0,      1,      1,      1,      2,      0,      0,      0 # length
 [ NULL,        "sys",  "args", "id",   "int",  32,     0,      0,      10,     
NULL,   NULL,   NULL,   0,      0,      0,      1,      NULL,   NULL,   NULL    
]
 [ NULL,        "sys",  "args", "func_id",      "int",  32,     0,      0,      
10,     NULL,   NULL,   NULL,   0,      0,      0,      2,      NULL,   NULL,   
NULL    ]
 [ NULL,        "sys",  "args", "name", "varchar",      256,    0,      0,      
10,     NULL,   NULL,   NULL,   0,      0,      0,      3,      NULL,   NULL,   
NULL    ]
@@ -45,6 +45,7 @@
 [ NULL,        "sys",  "columns",      "default",      "varchar",      2048,   
0,      0,      10,     NULL,   NULL,   NULL,   0,      0,      0,      7,      
NULL,   NULL,   NULL    ]
 [ NULL,        "sys",  "columns",      "null", "boolean",      1,      0,      
0,      10,     NULL,   NULL,   NULL,   0,      0,      0,      8,      NULL,   
NULL,   NULL    ]
 [ NULL,        "sys",  "columns",      "number",       "int",  32,     0,      
0,      10,     NULL,   NULL,   NULL,   0,      0,      0,      9,      NULL,   
NULL,   NULL    ]
+[ NULL,        "sys",  "columns",      "storage_type", "int",  32,     0,      
0,      10,     NULL,   NULL,   NULL,   0,      0,      0,      10,     NULL,   
NULL,   NULL    ]
 [ NULL,        "sys",  "functions",    "id",   "int",  32,     0,      0,      
10,     NULL,   NULL,   NULL,   0,      0,      0,      1,      NULL,   NULL,   
NULL    ]
 [ NULL,        "sys",  "functions",    "name", "varchar",      256,    0,      
0,      10,     NULL,   NULL,   NULL,   0,      0,      0,      2,      NULL,   
NULL,   NULL    ]
 [ NULL,        "sys",  "functions",    "func", "varchar",      8196,   0,      
0,      10,     NULL,   NULL,   NULL,   0,      0,      0,      3,      NULL,   
NULL,   NULL    ]


------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to