MonetDB: Oct2012 - enable yesterday's test

2012-11-22 Thread Fabian Groffen
Changeset: 895dcc4bf0da for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=895dcc4bf0da
Modified Files:
sql/test/BugTracker-2012/Tests/All
Branch: Oct2012
Log Message:

enable yesterday's test


diffs (8 lines):

diff --git a/sql/test/BugTracker-2012/Tests/All 
b/sql/test/BugTracker-2012/Tests/All
--- a/sql/test/BugTracker-2012/Tests/All
+++ b/sql/test/BugTracker-2012/Tests/All
@@ -53,3 +53,4 @@ not-equal-Bug.3139
 many-columns-truncated.Bug-3161
 aggregate_incorrect_precision_scale.Bug-3182
 timestamp-diff.Bug-3190
+string-insert-default-null-crash.Bug-3168
___
checkin-list mailing list
checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list


MonetDB: Oct2012 - getTableName: use correct backing array

2012-11-22 Thread Fabian Groffen
Changeset: c58ed8603d69 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c58ed8603d69
Modified Files:
java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java
Branch: Oct2012
Log Message:

getTableName: use correct backing array

Thanks Julian Hyde for noticing in bug #3192


diffs (12 lines):

diff --git a/java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java 
b/java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java
--- a/java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java
+++ b/java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java
@@ -480,7 +480,7 @@ public class MonetPreparedStatement
 * @return table name or  if not applicable
 */
public String getTableName(int col) throws SQLException 
{
-   return column[getColumnIdx(col)];
+   return table[getColumnIdx(col)];
}
 
/**
___
checkin-list mailing list
checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list


MonetDB: default - Replaced ungrouped sum/product aggregates wit...

2012-11-22 Thread Sjoerd Mullender
Changeset: 783e8d7f88b4 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=783e8d7f88b4
Added Files:
monetdb5/modules/mal/Tests/bigsum.mal
monetdb5/modules/mal/Tests/bigsum.stable.err
monetdb5/modules/mal/Tests/bigsum.stable.out
Modified Files:
clients/Tests/exports.stable.out
gdk/gdk_aggr.c
gdk/gdk_calc.h
monetdb5/modules/kernel/algebra.mx
monetdb5/modules/mal/Tests/All
monetdb5/modules/mal/calc.c
monetdb5/modules/mal/calc.mal
monetdb5/modules/mal/calc.mal.sh
Branch: default
Log Message:

Replaced ungrouped sum/product aggregates with same code as grouped aggrs.
Not only do we now get overflow checks, sum aggregates into flt/dbl
are now done without loss of precision.  For that, see the new test
bigsum which fails with the old code.


diffs (truncated from 2385 to 300 lines):

diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -160,6 +160,7 @@ BAT *BATouterjoin(BAT *l, BAT *r, BUN es
 BAT *BATprev(BAT *b);
 int BATprint(BAT *b);
 int BATprintf(stream *f, BAT *b);
+gdk_return BATprod(void *res, int tp, BAT *b, BAT *s, int skip_nils, int 
abort_on_error, int nil_if_empty);
 BAT *BATrangejoin(BAT *l, BAT *rl, BAT *rh, bit li, bit hi);
 BAT *BATreplace(BAT *b, BAT *n, bit force);
 BAT *BATrestrict(BAT *b, const void *hl, const void *hh, const void *tl, const 
void *th);
@@ -185,6 +186,7 @@ BAT *BATssort(BAT *b);
 BAT *BATssort_rev(BAT *b);
 BAT *BATsubselect(BAT *b, BAT *s, const void *tl, const void *th, int li, int 
hi, int anti);
 gdk_return BATsubsort(BAT **sorted, BAT **order, BAT **groups, BAT *b, BAT *o, 
BAT *g, int reverse, int stable);
+gdk_return BATsum(void *res, int tp, BAT *b, BAT *s, int skip_nils, int 
abort_on_error, int nil_if_empty);
 BAT *BATsunion(BAT *b, BAT *c);
 BAT *BATsunique(BAT *b);
 BAT *BATthetajoin(BAT *l, BAT *r, int mode, BUN estimate);
@@ -761,29 +763,6 @@ str ALGouterjoinestimate(int *result, in
 str ALGposition(wrd *retval, int *bid, ptr val);
 str ALGpositionBUN(wrd *retval, int *bid, ptr val, ptr tval);
 str ALGprejoin(int *rl, int *rr, int *l, int *r);
-str ALGprod_bte_bte(bte *res, int *bid, bit *empty_is_nil);
-str ALGprod_bte_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGprod_bte_int(int *res, int *bid, bit *empty_is_nil);
-str ALGprod_bte_lng(lng *res, int *bid, bit *empty_is_nil);
-str ALGprod_bte_sht(sht *res, int *bid, bit *empty_is_nil);
-str ALGprod_bte_wrd(wrd *res, int *bid, bit *empty_is_nil);
-str ALGprod_dbl_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGprod_flt_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGprod_flt_flt(flt *res, int *bid, bit *empty_is_nil);
-str ALGprod_int_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGprod_int_int(int *res, int *bid, bit *empty_is_nil);
-str ALGprod_int_lng(lng *res, int *bid, bit *empty_is_nil);
-str ALGprod_int_wrd(wrd *res, int *bid, bit *empty_is_nil);
-str ALGprod_lng_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGprod_lng_lng(lng *res, int *bid, bit *empty_is_nil);
-str ALGprod_sht_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGprod_sht_int(int *res, int *bid, bit *empty_is_nil);
-str ALGprod_sht_lng(lng *res, int *bid, bit *empty_is_nil);
-str ALGprod_sht_sht(sht *res, int *bid, bit *empty_is_nil);
-str ALGprod_sht_wrd(wrd *res, int *bid, bit *empty_is_nil);
-str ALGprod_wrd_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGprod_wrd_lng(lng *res, int *bid, bit *empty_is_nil);
-str ALGprod_wrd_wrd(wrd *res, int *bid, bit *empty_is_nil);
 str ALGprojectNIL(int *ret, int *bid);
 str ALGprojecthead(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
 str ALGprojecttail(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
@@ -827,29 +806,6 @@ str ALGsubsort23(bat *result, bat *norde
 str ALGsubsort31(bat *result, bat *bid, bat *order, bat *group, bit *reverse, 
bit *stable);
 str ALGsubsort32(bat *result, bat *norder, bat *bid, bat *order, bat *group, 
bit *reverse, bit *stable);
 str ALGsubsort33(bat *result, bat *norder, bat *ngroup, bat *bid, bat *order, 
bat *group, bit *reverse, bit *stable);
-str ALGsum_bte_bte(bte *res, int *bid, bit *empty_is_nil);
-str ALGsum_bte_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGsum_bte_int(int *res, int *bid, bit *empty_is_nil);
-str ALGsum_bte_lng(lng *res, int *bid, bit *empty_is_nil);
-str ALGsum_bte_sht(sht *res, int *bid, bit *empty_is_nil);
-str ALGsum_bte_wrd(wrd *res, int *bid, bit *empty_is_nil);
-str ALGsum_dbl_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGsum_flt_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGsum_flt_flt(flt *res, int *bid, bit *empty_is_nil);
-str ALGsum_int_dbl(dbl *res, int *bid, bit *empty_is_nil);
-str ALGsum_int_int(int *res, int *bid, bit *empty_is_nil);
-str ALGsum_int_lng(lng *res, int *bid, bit *empty_is_nil);
-str ALGsum_int_wrd(wrd *res, int *bid, bit 

MonetDB: default - Approved output after recent changes.

2012-11-22 Thread Sjoerd Mullender
Changeset: 84d0cbd527fd for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=84d0cbd527fd
Modified Files:
clients/Tests/exports.stable.out
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
monetdb5/optimizer/Tests/inline07.stable.out
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
sql/test/Tests/setoptimizer.stable.err
sql/test/Tests/setoptimizer.stable.out
Branch: default
Log Message:

Approved output after recent changes.


diffs (208 lines):

diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -2721,6 +2721,7 @@ str kunionRef;
 str kuniqueRef;
 str languageRef;
 str lastline(Client cntxt);
+str leftfetchjoinPathRef;
 str leftfetchjoinRef;
 str leftjoinPathRef;
 str leftjoinRef;
@@ -3031,6 +3032,7 @@ str schedulerRef;
 str selectNotNilRef;
 str selectRef;
 str semaRef;
+str semijoinPathRef;
 str semijoinRef;
 str setAccessRef;
 void setArgType(MalBlkPtr mb, InstrPtr p, int i, int tpe);
diff --git 
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out 
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
--- a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
+++ b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
@@ -55,8 +55,8 @@ Ready.
 % . # table_name
 % def # name
 % clob # type
-% 423 # length
-[ 
optimizer.inline();optimizer.remap();optimizer.evaluate();optimizer.costModel();optimizer.coercions();optimizer.emptySet();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.groups();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.dataflow();optimizer.history();optimizer.multiplex();optimizer.garbageCollector();
]
+% 446 # length
+[ 
optimizer.inline();optimizer.remap();optimizer.evaluate();optimizer.costModel();optimizer.coercions();optimizer.emptySet();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.groups();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.dataflow();optimizer.history();optimizer.multiplex();optimizer.garbageCollector();
 ]
 #explain copy into ttt from '/:\tmp/xyz';
 % .explain # table_name
 % mal # name
@@ -66,8 +66,8 @@ function user.s2_1{autoCommit=true}():vo
 X_2 := sql.mvc();
 (X_5:bat[:oid,:int] ,X_6:bat[:oid,:int] ,X_7:bat[:oid,:int] ) := 
sql.copy_from(sys:str,ttt:str,|:str,\\n:str,nil:str,null:str,/:\\tmp/xyz:str,-1:lng,0:lng,0:int);
 X_9 := sql.append(X_2,sys,ttt,a,X_5);
-X_11 := sql.append(X_9,sys:str,ttt:str,b,X_6);
-X_15 := sql.append(X_11,sys:str,ttt:str,c,X_7);
+X_11 := sql.append(X_9,sys,ttt,b,X_6);
+X_15 := sql.append(X_11,sys,ttt,c,X_7);
 X_16 := aggr.count(X_7);
 sql.affectedRows(X_15,X_16,);
 end s2_1;
@@ -83,8 +83,8 @@ end s2_1;
 % . # table_name
 % def # name
 % clob # type
-% 446 # length
-[ 
optimizer.inline();optimizer.remap();optimizer.evaluate();optimizer.costModel();optimizer.coercions();optimizer.emptySet();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.groups();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.dataflow();optimizer.history();optimizer.multiplex();optimizer.sql_append();optimizer.garbageCollector();
 ]
+% 469 # length
+[ 
optimizer.inline();optimizer.remap();optimizer.evaluate();optimizer.costModel();optimizer.coercions();optimizer.emptySet();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.groups();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.dataflow();optimizer.history();optimizer.multiplex();optimizer.sql_append();optimizer.garbageCollector();
  ]
 #explain copy into ttt from '/:\tmp/xyz';
 % .explain # table_name
 % mal # name
diff --git a/monetdb5/optimizer/Tests/inline07.stable.out 
b/monetdb5/optimizer/Tests/inline07.stable.out
--- a/monetdb5/optimizer/Tests/inline07.stable.out
+++ b/monetdb5/optimizer/Tests/inline07.stable.out
@@ -28,7 +28,7 @@ end main;
 function user.qry():void;   #  0 qry:void := user.qry() {G}
 b := bat.new(:oid,:int);#  1 b:bat[:oid,:int] := 
CMDBATnew(_2:oid, _3:int) {G}
 bat.insert(b,0@0,1);#  2 _4:bat[:oid,:int] := 
BKCinsert_bun(b:bat[:oid,:int], _5:oid, _6:int) {G}
-X_13 := aggr.sum(b);#  3 _13:dbl := 
aggr.sum(b:bat[:oid,:int]) {G}
+X_13 := aggr.sum(b);#  3 _13:dbl := 
CMDBATsum(b:bat[:oid,:int]) {G}
 X_14 := batcalc.+(b,X_13);

MonetDB: Oct2012 - Test_PSmetadata: test for column and paramete...

2012-11-22 Thread Fabian Groffen
Changeset: 59deba53fa55 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=59deba53fa55
Added Files:
java/tests/Test_PSmetadata.java
Modified Files:
java/tests/build.xml
Branch: Oct2012
Log Message:

Test_PSmetadata: test for column and parameter metadata

This test reveals the problem reported in bug #3192


diffs (137 lines):

diff --git a/java/tests/Test_PSmetadata.java b/java/tests/Test_PSmetadata.java
new file mode 100644
--- /dev/null
+++ b/java/tests/Test_PSmetadata.java
@@ -0,0 +1,108 @@
+/*
+ * The contents of this file are subject to the MonetDB Public License
+ * Version 1.1 (the License); you may not use this file except in
+ * compliance with the License. You may obtain a copy of the License at
+ * http://www.monetdb.org/Legal/MonetDBLicense
+ *
+ * Software distributed under the License is distributed on an AS IS
+ * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+ * License for the specific language governing rights and limitations
+ * under the License.
+ *
+ * The Original Code is the MonetDB Database System.
+ *
+ * The Initial Developer of the Original Code is CWI.
+ * Portions created by CWI are Copyright (C) 1997-July 2008 CWI.
+ * Copyright August 2008-2012 MonetDB B.V.
+ * All Rights Reserved.
+ */
+
+import java.sql.*;
+
+public class Test_PSmetadata {
+   public static void main(String[] args) throws Exception {
+   Class.forName(nl.cwi.monetdb.jdbc.MonetDriver);
+   Connection con = DriverManager.getConnection(args[0]);
+   Statement stmt = con.createStatement();
+   PreparedStatement pstmt;
+   ResultSet rs = null;
+   ResultSetMetaData rsmd = null;
+   ParameterMetaData pmd = null;
+
+   con.setAutoCommit(false);
+   //  false: auto commit should be off now
+   System.out.println(0. false\t + con.getAutoCommit());
+
+   try {
+   stmt.executeUpdate(CREATE TABLE table_Test_PSmetadata 
( myint int, mydouble double, mybool boolean, myvarchar varchar(15), myclob 
clob ));
+
+   // all NULLs
+   stmt.executeUpdate(INSERT INTO table_Test_PSmetadata 
VALUES (NULL, NULL,NULL,   NULL,  NULL));
+   // all filled in
+   stmt.executeUpdate(INSERT INTO table_Test_PSmetadata 
VALUES (2   , 3.0, true,   'A string','bla bla 
bla'));
+
+   pstmt = con.prepareStatement(SELECT CASE WHEN myint IS 
NULL THEN 0 ELSE 1 END AS intnull, * FROM table_Test_PSmetadata WHERE myint = 
?);
+
+   rsmd = pstmt.getMetaData();
+
+   System.out.println(0. 6 columns:\t + 
rsmd.getColumnCount());
+   for (int col = 1; col = rsmd.getColumnCount(); col++) {
+   System.out.println( + col + .\t + 
rsmd.getCatalogName(col));
+   System.out.println(\tclassname  + 
rsmd.getColumnClassName(col));
+   System.out.println(\tdisplaysize+ 
rsmd.getColumnDisplaySize(col));
+   System.out.println(\tlabel  + 
rsmd.getColumnLabel(col));
+   System.out.println(\tname   + 
rsmd.getColumnName(col));
+   System.out.println(\ttype   + 
rsmd.getColumnType(col));
+   System.out.println(\ttypename   + 
rsmd.getColumnTypeName(col));
+   System.out.println(\tprecision  + 
rsmd.getPrecision(col));
+   System.out.println(\tscale  + 
rsmd.getScale(col));
+   System.out.println(\tschemaname + 
rsmd.getSchemaName(col));
+   System.out.println(\ttablename  + 
rsmd.getTableName(col));
+   System.out.println(\tautoincrement  + 
rsmd.isAutoIncrement(col));
+   System.out.println(\tcasesensitive  + 
rsmd.isCaseSensitive(col));
+   System.out.println(\tcurrency   + 
rsmd.isCurrency(col));
+   System.out.println(\tdefwritable+ 
rsmd.isDefinitelyWritable(col));
+   System.out.println(\tnullable   + 
rsmd.isNullable(col));
+   System.out.println(\treadonly   + 
rsmd.isReadOnly(col));
+   System.out.println(\tsearchable + 
rsmd.isSearchable(col));
+   System.out.println(\tsigned + 
rsmd.isSigned(col));
+   System.out.println(\twritable   + 
rsmd.isWritable(col));
+   }
+
+   pmd = pstmt.getParameterMetaData();
+   

MonetDB: Oct2012 - PreparedStatement: don't mix up parameters an...

2012-11-22 Thread Fabian Groffen
Changeset: 1e15c1849512 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1e15c1849512
Modified Files:
java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java
Branch: Oct2012
Log Message:

PreparedStatement: don't mix up parameters and columns

PreparedStatements can return metadata for parameters as well as result
columns since Dec2011.  In previous fixes to cope with this, I didn't
quite realise that there is a difference between the two.  We now
properly separate both, such that we don't mistakenly claim a column or
parameter doesn't exist, such as in bug #3192.  This changeset makes
Test_PSmetadata working correctly.


diffs (141 lines):

diff --git a/java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java 
b/java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java
--- a/java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java
+++ b/java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java
@@ -302,7 +302,7 @@ public class MonetPreparedStatement
private int getColumnIdx(int colnr) throws SQLException {
int curcol = 0;
for (int i = 0; i  size; i++) {
-   if (column[i] != null)
+   if (column[i] == null)
continue;
curcol++;
if (curcol == colnr)
@@ -310,6 +310,22 @@ public class MonetPreparedStatement
}
throw new SQLException(No such column with index:  + colnr, 
M1M05);
}
+   /**
+* Returns the index in the backing arrays for the given
+* parameter number
+*/
+   private int getParamIdx(int paramnr) throws SQLException {
+   int curparam = 0;
+   for (int i = 0; i  size; i++) {
+   if (column[i] != null)
+   continue;
+   curparam++;
+   if (curparam == paramnr)
+   return i;
+   }
+   throw new SQLException(No such parameter with index:  + 
paramnr, M1M05);
+   }
+
 
/* helper for the anonymous class inside getMetaData */
private abstract class rsmdw extends MonetWrapper implements 
ResultSetMetaData {}
@@ -695,7 +711,14 @@ public class MonetPreparedStatement
 * @throws SQLException if a database access error 
occurs
 */
public int getParameterCount() throws SQLException {
-   return size;
+   int cnt = 0;
+
+   for (int i = 0; i  size; i++) {
+   if (column[i] == null)
+   cnt++;
+   }
+   
+   return cnt;
}
 
/**
@@ -726,7 +749,7 @@ public class MonetPreparedStatement
public boolean isSigned(int param) throws SQLException {
// we can hardcode this, based on the colum type
// (from ResultSetMetaData.isSigned)
-   switch (javaType[getColumnIdx(param)]) {
+   switch (javaType[getParamIdx(param)]) {
case Types.NUMERIC:
case Types.DECIMAL:
case Types.TINYINT:
@@ -756,7 +779,7 @@ public class MonetPreparedStatement
 * @throws SQLException if a database access error 
occurs
 */
public int getPrecision(int param) throws SQLException {
-   return digits[getColumnIdx(param)];
+   return digits[getParamIdx(param)];
}
 
/**
@@ -768,7 +791,7 @@ public class MonetPreparedStatement
 * @throws SQLException if a database access error 
occurs
 */
public int getScale(int param) throws SQLException {
-   return scale[getColumnIdx(param)];
+   return scale[getParamIdx(param)];
}
 
/**
@@ -779,7 +802,7 @@ public class MonetPreparedStatement
 * @throws SQLException if a database access error 
occurs
 */
public int getParameterType(int param) throws 
SQLException {
-   return javaType[getColumnIdx(param)];
+   return javaType[getParamIdx(param)];
}
 
/**
@@ -793,7 +816,7 @@ public class MonetPreparedStatement
 * @throws 

MonetDB: Oct2012 - JDBC: add ChangeLog entry, and bump version m...

2012-11-22 Thread Fabian Groffen
Changeset: ea88aea191c3 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ea88aea191c3
Modified Files:
java/ChangeLog.Oct2012
java/Makefile.ag
java/build.properties
java/pom.xml
java/release.txt
Branch: Oct2012
Log Message:

JDBC: add ChangeLog entry, and bump version minor


diffs (62 lines):

diff --git a/java/ChangeLog.Oct2012 b/java/ChangeLog.Oct2012
--- a/java/ChangeLog.Oct2012
+++ b/java/ChangeLog.Oct2012
@@ -1,3 +1,8 @@
 # ChangeLog file for java
 # This file is updated with Maddlog
 
+* Thu Nov 22 2012 Fabian Groffen fab...@monetdb.org
+- Fixed a problem in PreparedStatement where the prepared statement's
+  ResultSetMetaData (on its columns to be produced) incorrectly threw
+  exceptions about non existing columns.  Bug #3192
+
diff --git a/java/Makefile.ag b/java/Makefile.ag
--- a/java/Makefile.ag
+++ b/java/Makefile.ag
@@ -27,7 +27,7 @@ JAVA_HOME = @JAVA_HOME@
 ant_distjdbc = {
COND = HAVE_JAVAJDBC
DIR = datadir/monetdb/lib
-   FILES = monetdb-mcl-1.8.jar monetdb-jdbc-2.7.jar jdbcclient.jar
+   FILES = monetdb-mcl-1.8.jar monetdb-jdbc-2.8.jar jdbcclient.jar
 }
 
 ant_distmerocontrol = {
diff --git a/java/build.properties b/java/build.properties
--- a/java/build.properties
+++ b/java/build.properties
@@ -19,7 +19,7 @@ MCL_MINOR=8
 # major release number
 JDBC_MAJOR=2
 # minor release number
-JDBC_MINOR=7
+JDBC_MINOR=8
 # an additional identifying string
 JDBC_VER_SUFFIX=Liberica
 # the default port to connect on, if no port given when using SQL
diff --git a/java/pom.xml b/java/pom.xml
--- a/java/pom.xml
+++ b/java/pom.xml
@@ -6,7 +6,7 @@
modelVersion4.0.0/modelVersion
groupIdmonetdb/groupId
artifactIdmonetdb-jdbc/artifactId
-   version2.7/version
+   version2.8/version
namemonetdb-jdbc/name
descriptionMonetDB JDBC driver/description
repositories
diff --git a/java/release.txt b/java/release.txt
--- a/java/release.txt
+++ b/java/release.txt
@@ -1,8 +1,8 @@
 RELEASE NOTES
-MonetDB JDBC driver version 2.7 (Liberica/MCL-1.8)
+MonetDB JDBC driver version 2.8 (Liberica/MCL-1.8)
 Fabian Groffen fabian.grof...@cwi.nl
 
-Release date: 2012-11-02
+Release date: 2012-11-22
 
 
 This JDBC driver is designed for use with MonetDB, a main-memory
___
checkin-list mailing list
checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list


MonetDB: Oct2012 - Add Mtest for bug #3192

2012-11-22 Thread Fabian Groffen
Changeset: e4a6b9edf48f for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e4a6b9edf48f
Added Files:
sql/jdbc/tests/Tests/Test_PSmetadata.SQL.bat
sql/jdbc/tests/Tests/Test_PSmetadata.SQL.sh
sql/jdbc/tests/Tests/Test_PSmetadata.stable.err
sql/jdbc/tests/Tests/Test_PSmetadata.stable.out
Modified Files:
sql/jdbc/tests/Tests/All
Branch: Oct2012
Log Message:

Add Mtest for bug #3192


diffs (265 lines):

diff --git a/sql/jdbc/tests/Tests/All b/sql/jdbc/tests/Tests/All
--- a/sql/jdbc/tests/Tests/All
+++ b/sql/jdbc/tests/Tests/All
@@ -13,6 +13,7 @@ HAVE_JDBCTESTS?Test_PStimedate
 HAVE_JDBCTESTS?Test_PStimezone
 HAVE_JDBCTESTS?Test_PStypes
 HAVE_JDBCTESTS?Test_PSmanycon
+HAVE_JDBCTESTS?Test_PSmetadata
 HAVE_JDBCTESTS?Test_Rbooleans
 HAVE_JDBCTESTS?Test_Rmetadata
 HAVE_JDBCTESTS?Test_Rpositioning
diff --git a/sql/jdbc/tests/Tests/Test_PSmetadata.SQL.bat 
b/sql/jdbc/tests/Tests/Test_PSmetadata.SQL.bat
new file mode 100755
--- /dev/null
+++ b/sql/jdbc/tests/Tests/Test_PSmetadata.SQL.bat
@@ -0,0 +1,1 @@
+@call %TSTSRCDIR%\Test.SQL.bat %*
diff --git a/sql/jdbc/tests/Tests/Test_PSmetadata.SQL.sh 
b/sql/jdbc/tests/Tests/Test_PSmetadata.SQL.sh
new file mode 100755
--- /dev/null
+++ b/sql/jdbc/tests/Tests/Test_PSmetadata.SQL.sh
@@ -0,0 +1,3 @@
+#!/bin/sh
+
+$TSTSRCDIR/Test.SQL.sh $*
diff --git a/sql/jdbc/tests/Tests/Test_PSmetadata.stable.err 
b/sql/jdbc/tests/Tests/Test_PSmetadata.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/jdbc/tests/Tests/Test_PSmetadata.stable.err
@@ -0,0 +1,41 @@
+stderr of test 'Test_PSmetadata` in directory 'jdbc/tests` itself:
+
+
+# 13:52:42   
+# 13:52:42   mserver5 --debug=10 --set gdk_nr_threads=0 --set 
gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-Oct2012-sofia.ins.cwi.nl/sql/dbfarm
 --set mapi_open=true --set mapi_port=32363 --set monet_prompt= 
--trace --forcemito --set mal_listing=2 --dbname=mTests_jdbc_tests 
--set mal_listing=0
+# 13:52:42   
+
+# builtin opt  gdk_dbname = demo
+# builtin opt  gdk_dbfarm = 
/ufs/fabian/scratch/ssd/monetdb/Oct2012/program-x86_64/var/lib/monetdb5/dbfarm
+# builtin opt  gdk_debug = 0
+# builtin opt  gdk_vmtrim = yes
+# builtin opt  monet_prompt = 
+# builtin opt  monet_daemon = no
+# builtin opt  mapi_port = 5
+# builtin opt  mapi_open = false
+# builtin opt  mapi_autosense = false
+# builtin opt  sql_optimizer = default_pipe
+# builtin opt  sql_debug = 0
+# cmdline opt  gdk_nr_threads = 0
+# cmdline opt  gdk_dbfarm = 
/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-Oct2012-sofia.ins.cwi.nl/sql/dbfarm
+# cmdline opt  mapi_open = true
+# cmdline opt  mapi_port = 32363
+# cmdline opt  monet_prompt = 
+# cmdline opt  mal_listing = 2
+# cmdline opt  gdk_dbname = mTests_jdbc_tests
+# cmdline opt  mal_listing = 0
+
+# 13:52:42   
+# 13:52:42   ./Test_PSmetadata.SQL.sh Test_PSmetadata
+# 13:52:42   
+
+
+# 13:52:42   
+# 13:52:42   java Test_PSmetadata 
jdbc:monetdb://sofia:32363/mTests_jdbc_tests?user=monetdbpassword=monetdb
+# 13:52:42   
+
+
+# 13:52:43   
+# 13:52:43   Done.
+# 13:52:43   
+
diff --git a/sql/jdbc/tests/Tests/Test_PSmetadata.stable.out 
b/sql/jdbc/tests/Tests/Test_PSmetadata.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/jdbc/tests/Tests/Test_PSmetadata.stable.out
@@ -0,0 +1,189 @@
+stdout of test 'Test_PSmetadata` in directory 'jdbc/tests` itself:
+
+
+# 13:52:42   
+# 13:52:42   mserver5 --debug=10 --set gdk_nr_threads=0 --set 
gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-Oct2012-sofia.ins.cwi.nl/sql/dbfarm
 --set mapi_open=true --set mapi_port=32363 --set monet_prompt= 
--trace --forcemito --set mal_listing=2 --dbname=mTests_jdbc_tests 
--set mal_listing=0
+# 13:52:42   
+
+# MonetDB 5 server v11.13.4 Oct2012-7f942d4b43a5
+# Serving database 'mTests_jdbc_tests', using 8 threads
+# Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
+# Found 15.629 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://sofia.ins.cwi.nl:32363/
+# MonetDB/GIS module loaded
+# MonetDB/JAQL module loaded
+# MonetDB/SQL module loaded
+
+Ready.
+# SQL catalog created, loading sql scripts once
+# loading sql script: 09_like.sql
+# loading sql script: 10_math.sql
+# loading sql script: 11_times.sql
+# loading sql script: 12_url.sql
+# loading sql script: 13_date.sql
+# loading sql script: 14_inet.sql
+# loading sql script: 15_history.sql
+# loading sql script: 16_tracelog.sql
+# loading sql script: 17_compress.sql
+# loading sql script: 18_dictionary.sql
+# loading sql script: 19_cluster.sql
+# loading sql script: 20_vacuum.sql
+# loading sql script: 21_dependency_functions.sql
+# loading sql script: 22_clients.sql
+# loading sql script: 23_skyserver.sql
+# loading sql script: 24_zorder.sql
+# loading sql script: 25_debug.sql
+# 

MonetDB: Oct2012 - Fixed package names for Debuntu library packa...

2012-11-22 Thread Sjoerd Mullender
Changeset: c499d3d79ef6 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c499d3d79ef6
Added Files:
debian/libmonetdb-client6.install
debian/libmonetdb8.install
Removed Files:
debian/libmonetdb-client5.install
debian/libmonetdb6.install
Modified Files:
debian/control
Branch: Oct2012
Log Message:

Fixed package names for Debuntu library packages.
The number at the end of the package name should be the major version
number of the library.


diffs (44 lines):

diff --git a/debian/control b/debian/control
--- a/debian/control
+++ b/debian/control
@@ -14,7 +14,7 @@ Standards-Version: 3.8.0
 X-Python-Version: = 2.6
 X-Python3-Version: = 3.0
 
-Package: libmonetdb6
+Package: libmonetdb8
 Architecture: any
 Depends: ${shlibs:Depends}, ${misc:Depends}
 Conflicts: libmonetdb1, libmonetdb2, libmonetdb-dev
@@ -55,7 +55,7 @@ Description: MonetDB stream library deve
  This package contains the files to develop with the
  libmonetdb-stream3 library.
 
-Package: libmonetdb-client5
+Package: libmonetdb-client6
 Architecture: any
 Depends: ${shlibs:Depends}, ${misc:Depends}
 Conflicts: libmonetdb-client1, libmonetdb-client2
@@ -71,14 +71,14 @@ Description: MonetDB client/server inter
 
 Package: libmonetdb-client-dev
 Architecture: any
-Depends: ${shlibs:Depends}, ${misc:Depends}, libmonetdb-client5
+Depends: ${shlibs:Depends}, ${misc:Depends}, libmonetdb-client6
 Description: MonetDB client/server interface library development files
  MonetDB is a database management system that is developed from a
  main-memory perspective with use of a fully decomposed storage model,
  automatic index management, extensibility of data types and search
  accelerators.  It also has an SQL frontend.
  .
- This package contains the files to develop with the libmonetdb-client5
+ This package contains the files to develop with the libmonetdb-client6
  library.
 
 Package: monetdb-client
diff --git a/debian/libmonetdb-client5.install 
b/debian/libmonetdb-client6.install
rename from debian/libmonetdb-client5.install
rename to debian/libmonetdb-client6.install
diff --git a/debian/libmonetdb6.install b/debian/libmonetdb8.install
rename from debian/libmonetdb6.install
rename to debian/libmonetdb8.install
___
checkin-list mailing list
checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list