/* invalid foreign server option 'foo' ins't a valid endpoint URL */ CREATE SERVER rdfserver_error1 FOREIGN DATA WRAPPER rdf_fdw OPTIONS ( endpoint 'foo' ); ERROR: invalid endpoint: 'foo' /* empty foreign server option empty endpoints are not allowed */ CREATE SERVER rdfserver_error2 FOREIGN DATA WRAPPER rdf_fdw OPTIONS ( endpoint '' ); ERROR: empty value in option 'endpoint' /* invalid enable_pushdown value */ CREATE SERVER rdfserver_error3 FOREIGN DATA WRAPPER rdf_fdw OPTIONS ( endpoint 'https://dbpedia.org/sparql', enable_pushdown 'foo' ); ERROR: invalid enable_pushdown: 'foo' HINT: this parameter expects boolean values ('true' or 'false') /* invalid fetch_size nevative fetch_size */ CREATE SERVER rdfserver_error4 FOREIGN DATA WRAPPER rdf_fdw OPTIONS ( endpoint 'https://dbpedia.org/sparql', fetch_size '-1' ); ERROR: invalid fetch_size: '-1' HINT: expected values are positive integers /* invalid fetch_size empty string */ CREATE SERVER rdfserver_error5 FOREIGN DATA WRAPPER rdf_fdw OPTIONS ( endpoint 'https://dbpedia.org/sparql', fetch_size '' ); ERROR: empty value in option 'fetch_size' CREATE SERVER testserver FOREIGN DATA WRAPPER rdf_fdw OPTIONS (endpoint 'https://dbpedia.org/sparql'); /* invalid colum option OPTION 'foo' does not exist */ CREATE FOREIGN TABLE table_error1 ( name text OPTIONS (foo '?s') ) SERVER testserver OPTIONS (sparql 'SELECT * WHERE {?s ?p ?o}'); ERROR: invalid rdf_fdw option 'foo' /* empty colum option the column OPTION 'variable' cannot be empty. */ CREATE FOREIGN TABLE table_error2 ( name text OPTIONS (variable '') ) SERVER testserver OPTIONS (sparql 'SELECT * WHERE {?s ?p ?o}'); ERROR: empty value in option 'variable' /* invalid foreign table option SERVER option 'foo' does not exist. */ CREATE FOREIGN TABLE table_error3 ( name text OPTIONS (variable '?s') ) SERVER testserver OPTIONS (foo 'SELECT * WHERE {?s ?p ?o}'); ERROR: invalid rdf_fdw option 'foo' /* invalid foreign table option SPARQL variable '?foo' does not exist in the SPARQL query. the query will return only empty rows. */ CREATE FOREIGN TABLE table_error4 ( name text OPTIONS (variable '?foo') ) SERVER testserver OPTIONS (log_sparql 'true', sparql 'SELECT * WHERE {?s ?p ?o}'); SELECT * FROM table_error4 LIMIT 3; INFO: SPARQL query sent to 'https://dbpedia.org/sparql': SELECT ?foo {?s ?p ?o} LIMIT 3 name ------ (3 rows) /* invalid foreign table option log_sparql must be boolean */ CREATE FOREIGN TABLE table_error5 ( name text OPTIONS (variable '?s') ) SERVER testserver OPTIONS (sparql 'SELECT * WHERE {?s ?p ?o}', log_sparql 'foo'); ERROR: invalid log_sparql: 'foo' HINT: this parameter expects boolean values ('true' or 'false') /* INSERT, UPDATE and DELETE not supported */ CREATE SERVER testserver2 FOREIGN DATA WRAPPER rdf_fdw OPTIONS ( endpoint 'https://dbpedia.org/sparql' ); CREATE FOREIGN TABLE t1 ( name text OPTIONS (variable '?s') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s WHERE {?s ?p ?o} LIMIT 1', log_sparql 'true'); INSERT INTO t1 (name) VALUES ('foo'); ERROR: cannot insert into foreign table "t1" UPDATE t1 SET name = 'foo'; ERROR: cannot update foreign table "t1" DELETE FROM t1; ERROR: cannot delete from foreign table "t1" /* EXPLAIN isn't supported*/ EXPLAIN SELECT * FROM t1; QUERY PLAN ------------------------------------------------------------------ Foreign Scan on t1 (cost=10000.00..20000.00 rows=1000 width=32) (1 row) /* invalid relation. an existing sequence is used instead of a relation on 'target_table', so the oid retrieval will not fail. it has to check if the oid corresponds to a relation and throw an error otherwise. */ CREATE SEQUENCE seq1; CALL rdf_fdw_clone_table( foreign_table => 't1', target_table => 'seq1' ); ERROR: invalid relation: 'seq1' is not a table /* invalid SPARQL - missing closing curly braces (\n)*/ CREATE FOREIGN TABLE t2 (s text OPTIONS (variable '?s') ) SERVER testserver2 OPTIONS (sparql ' SELECT ?s {?s ?p ?o '); ERROR: unable to parse SPARQL WHERE clause: SELECT ?s {?s ?p ?o HINT: The WHERE clause expects at least one triple pattern wrapped by curly braces, e.g. '{?s ?p ?o}' /* invalid SPARQL - missing closing curly braces */ CREATE FOREIGN TABLE t3 (s text OPTIONS (variable '?s') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o'); ERROR: unable to parse SPARQL WHERE clause: SELECT ?s {?s ?p ?o HINT: The WHERE clause expects at least one triple pattern wrapped by curly braces, e.g. '{?s ?p ?o}' /* invalid SPARQL - missing closing curly braces (\t) */ CREATE FOREIGN TABLE t4 (s text OPTIONS (variable '?s') ) SERVER testserver2 OPTIONS (sparql ' SELECT ?s {?s ?p ?o'); ERROR: unable to parse SPARQL WHERE clause: SELECT ?s {?s ?p ?o HINT: The WHERE clause expects at least one triple pattern wrapped by curly braces, e.g. '{?s ?p ?o}' /* invalid SPARQL - missing opening curly braces (\n)*/ CREATE FOREIGN TABLE t5 (s text OPTIONS (variable '?s') ) SERVER testserver2 OPTIONS (sparql ' SELECT ?s ?s ?p ?o}'); ERROR: unable to parse SPARQL WHERE clause: SELECT ?s ?s ?p ?o} HINT: The WHERE clause expects at least one triple pattern wrapped by curly braces, e.g. '{?s ?p ?o}' /* empty WHERE clause */ CREATE FOREIGN TABLE t6 (s text OPTIONS (variable '?s') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {}'); SELECT * FROM t6; s --- (1 row) /* missing SELECT */ CREATE FOREIGN TABLE t7 (s text OPTIONS (variable '?s') ) SERVER testserver2 OPTIONS (sparql '?s {?s ?p ?o}'); ERROR: unable to parse SPARQL SELECT clause: ?s {?s ?p ?o}. /* empty nodetype */ CREATE FOREIGN TABLE t7 (s text OPTIONS (variable '?s', nodetype '') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}'); ERROR: empty value in option 'nodetype' /* invalid nodetype */ CREATE FOREIGN TABLE t7 (s text OPTIONS (variable '?s', nodetype 'foo') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}'); ERROR: invalid nodetype: 'foo' HINT: this parameter expects node types ('iri' or 'literal') /* invalid literaltype - contains whitespaces */ CREATE FOREIGN TABLE t7 (s text OPTIONS (variable '?s', literaltype ' xsd:string') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}'); ERROR: invalid literaltype: ' xsd:string' HINT: whitespaces are not allwoed in 'literaltype' option /* invalid language - contains whitespaces */ CREATE FOREIGN TABLE t7 (s text OPTIONS (variable '?s', language 'de ') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}'); ERROR: invalid language: 'de ' HINT: whitespaces are not allwoed in 'language' option /* invalid combination of 'literaltype' and 'language' */ CREATE FOREIGN TABLE t8 (s text OPTIONS (variable '?s', literaltype 'iri', language 'es') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}'); ERROR: invalid language: 'es' HINT: the parameters 'literaltype' and 'language' cannot be combined /* invalid 'variable' */ CREATE FOREIGN TABLE t9 (s text OPTIONS (variable 's', expression 'now()') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}'); ERROR: invalid variable: 's' HINT: a query variable must start with either "?" or "$"; the "?" or "$" is not part of the variable name. Allowable characters for the name are [a-z], [A-Z], [0-9], _ and diacrictics. /* invalid 'variable' */ CREATE FOREIGN TABLE t10 (s text OPTIONS (variable '?a-z', expression 'now()') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}'); ERROR: invalid variable: '?a-z' HINT: a query variable must start with either "?" or "$"; the "?" or "$" is not part of the variable name. Allowable characters for the name are [a-z], [A-Z], [0-9], _ and diacrictics. /* invalid 'variable' */ CREATE FOREIGN TABLE t11 (s text OPTIONS (variable '?a$z', expression 'now()') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}'); ERROR: invalid variable: '?a$z' HINT: a query variable must start with either "?" or "$"; the "?" or "$" is not part of the variable name. Allowable characters for the name are [a-z], [A-Z], [0-9], _ and diacrictics. /* invalid 'variable' */ CREATE FOREIGN TABLE t12 (s text OPTIONS (variable '?a?z', expression 'now()') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}'); ERROR: invalid variable: '?a?z' HINT: a query variable must start with either "?" or "$"; the "?" or "$" is not part of the variable name. Allowable characters for the name are [a-z], [A-Z], [0-9], _ and diacrictics. /* invalid 'variable' */ CREATE FOREIGN TABLE t13 (s text OPTIONS (variable ' ?a', expression 'now()') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}'); ERROR: invalid variable: ' ?a' HINT: a query variable must start with either "?" or "$"; the "?" or "$" is not part of the variable name. Allowable characters for the name are [a-z], [A-Z], [0-9], _ and diacrictics. /* invalid foreign table option fetch_size empty */ CREATE FOREIGN TABLE t14 ( name text OPTIONS (variable '?s') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}', fetch_size ''); ERROR: empty value in option 'fetch_size' /* invalid foreign table option fetch_size negative */ CREATE FOREIGN TABLE t15 ( name text OPTIONS (variable '?s') ) SERVER testserver2 OPTIONS (sparql 'SELECT ?s {?s ?p ?o}', fetch_size '-1'); ERROR: invalid fetch_size: '-1' HINT: expected values are positive integers /* empty user name */ CREATE USER MAPPING FOR postgres SERVER testserver2 OPTIONS (user '', password 'foo'); ERROR: empty value in option 'user' /* empty password */ CREATE USER MAPPING FOR postgres SERVER testserver2 OPTIONS (user 'foo', password ''); ERROR: empty value in option 'password' /* invalid option */ CREATE USER MAPPING FOR postgres SERVER testserver2 OPTIONS (user 'jim', foo 'bar'); ERROR: invalid rdf_fdw option 'foo' DROP SEQUENCE seq1; DROP FOREIGN TABLE IF EXISTS t1;