On Sat, Oct 06, 2007 at 11:00:31PM +0200, Fabian Groffen wrote: > Hi Jan, > > Thanks for your bug report. > > > On 06-10-2007 20:08:57 +0200, Schaffner, Jan wrote: > > Hi, > > > > When using prepared statements in Java, I am unable to pass negative > > integer values to the database: > > > > String APPEND_JOURNAL = "INSERT INTO journal VALUES (?, ?);"; > > st = con.prepareStatement(APPEND_JOURNAL); > > st.setInt(1, fromAcc); > > st.setInt(2, -amount); > > st.executeUpdate(); > > > > The table "journal" has two columns: account (int) and amount (bigint). > > > > The insert statement executes without error, but inserts the positive > > value (+amount, cf. line 4). The debugger, in contrast, says something > > like "exec 3(200, -30)". Note that is has a minus in front of the > > second parameter. > > What exactly do you mean with "the debugger" here? Is this the JDBC > log, or some other application? > > In case this "exec 3(200, -30)" comes from the JDBC log, then this is a > bug in the SQL backend, as JDBC appears to send over the correct number.
Indeed the exec doesn't like negatives currently. Working on a fix. Niels > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Monetdb-bugs mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-bugs -- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: [EMAIL PROTECTED] ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
