Romulo Goncalves | 1 Aug 10:32 2008
Picon
Picon

sql/src/backends/monet5 sql_bpm.mx, , 1.13, 1.14

Update of /cvsroot/monetdb/sql/src/backends/monet5
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv16536

Modified Files:
	sql_bpm.mx 
Log Message:
Fix some compilation problems and also the send function.
THe type of the argument is a BAT:
newBatType(b->H->type, b->T->type)

The get function should return a BAT and not void.

U sql_bpm.mx
Index: sql_bpm.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/sql_bpm.mx,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -d -r1.13 -r1.14
--- sql_bpm.mx	31 Jul 2008 15:34:18 -0000	1.13
+++ sql_bpm.mx	1 Aug 2008 08:32:15 -0000	1.14
 <at>  <at>  -36,7 +36,7  <at>  <at> 
 address send_part_wrap
 comment "Send part to a remote host";

-pattern get_part(sname:str, tname:str, column:str, part:int):void
+pattern get_part(sname:str, tname:str, column:str, part:int):bat[:oid,:any_1]
 address get_part_wrap
 comment "Get part from a remote host";

(Continue reading)

Sjoerd Mullender | 1 Aug 15:29 2008
Picon
Picon

sql/src/odbc/samples/Tests odbcsample1.stable.out, SQL_2-24, 1.5, 1.5.12.1

Update of /cvsroot/monetdb/sql/src/odbc/samples/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv12908

Modified Files:
      Tag: SQL_2-24
	odbcsample1.stable.out 
Log Message:
Adapted test to test UTF-8 encoding going through.

U odbcsample1.stable.out
Index: odbcsample1.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/odbc/samples/Tests/odbcsample1.stable.out,v
retrieving revision 1.5
retrieving revision 1.5.12.1
diff -u -d -r1.5 -r1.5.12.1
--- odbcsample1.stable.out	11 Jan 2007 15:12:55 -0000	1.5
+++ odbcsample1.stable.out	1 Aug 2008 13:29:04 -0000	1.5.12.1
 <at>  <at>  -26,2006 +26,2006  <at>  <at> 
 # 14:55:35 >  odbcsample1
 # 14:55:35 >  

-0 value 0 0 2003:01:02 00-00-01
-1 value 1 1.5 2003:01:03 00-00-02
-2 value 2 3 2003:01:04 00-00-03
-3 value 3 4.5 2003:01:05 00-00-04
-4 value 4 6 2003:01:06 00-00-05
-5 value 5 7.5 2003:01:07 00-00-06
-6 value 6 9 2003:01:08 00-00-07
[...3976 lines suppressed...]
(Continue reading)

Sjoerd Mullender | 1 Aug 15:46 2008
Picon
Picon

sql/src/odbc/samples/Tests odbcsample1.stable.out, SQL_2-24, 1.5.12.1, 1.5.12.2

Update of /cvsroot/monetdb/sql/src/odbc/samples/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv24398

Modified Files:
      Tag: SQL_2-24
	odbcsample1.stable.out 
Log Message:
Fixed the test on a UTF-8-capable machine.

U odbcsample1.stable.out
Index: odbcsample1.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/odbc/samples/Tests/odbcsample1.stable.out,v
retrieving revision 1.5.12.1
retrieving revision 1.5.12.2
diff -u -d -r1.5.12.1 -r1.5.12.2
--- odbcsample1.stable.out	1 Aug 2008 13:29:04 -0000	1.5.12.1
+++ odbcsample1.stable.out	1 Aug 2008 13:46:30 -0000	1.5.12.2
 <at>  <at>  -26,2006 +26,2006  <at>  <at> 
 # 14:55:35 >  odbcsample1
 # 14:55:35 >  

-0 value ߢ0ߣ 0 2003:01:02 00-00-01
-1 value ߢ1ߣ 1.5 2003:01:03 00-00-02
-2 value ߢ2ߣ 3 2003:01:04 00-00-03
-3 value ߢ3ߣ 4.5 2003:01:05 00-00-04
-4 value ߢ4ߣ 6 2003:01:06 00-00-05
-5 value ߢ5ߣ 7.5 2003:01:07 00-00-06
-6 value ߢ6ߣ 9 2003:01:08 00-00-07
[...3976 lines suppressed...]
(Continue reading)

Sjoerd Mullender | 1 Aug 15:53 2008
Picon
Picon

sql/src/odbc/samples/Tests odbcsample1.stable.out, , 1.5, 1.6

Update of /cvsroot/monetdb/sql/src/odbc/samples/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv30746/src/odbc/samples/Tests

Modified Files:
	odbcsample1.stable.out 
Log Message:
propagated changes of Friday Aug 01 2008
from the SQL_2-24 branch to the development trunk

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/08/01 - sjoerd: src/odbc/samples/Tests/odbcsample1.stable.out,1.5.12.1
Adapted test to test UTF-8 encoding going through.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/08/01 - sjoerd: src/odbc/samples/Tests/odbcsample1.stable.out,1.5.12.2
Fixed the test on a UTF-8-capable machine.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Index: odbcsample1.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/odbc/samples/Tests/odbcsample1.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- odbcsample1.stable.out	11 Jan 2007 15:12:55 -0000	1.5
+++ odbcsample1.stable.out	1 Aug 2008 13:53:54 -0000	1.6
 <at>  <at>  -26,2006 +26,2006  <at>  <at> 
 # 14:55:35 >  odbcsample1
 # 14:55:35 >  

-0 value 0 0 2003:01:02 00-00-01
(Continue reading)

Romulo Goncalves | 2 Aug 08:42 2008
Picon
Picon

sql/src/backends/monet5 sql_bpm.mx, , 1.14, 1.15

Update of /cvsroot/monetdb/sql/src/backends/monet5
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv24720

Modified Files:
	sql_bpm.mx 
Log Message:
Set val value to compile again with Intel..

U sql_bpm.mx
Index: sql_bpm.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/sql_bpm.mx,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -d -r1.14 -r1.15
--- sql_bpm.mx	1 Aug 2008 08:32:15 -0000	1.14
+++ sql_bpm.mx	2 Aug 2008 06:42:37 -0000	1.15
 <at>  <at>  -388,7 +388,7  <at>  <at> 
 print_part_wrap(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci)
 {
 	mvc *m = NULL;
-	ValPtr val;
+	ValPtr val = NULL;
 	str msg = getContext(cntxt, mb, &m, NULL);
 	sql_schema *s;
 	sql_table *t;

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
(Continue reading)

Niels Nes | 2 Aug 18:38 2008
Picon
Picon

sql/src/test/bugs/Tests alter_table_add_column.sql, SQL_2-24, NONE, 1.1.2.1 alter_table_add_column.stable.err, SQL_2-24, NONE, 1.1.2.1 alter_table_add_column.stable.out, SQL_2-24, NONE, 1.1.2.1 All, SQL_2-24, 1.112.2.8, 1.112.2.9

Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv28628

Modified Files:
      Tag: SQL_2-24
	All 
Added Files:
      Tag: SQL_2-24
	alter_table_add_column.sql alter_table_add_column.stable.err 
	alter_table_add_column.stable.out 
Log Message:
test for (over strict) check on not null and default == NULL in alter table
add column statements

--- NEW FILE: alter_table_add_column.stable.out ---
stdout of test 'alter_table_add_column` in directory 'src/test/bugs` itself:

# 18:35:20 >  
# 18:35:20 >   mserver5 "--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm" --set
"sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs"  --set mapi_open=true
--set xrpc_open=true --set mapi_port=39702 --set xrpc_port=40584 --set monet_prompt= --trace 
"--dbname=mTests_src_test_bugs" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
# 18:35:20 >  

# MonetDB server v5.6.0, based on kernel v1.24.0
# Serving database 'mTests_src_test_bugs'
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
(Continue reading)

Niels Nes | 2 Aug 19:08 2008
Picon
Picon

sql/src/test/BugTracker/Tests alter_table_set_not_null.SF-1997030.sql, SQL_2-24, NONE, 1.1.2.1 alter_table_set_not_null.SF-1997030.stable.err, SQL_2-24, NONE, 1.1.2.1 alter_table_set_not_null.SF-1997030.stable.out, SQL_2-24, NONE, 1.1.2.1 All, SQL_2-24, 1.93.2.17, 1.93.2.18

Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv9281

Modified Files:
      Tag: SQL_2-24
	All 
Added Files:
      Tag: SQL_2-24
	alter_table_set_not_null.SF-1997030.sql 
	alter_table_set_not_null.SF-1997030.stable.err 
	alter_table_set_not_null.SF-1997030.stable.out 
Log Message:
add test for bug in alter talbe set not null

U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.93.2.17
retrieving revision 1.93.2.18
diff -u -d -r1.93.2.17 -r1.93.2.18
--- All	21 Jul 2008 15:28:52 -0000	1.93.2.17
+++ All	2 Aug 2008 17:08:16 -0000	1.93.2.18
 <at>  <at>  -135,3 +135,4  <at>  <at> 
 bat_descriptor_problem.SF-1997643
 between_on_strings.SF-2021508
 assert_fails_on_algebra_version.SF-2019349
+alter_table_set_not_null.SF-1997030

--- NEW FILE: alter_table_set_not_null.SF-1997030.sql ---
(Continue reading)

Niels Nes | 2 Aug 19:12 2008
Picon
Picon

sql/src/server sql_schema.mx, SQL_2-24, 1.140.2.3, 1.140.2.4

Update of /cvsroot/monetdb/sql/src/server
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10537/src/server

Modified Files:
      Tag: SQL_2-24
	sql_schema.mx 
Log Message:
fixed two problems related to null checking

1) when a column gets a 'not null' constraint the current content should be
checked. (see bug #1997030)

2) when we a column with 'not null' constraint but without default.
we should only dynamically check for 'not null' constraint violations.

U sql_schema.mx
Index: sql_schema.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/sql_schema.mx,v
retrieving revision 1.140.2.3
retrieving revision 1.140.2.4
diff -u -d -r1.140.2.3 -r1.140.2.4
--- sql_schema.mx	21 Jul 2008 07:48:28 -0000	1.140.2.3
+++ sql_schema.mx	2 Aug 2008 17:12:44 -0000	1.140.2.4
 <at>  <at>  -1264,10 +1264,7  <at>  <at> 
 		if (alter) {
 			atom *a = NULL;

-			if (!cs->null && !cs->def) {
-				return sql_error(sql, 02, "CREATE TABLE: column default value is NULL, but column has NOT NULL constraint\n");
(Continue reading)

Niels Nes | 2 Aug 20:36 2008
Picon
Picon

geom/BugTracker/Tests X_crash.SF-1971632.stable.out, , 1.2, 1.3

Update of /cvsroot/monetdb/geom/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17017/BugTracker/Tests

Modified Files:
	X_crash.SF-1971632.stable.out 
Log Message:
new approved ouput (includes table name) 

as we misuse binary writeInt to output (floats) including nil's there is
no need to check for (int) overflow.

Added 'unsafe' to functions which may touch 'GDKerrbuf'

U X_crash.SF-1971632.stable.out
Index: X_crash.SF-1971632.stable.out
===================================================================
RCS file: /cvsroot/monetdb/geom/BugTracker/Tests/X_crash.SF-1971632.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- X_crash.SF-1971632.stable.out	2 Jun 2008 13:44:19 -0000	1.2
+++ X_crash.SF-1971632.stable.out	2 Aug 2008 18:36:55 -0000	1.3
 <at>  <at>  -29,7 +29,7  <at>  <at> 
 [ 1	]
 [ 1	]
 [ 1	]
-% sys. # table_name
+% sys.geoms # table_name
 % count_ # name
 % int # type
(Continue reading)

Niels Nes | 2 Aug 20:36 2008
Picon
Picon

geom/src/monetdb4 geom.mx,,1.9,1.10

Update of /cvsroot/monetdb/geom/src/monetdb4
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17017/src/monetdb4

Modified Files:
	geom.mx 
Log Message:
new approved ouput (includes table name) 

as we misuse binary writeInt to output (floats) including nil's there is
no need to check for (int) overflow.

Added 'unsafe' to functions which may touch 'GDKerrbuf'

U geom.mx
Index: geom.mx
===================================================================
RCS file: /cvsroot/monetdb/geom/src/monetdb4/geom.mx,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- geom.mx	27 Jul 2008 12:27:11 -0000	1.9
+++ geom.mx	2 Aug 2008 18:36:56 -0000	1.10
 <at>  <at>  -360,10 +360,9  <at>  <at> 
 	size_t i;

 	for(i=0;i<cnt;i++, c++) {
-		assert(GDK_int_min <= c->xmin && c->xmin <= GDK_int_max);
-		assert(GDK_int_min <= c->ymin && c->ymin <= GDK_int_max);
-		assert(GDK_int_min <= c->xmax && c->xmax <= GDK_int_max);
-		assert(GDK_int_min <= c->ymax && c->ymax <= GDK_int_max);
(Continue reading)


Gmane