Bugs item #1640213, was opened at 2007-01-20 12:59
Message generated for change (Comment added) made by nielsnes
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: Closed
>Resolution: Fixed
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
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2007-02-02 08:20
Message:
Logged In: YES
user_id=43556
Originator: NO
The tests no longer fail, ie closing. The sql module now checks if the
pcre module exists, if not it falls back to a monet internal
like implementation.
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2007-01-25 17:07
Message:
Logged In: YES
user_id=1498628
Originator: NO
Is there any test to cover this bug?
Regards,
Romulo
----------------------------------------------------------------------
Comment By: Martin Kersten (mlkersten)
Date: 2007-01-20 13:43
Message:
Logged In: YES
user_id=490798
Originator: NO
There is a discrepancy in the definition of LIKE and PCRE
as it concerns with the wildcard character matching.
The standard should be checked for the definition of LIKE.
It is a result of changes in r1.210, 22-10-2006, nielsnes
sql.gencode should reverse the call from pcre to batstrRef
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1640213&group_id=56967
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
