Monet DB (relational database & XML database) SQL engine checkins

Romulo Goncalves | 1 Aug 2008 10:32

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 2008 15:29

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 2008 15:46

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 2008 15:53

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 2008 08:42

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 2008 18:38

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 2008 19:08

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 2008 19:12

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 2008 20:36

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 2008 20:36

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)

Group

gmane.comp.db.monetdb.sql.scm.

Advertisement

Project Web Page

Monet DB (relational database & XML database) SQL engine checkins

Search Archive

Page

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 20

Articles in period: 199

August 2008

Language

Change language

Options

Current view: Threads only / Showing only 20 lines / Not hiding cited text.
Change to All messages, whole messages, or hide cited text.

Post a message
NNTP Newsgroup
Classic Gmane web interface
XML

XML

RSS Feed
List Information

About Gmane

Recent entries

IMPORTANT: move of MonetDB repository imminent (30 Apr 2010)
sql ChangeLog,,1.3,1.4 (1 May 2010)
sql ChangeLog,,1.2,1.3 (1 May 2010)
sql/src/test/BugTracker-2010/Tests mat.slice_on_empty_BATs.SF-2994521. (1 May 2010)
sql/src/test/BugTracker-2010/Tests All, , 1.7, 1.8 (30 Apr 2010)
sql/src/test/BugTracker-2010/Tests All, Feb2010, 1.1.2.10, 1.1.2.11 (30 Apr 2010)
sql/src/server rel_optimizer.mx,,1.85,1.86 (28 Apr 2010)
sql/NT rules.msc,Feb2010,1.79.2.5,1.79.2.6 (27 Apr 2010)
sql/NT/MonetDB5-SQL64 MonetDB5-SQL-Installer.vdproj, Feb2010, 1.53.2.8 (27 Apr 2010)
sql MonetDB-SQL.spec, Feb2010, 1.3.2.10, 1.3.2.11 VERSION, Feb2010, 1. (27 Apr 2010)
sql/NT/MonetDB5-SQL MonetDB5-SQL-Installer.vdproj, Feb2010, 1.65.2.6, (27 Apr 2010)
geom MonetDB-geom.spec, Feb2010, 1.1.2.9, 1.1.2.10 configure.ag, Feb20 (27 Apr 2010)
geom/NT rules.msc, Feb2010, 1.27.2.5, 1.27.2.6 (27 Apr 2010)
sql/src/test/copy/Tests overflow_error.stable.out, , 1.1, 1.2 (27 Apr 2010)
sql ChangeLog.Feb2010,,1.3,1.4 (27 Apr 2010)
sql/src/storage/bat bat_storage.mx, , 1.53, 1.54 (26 Apr 2010)
sql/src/server rel_bin.mx, , 1.112, 1.113 rel_dump.mx, , 1.46, 1.47 re (26 Apr 2010)
sql/src/test/Tests trace.stable.out, , 1.4, 1.5 (26 Apr 2010)
sql/src/test/BugDay_2005-12-19_2.9.3/Tests select_from_env.SF-1240701. (26 Apr 2010)
sql/src/test/leaks/Tests check0.stable.out, , 1.42, 1.43 check1.stable (26 Apr 2010)
sql/src/common sql_backend.mx,,1.38,1.39 (26 Apr 2010)

Archives

3	May 2010
144	April 2010
124	March 2010
446	February 2010
492	January 2010
118	December 2009
513	November 2009
379	October 2009
350	September 2009
408	August 2009
185	July 2009
314	June 2009
412	May 2009
202	April 2009
180	March 2009
526	February 2009
197	January 2009
251	December 2008
329	November 2008
427	October 2008
129	September 2008
199	August 2008
167	July 2008
300	June 2008
159	May 2008
85	April 2008
106	March 2008
197	February 2008
211	January 2008
181	December 2007
238	November 2007
314	October 2007
236	September 2007
267	August 2007
94	July 2007
180	June 2007
137	May 2007
125	April 2007
144	March 2007
137	February 2007
128	January 2007

Design

Zawodny | Right Menu | Left Menu

Your Own Design

Paste the URL of your CSS below. Download CSS template