Update of /cvsroot/monetdb/sql/src/test/rdf/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv10424/src/test/rdf/Tests
Added Files:
q3_28_v.sql
Log Message:
propagated changes of Friday Jan 15 2010 - Monday Jan 18 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/01/15 - sjoerd: src/test/rdf/Tests/q3_28_v.sql,1.1.4.1
file q3_28_v.sql was added on branch Feb2010 on 2010-01-18 10:42:00 +0000
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/01/18 - sjoerd: src/test/rdf/Tests/q3_28_v.sql,1.1.4.2
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/q3_28_v.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: q3_28_v.sql ---
WITH A(subj, obj) as (SELECT * FROM prop17582582_pso where obj = 14660332)
SELECT prop, obj, cnt from (
( SELECT 'prop14657017_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657017_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657018_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657018_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657019_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657019_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657202_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657202_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657206_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657206_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657207_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657207_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657210_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657210_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657214_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657214_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657215_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657215_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657217_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657217_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657220_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657220_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657222_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657222_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657234_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657234_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657240_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657240_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657244_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657244_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14657248_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14657248_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14659533_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14659533_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14659603_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14659603_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14659613_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14659613_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14659708_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14659708_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14659801_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14659801_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14659802_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14659802_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14659939_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14659939_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14660087_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14660087_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14660290_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14660290_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14660306_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14660306_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop14660329_pso' as prop, B.obj, count(*) as cnt
FROM A, prop14660329_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
UNION ALL
( SELECT 'prop17582582_pso' as prop, B.obj, count(*) as cnt
FROM A, prop17582582_pso as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
) as trip;
------------------------------------------------------------------------------
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
