Update of /cvsroot/monetdb/sql/src/test/rdf/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv3679/src/test/rdf/Tests
Added Files:
Tag: Feb2010
q4_28_t.sql
Log Message:
propagated changes of Friday Jan 15 2010 - Monday Jan 18 2010
from the Nov2009 branch to the Feb2010 branch
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/01/15 - romulog: src/test/rdf/Tests/q4_28_t.sql,1.1.2.1
Add a test to cover the schema and queries for rdf used in vldb2008.
It seems 4 of them got broken... in the last release...
Like this we make sure we support the queries syntax...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: q4_28_t.sql ---
--Query4:
SELECT B.prop, B.obj, count(*)
FROM triples_pso AS A,
triples_pso AS B,
triples_pso AS C
WHERE A.subj = B.subj
AND A.prop = 17582582
AND A.obj = 14660332
-- AND A.prop = '<type>'
-- AND A.obj = '<Text>'
AND B.prop in (
14657017,
14657018,
14657019,
14657202,
14657206,
14657207,
14657210,
14657214,
14657215,
14657217,
14657220,
14657222,
14657234,
14657240,
14657244,
14657248,
14659533,
14659603,
14659613,
14659708,
14659801,
14659802,
14659939,
14660087,
14660290,
14660306,
14660329,
17582582)
AND C.subj = B.subj
AND C.prop = 14659603
AND C.obj = 17106461
-- AND C.prop = '<language>'
-- AND C.obj = '<language/iso639-2b/fre>'
GROUP BY B.prop, B.obj
HAVING count(*) > 1;
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
