Bugs item #2839103, was opened at 2009-08-17 19:00
Message generated for change (Comment added) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2839103&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL "stable"
Status: Open
Resolution: None
Priority: 6
Private: No
Submitted By: Stefan Manegold (stmane)
>Assigned to: Stefan Manegold (stmane)
Summary: SQL: property errors: BAT incorrectly marked nonil
Initial Comment:
With BAT property checking (re-)enabled in the M5 MAL interpreter,
the following SQL tests fail with property errors:
sql/src/test/BugDay_2005-10-06_2.9.3/Tests/case.SF-929151.sql:
"
QUERY = select case i
ERROR = !MALException:mal.propertyCheck:Object not found
!ERROR: BATpropcheck: BAT tmpr_2432(-1306)[str,void] with 5 tuples was
incorrectly marked nonil!
"
sql/src/odbc/samples/Tests/odbcsample1.SQL.sh:
"
SQLColumns: Error: SQLstate HY000, Errnr 0, Message [MonetDB][ODBC Driver
1.0]!MALException:mal.propertyCheck:Object not found
"
----------------------------------------------------------------------
>Comment By: Stefan Manegold (stmane)
Date: 2009-08-18 23:17
Message:
Hopefully mostly fixed by
===================================================================
2009/08/18 - stmane: MonetDB5/src/modules/kernel/batcalc.mx,1.181.2.3
MonetDB5/src/modules/kernel/batcast.mx,1.27.4.1
unset nonil whenever we insert a nil into the result
(and only then);
this fixes some of the "!ERROR: BATpropcheck: BAT ... was incorrectly
marked nonil!"
reported in ID: 2839103 "SQL: property errors: BAT incorrectly marked
nonil"
https://sourceforge.net/tracker/?func=detail&aid=2839103&group_id=56967&atid=482468
===================================================================
2009/08/18 - stmane: MonetDB5/src/modules/kernel/batifthen.mx,1.24.4.1
fixed nil-check for strings
this fixes some more of the "!ERROR: BATpropcheck: BAT ... was incorrectly
marked nonil!"
reported in ID: 2839103 "SQL: property errors: BAT incorrectly marked
nonil"
https://sourceforge.net/tracker/?func=detail&aid=2839103&group_id=56967&atid=482468
===================================================================
tonight's testing will reveal the details ...
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2009-08-18 18:09
Message:
Nightly testing revealed more SQL test that trigger BAT property checking
errors,
all of them complaining about
!ERROR: BATpropcheck: BAT ... was incorrectly marked nonil!
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_odbc_samples/odbcsample1.err.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugDay_2005-10-06_2.9.3/case.SF-929151.err.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_jdbc_tests/Test_JdbcClient.err.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugDay_2005-10-06_2.9.3/alter_table_describe.SF-1146092.err.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugDay_2005-10-06_2.9.3/not_null.SF-933194.err.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugDay_2005-10-06_2.9.3/type_dump_test.SF-989257.err.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.32.32.d.1-Fedora10/src_test_BugTracker-2008/insert_into_unique_column.SF-2075180.err.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.32.d.1-Fedora10/src_test_BugDay_2005-10-06_2.9.3/div_by_zero.SF-987304.err.00.html
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2839103&group_id=56967
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
