Bugs item #1640213, was opened at 2007-01-20 13:59 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1640213&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 CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Stefan Manegold (stmane)
Assigned to: Niels Nes (nielsnes)
Summary: SQL-5: LIKE / PCRE selects fail
Initial Comment:
With the MonetDB5 backend, many (if not all?) LIKE & PCRE-based selects fail
(couldn't find since when; they probably never worked).
sample error:
========
=QUERY = INSERT INTO _t29 SELECT * from Individual WHERE (Individual.PersonName
LIKE '%Spielberg%');
ERROR =chop.newChunkMoreElements: Cannot access 'bid' descriptor
# the original non-normalized output was: ERROR =
!MALException:chop.newChunkMoreElements:Cannot access 'bid' descriptor
sql_cache.s0_1[56]: Exception not catched
# the original non-normalized output was:
!MALException:sql_cache.s0_1[56]:Exception not catched
========
=QUERY = select first_name, surname, date from victim where date LIKE
'%survived%';
ERROR =pcre.select: Library missing
# the original non-normalized output was: ERROR =
!MALException:pcre.select:Library missing
========
cf. e.g.,
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_benchmarks_moa/moa_ordered.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_benchmarks_tpch/02.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_benchmarks_tpch/09.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_benchmarks_tpch/13.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_benchmarks_tpch/14.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_benchmarks_tpch/16.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_benchmarks_tpch/20.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_benchmarks_tpch/01-22.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test/like_tests.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test_ADT2006/benesamo.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test_ADT2006/bram.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test_ADT2006/slam.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test_ADT2006/woud.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test_BugDay_2005-12-19_2.9.3/prepare_doesnot_like_LIKE.SF-1234205.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test_BugTracker/insert_values.SF-1578838.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test_BugTracker/like_exp.SF-1613949.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test_bugs/like-bug-sf-1031435.err.00.html
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test_leaks/check0.err.00.html
...
http://monetdb.cwi.nl/testing/intern/monetdb/Current/_intern_/sql5/.mTests103/GNU.64.64.d-SuSE9.3/src_test_leaks/check5.err.00.html
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1640213&group_id=56967
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
