You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@madlib.apache.org by ok...@apache.org on 2017/08/29 20:42:21 UTC
[44/50] [abbrv] incubator-madlib git commit: Multiple: Add quoted
input params for tests
Multiple: Add quoted input params for tests
This commit updates install-check tests to use quoted string inputs.
Project: http://git-wip-us.apache.org/repos/asf/incubator-madlib/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-madlib/commit/f1aa9af6
Tree: http://git-wip-us.apache.org/repos/asf/incubator-madlib/tree/f1aa9af6
Diff: http://git-wip-us.apache.org/repos/asf/incubator-madlib/diff/f1aa9af6
Branch: refs/heads/latest_release
Commit: f1aa9af6271fa3abdae4e73f5bda4c8cc7912947
Parents: f63adda
Author: Rahul Iyer <ri...@apache.org>
Authored: Wed Aug 16 22:16:03 2017 -0700
Committer: Rahul Iyer <ri...@apache.org>
Committed: Fri Aug 18 16:29:15 2017 -0700
----------------------------------------------------------------------
methods/sketch/src/pg_gp/sql/cm.sql_in | 22 +++---
methods/sketch/src/pg_gp/sql/fm.sql_in | 16 ++---
methods/sketch/src/pg_gp/sql/mfv.sql_in | 6 +-
.../postgres/modules/convex/test/mlp.sql_in | 26 ++++----
.../postgres/modules/graph/test/apsp.sql_in | 32 ++++-----
.../postgres/modules/graph/test/bfs.sql_in | 70 ++++++++++----------
.../postgres/modules/graph/test/measures.sql_in | 34 +++++-----
.../postgres/modules/graph/test/pagerank.sql_in | 14 ++--
.../postgres/modules/graph/test/sssp.sql_in | 24 +++----
.../postgres/modules/graph/test/wcc.sql_in | 12 ++--
src/ports/postgres/modules/knn/test/knn.sql_in | 18 ++---
.../sample/test/stratified_sample.sql_in | 18 ++---
.../modules/utilities/test/pivot.sql_in | 14 ++--
.../modules/utilities/test/sessionize.sql_in | 8 ++-
14 files changed, 159 insertions(+), 155 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/methods/sketch/src/pg_gp/sql/cm.sql_in
----------------------------------------------------------------------
diff --git a/methods/sketch/src/pg_gp/sql/cm.sql_in b/methods/sketch/src/pg_gp/sql/cm.sql_in
index f7ab910..2731c56 100644
--- a/methods/sketch/src/pg_gp/sql/cm.sql_in
+++ b/methods/sketch/src/pg_gp/sql/cm.sql_in
@@ -18,16 +18,16 @@ declare
begin
-- DROP TABLE IF EXISTS data;
- CREATE TABLE cm_data(class INT, a1 INT);
- INSERT INTO cm_data SELECT 1,1 FROM generate_series(1,10000);
- INSERT INTO cm_data SELECT 1,2 FROM generate_series(1,15000);
- INSERT INTO cm_data SELECT 1,3 FROM generate_series(1,10000);
- INSERT INTO cm_data SELECT 2,5 FROM generate_series(1,1000);
- INSERT INTO cm_data SELECT 2,6 FROM generate_series(1,1000);
+ CREATE TABLE "CM_DATA"(class INT, a1 INT);
+ INSERT INTO "CM_DATA" SELECT 1,1 FROM generate_series(1,10000);
+ INSERT INTO "CM_DATA" SELECT 1,2 FROM generate_series(1,15000);
+ INSERT INTO "CM_DATA" SELECT 1,3 FROM generate_series(1,10000);
+ INSERT INTO "CM_DATA" SELECT 2,5 FROM generate_series(1,1000);
+ INSERT INTO "CM_DATA" SELECT 2,6 FROM generate_series(1,1000);
-- DROP TABLE IF EXISTS result_table;
CREATE TABLE cm_result_table AS
- SELECT (MADLIB_SCHEMA.cmsketch_count(MADLIB_SCHEMA.cmsketch(a1),2)) as val FROM cm_data GROUP BY class ORDER BY class;
+ SELECT (MADLIB_SCHEMA.cmsketch_count(MADLIB_SCHEMA.cmsketch(a1),2)) as val FROM "CM_DATA" GROUP BY class ORDER BY class;
SELECT array( SELECT val FROM cm_result_table) INTO result;
IF ((result[1] + result[2]) != 15000) THEN
@@ -36,7 +36,7 @@ begin
TRUNCATE cm_result_table;
INSERT INTO cm_result_table
- SELECT MADLIB_SCHEMA.cmsketch_rangecount(MADLIB_SCHEMA.cmsketch(a1),3,6) FROM cm_data GROUP BY class ORDER BY class;
+ SELECT MADLIB_SCHEMA.cmsketch_rangecount(MADLIB_SCHEMA.cmsketch(a1),3,6) FROM "CM_DATA" GROUP BY class ORDER BY class;
SELECT array( SELECT val FROM cm_result_table) INTO result;
IF (result[1] + result[2] != 12000) THEN
@@ -44,13 +44,13 @@ begin
END IF;
TRUNCATE cm_result_table;
- SELECT MADLIB_SCHEMA.cmsketch_centile(MADLIB_SCHEMA.cmsketch(a1),90,count(*)) INTO result2 FROM cm_data;
+ SELECT MADLIB_SCHEMA.cmsketch_centile(MADLIB_SCHEMA.cmsketch(a1),90,count(*)) INTO result2 FROM "CM_DATA";
IF result2 != 3 THEN
RAISE EXCEPTION 'Incorrect cmsketch_centile results, got %',result2;
END IF;
- PERFORM MADLIB_SCHEMA.cmsketch_width_histogram(MADLIB_SCHEMA.cmsketch(a1),0,10,2) FROM cm_data;
- PERFORM MADLIB_SCHEMA.cmsketch_depth_histogram(MADLIB_SCHEMA.cmsketch(a1),2) FROM cm_data;
+ PERFORM MADLIB_SCHEMA.cmsketch_width_histogram(MADLIB_SCHEMA.cmsketch(a1),0,10,2) FROM "CM_DATA";
+ PERFORM MADLIB_SCHEMA.cmsketch_depth_histogram(MADLIB_SCHEMA.cmsketch(a1),2) FROM "CM_DATA";
-- SELECT class,fmsketch_dcount(a1) FROM cm_data GROUP BY class;
-- SELECT mfvsketch_top_histogram(a1,5) FROM cm_data;
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/methods/sketch/src/pg_gp/sql/fm.sql_in
----------------------------------------------------------------------
diff --git a/methods/sketch/src/pg_gp/sql/fm.sql_in b/methods/sketch/src/pg_gp/sql/fm.sql_in
index 16e5405..c367329 100644
--- a/methods/sketch/src/pg_gp/sql/fm.sql_in
+++ b/methods/sketch/src/pg_gp/sql/fm.sql_in
@@ -17,17 +17,17 @@ declare
result2 INT;
begin
- -- DROP TABLE IF EXISTS fm_data;
- CREATE TABLE fm_data(class INT, a1 INT);
- INSERT INTO fm_data SELECT 1,1 FROM generate_series(1,10000);
- INSERT INTO fm_data SELECT 1,2 FROM generate_series(1,15000);
- INSERT INTO fm_data SELECT 1,3 FROM generate_series(1,10000);
- INSERT INTO fm_data SELECT 2,5 FROM generate_series(1,1000);
- INSERT INTO fm_data SELECT 2,6 FROM generate_series(1,1000);
+ -- DROP TABLE IF EXISTS "FM_DATA";
+ CREATE TABLE "FM_DATA"(class INT, a1 INT);
+ INSERT INTO "FM_DATA" SELECT 1,1 FROM generate_series(1,10000);
+ INSERT INTO "FM_DATA" SELECT 1,2 FROM generate_series(1,15000);
+ INSERT INTO "FM_DATA" SELECT 1,3 FROM generate_series(1,10000);
+ INSERT INTO "FM_DATA" SELECT 2,5 FROM generate_series(1,1000);
+ INSERT INTO "FM_DATA" SELECT 2,6 FROM generate_series(1,1000);
-- DROP TABLE IF EXISTS fm_result_table;
CREATE TABLE fm_result_table AS
- SELECT (fmsketch_dcount(a1)) as val FROM fm_data GROUP BY class ORDER BY class;
+ SELECT (fmsketch_dcount(a1)) as val FROM "FM_DATA" GROUP BY class ORDER BY class;
SELECT array( SELECT val FROM fm_result_table) INTO result;
IF ((result[1] + result[2]) != 5) THEN
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/methods/sketch/src/pg_gp/sql/mfv.sql_in
----------------------------------------------------------------------
diff --git a/methods/sketch/src/pg_gp/sql/mfv.sql_in b/methods/sketch/src/pg_gp/sql/mfv.sql_in
index 9294f0f..d7c7dd6 100644
--- a/methods/sketch/src/pg_gp/sql/mfv.sql_in
+++ b/methods/sketch/src/pg_gp/sql/mfv.sql_in
@@ -12,13 +12,13 @@
---------------------------------------------------------------------------
-- Basic methods
-create table mfv_test as
+create table "MFV_TEST" as
(select generate_series(1,10000) i union all select generate_series(10,15) i);
-select mfvsketch_top_histogram(i,5) from mfv_test;
+select mfvsketch_top_histogram(i,5) from "MFV_TEST";
select mfvsketch_top_histogram(utc_offset,5) from pg_timezone_names;
select mfvsketch_top_histogram(NULL::bytea,5) from generate_series(1,100);
-select mfvsketch_quick_histogram(i,5) from mfv_test;
+select mfvsketch_quick_histogram(i,5) from "MFV_TEST";
select mfvsketch_quick_histogram(utc_offset,5) from pg_timezone_names;
select mfvsketch_quick_histogram(NULL::bytea,5) from generate_series(1,100);
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/convex/test/mlp.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/convex/test/mlp.sql_in b/src/ports/postgres/modules/convex/test/mlp.sql_in
index 2302252..e7964d2 100644
--- a/src/ports/postgres/modules/convex/test/mlp.sql_in
+++ b/src/ports/postgres/modules/convex/test/mlp.sql_in
@@ -29,15 +29,15 @@
SELECT setseed(0.6);
-DROP TABLE IF EXISTS iris_data, iris_test, mlp_class, mlp_class_summary CASCADE;
-CREATE TABLE iris_data(
+DROP TABLE IF EXISTS "Iris_data", iris_test, mlp_class, mlp_class_summary CASCADE;
+CREATE TABLE "Iris_data"(
id integer,
attributes numeric[],
class_text varchar,
class integer
);
-INSERT INTO iris_data VALUES
+INSERT INTO "Iris_data" VALUES
(1,ARRAY[5.1,3.5,1.4,0.2],'Iris-setosa',1),
(2,ARRAY[4.9,3.0,1.4,0.2],'Iris-setosa',1),
(3,ARRAY[4.7,3.2,1.3,0.2],'Iris-setosa',1),
@@ -191,7 +191,7 @@ INSERT INTO iris_data VALUES
SELECT mlp_classification(
- 'iris_data', -- Source table
+ '"Iris_data"', -- Source table
'mlp_class', -- Desination table
'attributes', -- Input features
'class', -- Label
@@ -219,7 +219,7 @@ DROP TABLE IF EXISTS mlp_prediction_output;
-- See prediction accuracy for training data
SELECT mlp_predict(
'mlp_class',
- 'iris_data',
+ '"Iris_data"',
'id',
'mlp_prediction_output',
'output');
@@ -231,16 +231,16 @@ SELECT assert(
'MLP: Score is too low (< 140). Wrong result.'
) FROM(
SELECT SUM(
-mlp_prediction_output.estimated_prob_1*(iris_data.class=1)::INT+
-mlp_prediction_output.estimated_prob_2*(iris_data.class=2)::INT+
-mlp_prediction_output.estimated_prob_3*(iris_data.class=3)::INT
+mlp_prediction_output.estimated_prob_1 * ("Iris_data".class=1)::INT+
+mlp_prediction_output.estimated_prob_2 * ("Iris_data".class=2)::INT+
+mlp_prediction_output.estimated_prob_3 * ("Iris_data".class=3)::INT
) AS score
-FROM mlp_prediction_output INNER JOIN iris_data ON iris_data.id=mlp_prediction_output.id)q;
+FROM mlp_prediction_output INNER JOIN "Iris_data" ON "Iris_data".id=mlp_prediction_output.id)q;
SELECT mlp_predict(
'mlp_class',
- 'iris_data',
+ '"Iris_data"',
'id',
'mlp_prediction',
'response');
@@ -250,9 +250,9 @@ SELECT assert(
COUNT(*)/150.0 > 0.95,
'MLP: Accuracy is too low (< 95%). Wrong result.'
) FROM
- (SELECT iris_data.class AS actual, mlp_prediction.estimated_class as estimated
- FROM mlp_prediction INNER JOIN iris_data ON
- iris_data.id=mlp_prediction.id) q
+ (SELECT "Iris_data".class AS actual, mlp_prediction.estimated_class as estimated
+ FROM mlp_prediction INNER JOIN "Iris_data" ON
+ "Iris_data".id=mlp_prediction.id) q
WHERE q.actual=q.estimated;
DROP TABLE IF EXISTS mlp_prediction;
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/graph/test/apsp.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/graph/test/apsp.sql_in b/src/ports/postgres/modules/graph/test/apsp.sql_in
index a7fa3af..3f7af8a 100644
--- a/src/ports/postgres/modules/graph/test/apsp.sql_in
+++ b/src/ports/postgres/modules/graph/test/apsp.sql_in
@@ -19,7 +19,7 @@
*
*//* ----------------------------------------------------------------------- */
-DROP TABLE IF EXISTS vertex,edge,out,out_summary,out_path,
+DROP TABLE IF EXISTS vertex,"EDGE",out,out_summary,out_path,
vertex_alt,edge_alt,out_alt,out_alot_summary,
edge_gr,out_gr,out_gr_summary,out_gr_path,
edge_gr2, out_gr2, out_gr2_summary;
@@ -29,9 +29,9 @@ CREATE TABLE vertex(
id INTEGER
);
-CREATE TABLE edge(
+CREATE TABLE "EDGE"(
src INTEGER,
- dest INTEGER,
+ "DEST" INTEGER,
weight DOUBLE PRECISION
);
@@ -45,7 +45,7 @@ INSERT INTO vertex VALUES
(6),
(7)
;
-INSERT INTO edge VALUES
+INSERT INTO "EDGE" VALUES
(0, 1, 1),
(0, 2, 1),
(0, 4, 10),
@@ -61,39 +61,39 @@ INSERT INTO edge VALUES
;
-SELECT graph_apsp('vertex',NULL,'edge',NULL,'out');
+SELECT graph_apsp('vertex',NULL,'"EDGE"','dest="DEST"','out');
-SELECT * FROM out ORDER BY src,dest;
+SELECT * FROM out ORDER BY src,"DEST";
SELECT assert(weight = 4, 'Wrong output in graph (APSP)')
-FROM out WHERE src = 0 AND dest = 7;
+FROM out WHERE src = 0 AND "DEST" = 7;
SELECT assert(parent = 6, 'Wrong parent in graph (APSP)')
-FROM out WHERE src = 0 AND dest = 7;
+FROM out WHERE src = 0 AND "DEST" = 7;
SELECT assert(weight = 11, 'Wrong output in graph (APSP)')
-FROM out WHERE src = 3 AND dest = 4;
+FROM out WHERE src = 3 AND "DEST" = 4;
SELECT assert(parent = 0, 'Wrong parent in graph (APSP)')
-FROM out WHERE src = 3 AND dest = 4;
+FROM out WHERE src = 3 AND "DEST" = 4;
-- Path
SELECT graph_apsp_get_path('out',0,7,'out_path');
-- Grouping
CREATE TABLE edge_gr AS
-(SELECT *, 0 AS grp FROM edge
+(SELECT *, 0 AS grp FROM "EDGE"
UNION
-SELECT *, 1 AS grp FROM edge WHERE src < 6 AND dest < 6
+SELECT *, 1 AS grp FROM "EDGE" WHERE src < 6 AND "DEST" < 6
UNION
-SELECT *, 2 AS grp FROM edge WHERE src < 6 AND dest < 6
+SELECT *, 2 AS grp FROM "EDGE" WHERE src < 6 AND "DEST" < 6
);
INSERT INTO edge_gr VALUES
(7,NULL,NULL,1),
(4,0,-20,2);
-SELECT graph_apsp('vertex',NULL,'edge_gr',NULL,'out_gr','grp');
+SELECT graph_apsp('vertex',NULL,'edge_gr','dest="DEST"','out_gr','grp');
SELECT assert(weight = 2, 'Wrong output in graph (APSP)')
- FROM out_gr WHERE src = 0 AND dest = 5 AND grp = 1;
+ FROM out_gr WHERE src = 0 AND "DEST" = 5 AND grp = 1;
SELECT assert(parent = 2, 'Wrong output in graph (APSP)')
- FROM out_gr WHERE src = 0 AND dest = 5 AND grp = 1;
+ FROM out_gr WHERE src = 0 AND "DEST" = 5 AND grp = 1;
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/graph/test/bfs.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/graph/test/bfs.sql_in b/src/ports/postgres/modules/graph/test/bfs.sql_in
index a035eb3..d2e48c5 100644
--- a/src/ports/postgres/modules/graph/test/bfs.sql_in
+++ b/src/ports/postgres/modules/graph/test/bfs.sql_in
@@ -20,7 +20,7 @@
*//* ----------------------------------------------------------------------- */
-DROP TABLE IF EXISTS vertex,edge,edge_grp;
+DROP TABLE IF EXISTS vertex,"EDGE",edge_grp;
CREATE TABLE vertex(
id INTEGER
@@ -40,12 +40,12 @@ INSERT INTO vertex VALUES
(11)
;
-CREATE TABLE edge(
- src INTEGER,
+CREATE TABLE "EDGE"(
+ "SRC" INTEGER,
dest INTEGER,
weight DOUBLE PRECISION
);
-INSERT INTO edge VALUES
+INSERT INTO "EDGE" VALUES
(0, 5, 1),
(1, 0, 1),
(1, 3, 1),
@@ -62,7 +62,7 @@ INSERT INTO edge VALUES
CREATE TABLE edge_grp(
g1 INTEGER,
g2 TEXT,
- src INTEGER,
+ "SRC" INTEGER,
dest INTEGER,
weight DOUBLE PRECISION
);
@@ -104,7 +104,7 @@ INSERT INTO edge_grp VALUES
-- Results to check against - uncomment if needed
-- -- source_vertex = 3
-- DROP TABLE IF EXISTS out_actual;
--- CREATE TABLE out_actual (src INT, id INT, dist INT, parent INT);
+-- CREATE TABLE out_actual ("SRC" INT, id INT, dist INT, parent INT);
-- INSERT INTO out_actual VALUES
-- (3,3,0,NULL),
-- (3,1,1,3),
@@ -116,11 +116,11 @@ INSERT INTO edge_grp VALUES
-- ;
-- -- source_vertex = 7
-- DROP TABLE IF EXISTS out_actual;
--- CREATE TABLE out_actual (src INT, id INT, dist INT, parent INT);
---
+-- CREATE TABLE out_actual ("SRC" INT, id INT, dist INT, parent INT);
+--
-- -- source_vertex = 8
-- DROP TABLE IF EXISTS out_actual;
--- CREATE TABLE out_actual (src INT, id INT, dist INT, parent INT);
+-- CREATE TABLE out_actual ("SRC" INT, id INT, dist INT, parent INT);
-- INSERT INTO out_actual VALUES
-- (8,8,0,NULL),
-- (8,9,1,8),
@@ -131,29 +131,29 @@ INSERT INTO edge_grp VALUES
-- Undirected graph
-- source_vertex = 3
DROP TABLE IF EXISTS out_frombfs, out_frombfs_summary;
-SELECT graph_bfs('vertex',NULL,'edge',NULL,3,'out_frombfs');
+SELECT graph_bfs('vertex',NULL,'"EDGE"','src="SRC"',3,'out_frombfs');
SELECT assert(
(array_agg(id ORDER BY id) = ARRAY[1,4,5]::INT[])
- AND
- (array_agg(parent ORDER BY id) = ARRAY[3,3,3]::INT[]),
- 'Wrong output in graph (BFS)')
+ AND
+ (array_agg(parent ORDER BY id) = ARRAY[3,3,3]::INT[]),
+ 'Wrong output in graph (BFS)')
FROM out_frombfs WHERE dist = 1 GROUP BY dist;
-SELECT assert(max(dist) = 3, 'Wrong output in graph (BFS)')
+SELECT assert(max(dist) = 3, 'Wrong output in graph (BFS)')
FROM out_frombfs;
-- source_vertex = 7
DROP TABLE IF EXISTS out_frombfs, out_frombfs_summary;
-SELECT graph_bfs('vertex',NULL,'edge',NULL,7,'out_frombfs');
+SELECT graph_bfs('vertex',NULL,'"EDGE"','src="SRC"',7,'out_frombfs');
SELECT assert(COUNT(*) = 0, 'Wrong output in graph (BFS)') FROM out_frombfs;
-- source_vertex = 8
DROP TABLE IF EXISTS out_frombfs, out_frombfs_summary;
-SELECT graph_bfs('vertex',NULL,'edge',NULL,8,'out_frombfs',NULL,FALSE,NULL);
+SELECT graph_bfs('vertex',NULL,'"EDGE"','src="SRC"',8,'out_frombfs',NULL,FALSE,NULL);
-SELECT assert(parent = 8, 'Wrong output in graph (BFS)')
+SELECT assert(parent = 8, 'Wrong output in graph (BFS)')
FROM out_frombfs WHERE dist = 2 AND id = 10;
-------------------
@@ -163,7 +163,7 @@ SELECT assert(parent = 8, 'Wrong output in graph (BFS)')
-- -- source_vertex = 3
-- DROP TABLE IF EXISTS out_actual;
--- CREATE TABLE out_actual (src INT, id INT, dist INT, parent INT);
+-- CREATE TABLE out_actual ("SRC" INT, id INT, dist INT, parent INT);
-- INSERT INTO out_actual VALUES
-- (3,3,0,NULL),
-- (3,4,1,3),
@@ -173,10 +173,10 @@ SELECT assert(parent = 8, 'Wrong output in graph (BFS)')
-- ;
-- -- source_vertex = 7
-- DROP TABLE IF EXISTS out_actual;
--- CREATE TABLE out_actual (src INT, id INT, dist INT, parent INT);
+-- CREATE TABLE out_actual ("SRC" INT, id INT, dist INT, parent INT);
-- -- source_vertex = 8
-- DROP TABLE IF EXISTS out_actual;
--- CREATE TABLE out_actual (src INT, id INT, dist INT, parent INT);
+-- CREATE TABLE out_actual ("SRC" INT, id INT, dist INT, parent INT);
-- (8, 8, 0, NULL),
-- (8, 9, 1, 8),
-- (8, 10, 2, 9),
@@ -185,27 +185,27 @@ SELECT assert(parent = 8, 'Wrong output in graph (BFS)')
-- source_vertex = 3
DROP TABLE IF EXISTS out_frombfs, out_frombfs_summary;
-SELECT graph_bfs('vertex','id','edge','src,dest',3,'out_frombfs',NULL,TRUE,NULL);
+SELECT graph_bfs('vertex','id','"EDGE"','src="SRC",dest',3,'out_frombfs',NULL,TRUE,NULL);
SELECT assert(
(array_agg(id ORDER BY id) = ARRAY[4,5]::INT[])
- AND
+ AND
(array_agg(parent ORDER BY id) = ARRAY[3,3]::INT[]),
- 'Wrong output in graph (BFS)')
+ 'Wrong output in graph (BFS)')
FROM out_frombfs WHERE dist = 1 GROUP BY dist;
SELECT assert(COUNT(*) = 5, 'Wrong output in graph (BFS)') FROM out_frombfs;
-- source_vertex = 7
DROP TABLE IF EXISTS out_frombfs, out_frombfs_summary;
-SELECT graph_bfs('vertex','id','edge','src,dest',7,'out_frombfs',NULL,TRUE,NULL);
+SELECT graph_bfs('vertex','id','"EDGE"','src="SRC",dest',7,'out_frombfs',NULL,TRUE,NULL);
SELECT assert(COUNT(*) = 0, 'Wrong output in graph (BFS)') FROM out_frombfs;
-- source_vertex = 8
DROP TABLE IF EXISTS out_frombfs, out_frombfs_summary;
-SELECT graph_bfs('vertex',NULL,'edge',NULL,8,'out_frombfs',NULL,TRUE);
+SELECT graph_bfs('vertex',NULL,'"EDGE"','src="SRC"',8,'out_frombfs',NULL,TRUE);
-SELECT assert(COUNT(*) = 2, 'Wrong output in graph (BFS)')
+SELECT assert(COUNT(*) = 2, 'Wrong output in graph (BFS)')
FROM out_frombfs WHERE dist = 2;
-----------------------
@@ -214,14 +214,14 @@ SELECT assert(COUNT(*) = 2, 'Wrong output in graph (BFS)')
-- source_vertex = 3
-- Undirected graph
DROP TABLE IF EXISTS out_frombfs, out_frombfs_summary;
-SELECT graph_bfs('vertex','id','edge','src,dest',3,'out_frombfs',2,FALSE);
+SELECT graph_bfs('vertex','id','"EDGE"','src="SRC",dest',3,'out_frombfs',2,FALSE);
SELECT assert(MAX(dist) = 2 AND COUNT(*) = 6,
'Wrong output in graph (BFS)') FROM out_frombfs;
-- Directed graph
DROP TABLE IF EXISTS out_frombfs, out_frombfs_summary;
-SELECT graph_bfs('vertex',NULL,'edge',NULL,3,'out_frombfs',2,TRUE);
+SELECT graph_bfs('vertex',NULL,'"EDGE"','src="SRC"',3,'out_frombfs',2,TRUE);
SELECT assert(MAX(dist) = 2 AND COUNT(*) = 4,
'Wrong output in graph (BFS)') FROM out_frombfs;
@@ -229,10 +229,10 @@ SELECT assert(MAX(dist) = 2 AND COUNT(*) = 4,
---------------------
-- Grouping columns
---------------------
--- -- source_vertex = 3
+-- -- source_vertex = 3
-- -- Undirected graph
-- DROP TABLE IF EXISTS out_actual;
--- CREATE TABLE out_actual (src INT, id INT, dist INT, parent INT);
+-- CREATE TABLE out_actual ("SRC" INT, id INT, dist INT, parent INT);
-- INSERT INTO out_actual VALUES
-- (3,100,'a',3,0,NULL),
-- (3,100,'a',1,1,3),
@@ -251,22 +251,22 @@ SELECT assert(MAX(dist) = 2 AND COUNT(*) = 4,
-- ;
DROP TABLE IF EXISTS out_frombfs, out_frombfs_summary;
-SELECT graph_bfs('vertex',NULL,'edge_grp',NULL,3,'out_frombfs',NULL,NULL,'g1,g2');
+SELECT graph_bfs('vertex',NULL,'edge_grp','src="SRC"',3,'out_frombfs',NULL,NULL,'g1,g2');
SELECT assert( COUNT(*) = 14,'Wrong output in graph (BFS)') FROM out_frombfs;
SELECT assert(COUNT(*) = 7,
'Wrong output in graph (BFS)') FROM out_frombfs WHERE g2 = 'a'
;
SELECT assert(
- array_agg(id ORDER BY id) = ARRAY[0,2]::INT[]
- AND
+ array_agg(id ORDER BY id) = ARRAY[0,2]::INT[]
+ AND
array_agg(parent ORDER BY id) = ARRAY[1,4]::INT[],
'Wrong output in graph (BFS)')
FROM out_frombfs WHERE dist = 2 AND g1 = 100 AND g2 = 'a'
;
SELECT assert(
- array_agg(id ORDER BY id) = ARRAY[0,2]::INT[]
- AND
+ array_agg(id ORDER BY id) = ARRAY[0,2]::INT[]
+ AND
array_agg(parent ORDER BY id) = ARRAY[1,4]::INT[],
'Wrong output in graph (BFS)')
FROM out_frombfs WHERE dist = 2 AND g1 = 100 AND g2 = 'b'
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/graph/test/measures.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/graph/test/measures.sql_in b/src/ports/postgres/modules/graph/test/measures.sql_in
index b0bf95e..2842ffa 100644
--- a/src/ports/postgres/modules/graph/test/measures.sql_in
+++ b/src/ports/postgres/modules/graph/test/measures.sql_in
@@ -20,15 +20,15 @@
*/
/* ----------------------------------------------------------------------- */
--- Create vertex and edge tables to represent the graph:
-DROP TABLE IF EXISTS vertex, edge;
+-- Create vertex and "EDGE" tables to represent the graph:
+DROP TABLE IF EXISTS vertex, "EDGE";
CREATE TABLE vertex(
id INTEGER,
name TEXT
);
-CREATE TABLE edge(
+CREATE TABLE "EDGE"(
src_id INTEGER,
- dest_id INTEGER,
+ "DEST_ID" INTEGER,
edge_weight FLOAT8
);
INSERT INTO vertex VALUES
@@ -40,7 +40,7 @@ INSERT INTO vertex VALUES
(5, 'F'),
(6, 'G'),
(7, 'H');
-INSERT INTO edge VALUES
+INSERT INTO "EDGE" VALUES
(0, 1, 1.0),
(0, 2, 1.0),
(0, 4, 10.0),
@@ -58,9 +58,9 @@ INSERT INTO edge VALUES
DROP TABLE IF EXISTS out_apsp, out_apsp_summary;
SELECT graph_apsp('vertex', -- Vertex table
'id', -- Vertix id column (NULL means use default naming)
- 'edge', -- Edge table
- 'src=src_id, dest=dest_id, weight=edge_weight',
- -- Edge arguments (NULL means use default naming)
+ '"EDGE"', -- "EDGE" table
+ 'src=src_id, dest="DEST_ID", weight=edge_weight',
+ -- "EDGE" arguments (NULL means use default naming)
'out_apsp'); -- Output table of shortest paths
-- Compute the closeness measure for all nodes:
@@ -93,9 +93,9 @@ SELECT assert(relative_error(avg_path_length, 2.0178) < 1e-2,
DROP TABLE IF EXISTS out_degrees;
SELECT graph_vertex_degrees('vertex', -- Vertex table
'id', -- Vertix id column (NULL means use default naming)
- 'edge', -- Edge table
- 'src=src_id, dest=dest_id, weight=edge_weight',
- -- Edge arguments (NULL means use default naming)
+ '"EDGE"', -- "EDGE" table
+ 'src=src_id, dest="DEST_ID", weight=edge_weight',
+ -- "EDGE" arguments (NULL means use default naming)
'out_degrees');
SELECT * FROM out_degrees;
SELECT assert(indegree = 2 and outdegree = 3, 'Invalid value for degrees')
@@ -109,9 +109,9 @@ WHERE id = 0;
DROP TABLE IF EXISTS edge_gr;
CREATE TABLE edge_gr AS
(
- SELECT *, 0 AS grp FROM edge
+ SELECT *, 0 AS grp FROM "EDGE"
UNION
- SELECT *, 1 AS grp FROM edge WHERE src_id < 6 AND dest_id < 6
+ SELECT *, 1 AS grp FROM "EDGE" WHERE src_id < 6 AND "DEST_ID" < 6
);
INSERT INTO edge_gr VALUES
(4,5,-20,1);
@@ -120,8 +120,8 @@ INSERT INTO edge_gr VALUES
DROP TABLE IF EXISTS out_apsp, out_apsp_summary;
SELECT graph_apsp('vertex', -- Vertex table
'id', -- Vertex id column (NULL means use default naming)
- 'edge_gr', -- Edge table
- 'src=src_id, dest=dest_id, weight=edge_weight',
+ 'edge_gr', -- "EDGE" table
+ 'src=src_id, dest="DEST_ID", weight=edge_weight',
'out_apsp', -- Output table of shortest paths
'grp' -- Grouping columns
);
@@ -143,8 +143,8 @@ SELECT * FROM out ORDER BY grp;
DROP TABLE IF EXISTS out_degrees;
SELECT graph_vertex_degrees('vertex', -- Vertex table
'id', -- Vertix id column (NULL means use default naming)
- 'edge_gr', -- Edge table
- 'src=src_id, dest=dest_id, weight=edge_weight',
+ 'edge_gr', -- "EDGE" table
+ 'src=src_id, dest="DEST_ID", weight=edge_weight',
'out_degrees',
'grp');
SELECT * FROM out_degrees ORDER BY grp, id;
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/graph/test/pagerank.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/graph/test/pagerank.sql_in b/src/ports/postgres/modules/graph/test/pagerank.sql_in
index d3bc32b..e66986b 100644
--- a/src/ports/postgres/modules/graph/test/pagerank.sql_in
+++ b/src/ports/postgres/modules/graph/test/pagerank.sql_in
@@ -19,11 +19,11 @@
*
*//* ----------------------------------------------------------------------- */
-DROP TABLE IF EXISTS vertex, edge;
+DROP TABLE IF EXISTS vertex, "EDGE";
CREATE TABLE vertex(
id INTEGER
);
-CREATE TABLE edge(
+CREATE TABLE "EDGE"(
src INTEGER,
dest INTEGER,
user_id INTEGER
@@ -36,7 +36,7 @@ INSERT INTO vertex VALUES
(4),
(5),
(6);
-INSERT INTO edge VALUES
+INSERT INTO "EDGE" VALUES
(0, 1, 1),
(0, 2, 1),
(0, 4, 1),
@@ -64,8 +64,8 @@ DROP TABLE IF EXISTS pagerank_out, pagerank_out_summary;
SELECT pagerank(
'vertex', -- Vertex table
'id', -- Vertix id column
- 'edge', -- Edge table
- 'src=src, dest=dest', -- Edge args
+ '"EDGE"', -- "EDGE" table
+ 'src=src, dest=dest', -- "EDGE" args
'pagerank_out'); -- Output table of PageRank
-- View the PageRank of all vertices, sorted by their scores.
@@ -78,8 +78,8 @@ DROP TABLE IF EXISTS pagerank_gr_out_summary;
SELECT pagerank(
'vertex', -- Vertex table
'id', -- Vertix id column
- 'edge', -- Edge table
- 'src=src, dest=dest', -- Edge args
+ '"EDGE"', -- "EDGE" table
+ 'src=src, dest=dest', -- "EDGE" args
'pagerank_gr_out', -- Output table of PageRank
NULL,
NULL,
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/graph/test/sssp.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/graph/test/sssp.sql_in b/src/ports/postgres/modules/graph/test/sssp.sql_in
index 621d55d..e0c3ef8 100644
--- a/src/ports/postgres/modules/graph/test/sssp.sql_in
+++ b/src/ports/postgres/modules/graph/test/sssp.sql_in
@@ -20,7 +20,7 @@
*//* ----------------------------------------------------------------------- */
-DROP TABLE IF EXISTS vertex,edge,out,out_summary,out_path,
+DROP TABLE IF EXISTS vertex,"EDGE",out,out_summary,out_path,
vertex_alt,edge_alt,out_alt,out_alot_summary,
edge_gr,out_gr,out_gr_summary,out_gr_path,
edge_gr2, out_gr2, out_gr2_summary,
@@ -30,7 +30,7 @@ CREATE TABLE vertex(
id INTEGER
);
-CREATE TABLE edge(
+CREATE TABLE "EDGE"(
src INTEGER,
dest INTEGER,
weight DOUBLE PRECISION
@@ -46,7 +46,7 @@ INSERT INTO vertex VALUES
(6),
(7)
;
-INSERT INTO edge VALUES
+INSERT INTO "EDGE" VALUES
(0, 1, 1),
(0, 2, 1),
(0, 4, 10),
@@ -61,7 +61,7 @@ INSERT INTO edge VALUES
(6, 7, 1)
;
-SELECT graph_sssp('vertex',NULL,'edge',NULL,0,'out');
+SELECT graph_sssp('vertex',NULL,'"EDGE"',NULL,0,'out');
SELECT * FROM out;
@@ -75,7 +75,7 @@ SELECT graph_sssp_get_path('out',6,'out_path');
CREATE TABLE vertex_alt AS SELECT id AS v_id
FROM vertex;
CREATE TABLE edge_alt AS SELECT src AS e_src, dest, weight AS e_weight
- FROM edge;
+ FROM "EDGE";
SELECT graph_sssp('vertex_alt','v_id','edge_alt','src=e_src, weight=e_weight'
,1,'out_alt');
@@ -88,11 +88,11 @@ SELECT assert(parent = 5, 'Wrong parent in graph (SSSP)')
FROM out_alt WHERE v_id = 6;
CREATE TABLE edge_gr AS
-( SELECT *, 0 AS grp FROM edge
+( SELECT *, 0 AS grp FROM "EDGE"
UNION
- SELECT *, 1 AS grp FROM edge WHERE src < 6 AND dest < 6
+ SELECT *, 1 AS grp FROM "EDGE" WHERE src < 6 AND dest < 6
UNION
- SELECT *, 2 AS grp FROM edge WHERE src < 6 AND dest < 6
+ SELECT *, 2 AS grp FROM "EDGE" WHERE src < 6 AND dest < 6
);
INSERT INTO edge_gr VALUES
@@ -117,11 +117,11 @@ SELECT assert(weight = 'Infinity', 'Wrong output in graph (SSSP)')
SELECT graph_sssp_get_path('out_gr',5,'out_gr_path');
CREATE TABLE edge_gr2 AS
-( SELECT *, 0 AS grp1, 0 AS grp2 FROM edge
+( SELECT *, 0 AS grp1, 0 AS grp2 FROM "EDGE"
UNION
- SELECT *, 1 AS grp1, 0 AS grp2 FROM edge WHERE src < 6 AND dest < 6
+ SELECT *, 1 AS grp1, 0 AS grp2 FROM "EDGE" WHERE src < 6 AND dest < 6
UNION
- SELECT *, 1 AS grp1, 1 AS grp2 FROM edge WHERE src < 6 AND dest < 6
+ SELECT *, 1 AS grp1, 1 AS grp2 FROM "EDGE" WHERE src < 6 AND dest < 6
);
SELECT graph_sssp('vertex',NULL,'edge_gr2',NULL,0,'out_gr2','grp1,grp2');
@@ -131,7 +131,7 @@ SELECT assert(weight = 3, 'Wrong output in graph (SSSP)')
SELECT assert(parent = 5, 'Wrong parent in graph (SSSP)')
FROM out_gr2 WHERE id = 6 AND grp1 = 0 AND grp2 = 0;
-CREATE TABLE "edge_Q" AS SELECT src, dest AS "dest_Q", weight FROM edge;
+CREATE TABLE "edge_Q" AS SELECT src, dest AS "dest_Q", weight FROM "EDGE";
SELECT graph_sssp('vertex','','"edge_Q"','dest="dest_Q"',0,'"out_Q"','');
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/graph/test/wcc.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/graph/test/wcc.sql_in b/src/ports/postgres/modules/graph/test/wcc.sql_in
index a943f6e..1dbb8e2 100644
--- a/src/ports/postgres/modules/graph/test/wcc.sql_in
+++ b/src/ports/postgres/modules/graph/test/wcc.sql_in
@@ -19,11 +19,11 @@
*
*//* ----------------------------------------------------------------------- */
-DROP TABLE IF EXISTS vertex, edge;
+DROP TABLE IF EXISTS vertex, "EDGE";
CREATE TABLE vertex(
vertex_id INTEGER
);
-CREATE TABLE edge(
+CREATE TABLE "EDGE"(
src_node INTEGER,
dest_node INTEGER,
user_id INTEGER
@@ -43,7 +43,7 @@ INSERT INTO vertex VALUES
(14),
(15),
(16);
-INSERT INTO edge VALUES
+INSERT INTO "EDGE" VALUES
(0, 1, 1),
(0, 2, 1),
(1, 2, 1),
@@ -67,7 +67,7 @@ DROP TABLE IF EXISTS wcc_out, wcc_out_summary;
SELECT weakly_connected_components(
'vertex',
'vertex_id',
- 'edge',
+ '"EDGE"',
'src=src_node,dest=dest_node',
'wcc_out');
@@ -75,7 +75,7 @@ SELECT assert(relative_error(count(distinct component_id), 4) < 0.00001,
'Weakly Connected Components: Number of components found is not 4.'
) FROM wcc_out;
-INSERT INTO edge VALUES
+INSERT INTO "EDGE" VALUES
(0, 1, 2),
(0, 2, 2),
(1, 2, 2),
@@ -99,7 +99,7 @@ DROP TABLE IF EXISTS wcc_out, wcc_out_summary;
SELECT weakly_connected_components(
'vertex',
'vertex_id',
- 'edge',
+ '"EDGE"',
'src=src_node,dest=dest_node',
'wcc_out',
'user_id');
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/knn/test/knn.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/knn/test/knn.sql_in b/src/ports/postgres/modules/knn/test/knn.sql_in
index 1bf6b57..e5427fd 100644
--- a/src/ports/postgres/modules/knn/test/knn.sql_in
+++ b/src/ports/postgres/modules/knn/test/knn.sql_in
@@ -26,12 +26,12 @@ m4_include(`SQLCommon.m4')
* FIXME: Verify results
* -------------------------------------------------------------------------- */
-drop table if exists knn_train_data;
-create table knn_train_data (
+drop table if exists "KNN_TRAIN_DATA";
+create table "KNN_TRAIN_DATA" (
id integer,
-data integer[],
+"DATA" integer[],
label float);
-copy knn_train_data (id, data, label) from stdin delimiter '|';
+copy "KNN_TRAIN_DATA" (id, "DATA", label) from stdin delimiter '|';
1|{1,1}|1.0
2|{2,2}|1.0
3|{3,3}|1.0
@@ -45,8 +45,8 @@ copy knn_train_data (id, data, label) from stdin delimiter '|';
drop table if exists knn_test_data;
create table knn_test_data (
id integer,
-data integer[]);
-copy knn_test_data (id, data) from stdin delimiter '|';
+"DATA" integer[]);
+copy knn_test_data (id, "DATA") from stdin delimiter '|';
1|{2,1}
2|{2,6}
3|{15,40}
@@ -55,15 +55,15 @@ copy knn_test_data (id, data) from stdin delimiter '|';
6|{50,45}
\.
drop table if exists madlib_knn_result_classification;
-select knn('knn_train_data','data','label','knn_test_data','data','id','madlib_knn_result_classification','c',3);
+select knn('"KNN_TRAIN_DATA"','"DATA"','label','knn_test_data','"DATA"','id','madlib_knn_result_classification','c',3);
select assert(array_agg(prediction order by id)='{1,1,0,1,0,0}', 'Wrong output in classification with k=3') from madlib_knn_result_classification;
drop table if exists madlib_knn_result_regression;
-select knn('knn_train_data','data','label','knn_test_data','data','id','madlib_knn_result_regression','r',4);
+select knn('"KNN_TRAIN_DATA"','"DATA"','label','knn_test_data','"DATA"','id','madlib_knn_result_regression','r',4);
select assert(array_agg(prediction order by id)='{1,1,0.5,1,0.25,0.25}', 'Wrong output in regression') from madlib_knn_result_regression;
drop table if exists madlib_knn_result_classification;
-select knn('knn_train_data','data','label','knn_test_data','data','id','madlib_knn_result_classification','c');
+select knn('"KNN_TRAIN_DATA"','"DATA"','label','knn_test_data','"DATA"','id','madlib_knn_result_classification','c');
select assert(array_agg(prediction order by id)='{1,1,0,1,0,0}', 'Wrong output in classification with k=1') from madlib_knn_result_classification;
select knn();
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/sample/test/stratified_sample.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/sample/test/stratified_sample.sql_in b/src/ports/postgres/modules/sample/test/stratified_sample.sql_in
index 6ddcbfd..f742d01 100644
--- a/src/ports/postgres/modules/sample/test/stratified_sample.sql_in
+++ b/src/ports/postgres/modules/sample/test/stratified_sample.sql_in
@@ -19,16 +19,16 @@
*
*//* ----------------------------------------------------------------------- */
-DROP TABLE IF EXISTS test;
+DROP TABLE IF EXISTS "TEST";
-CREATE TABLE test(
+CREATE TABLE "TEST"(
id1 INTEGER,
- id2 INTEGER,
+ "ID2" INTEGER,
gr1 INTEGER,
gr2 INTEGER
);
-INSERT INTO test VALUES
+INSERT INTO "TEST" VALUES
(1,0,1,1),
(2,0,1,1),
(3,0,1,1),
@@ -57,19 +57,19 @@ INSERT INTO test VALUES
;
DROP TABLE IF EXISTS out;
-SELECT stratified_sample('test', 'out', 0.5, NULL, 'id1,id2,gr1,gr2', FALSE);
+SELECT stratified_sample('"TEST"', 'out', 0.5, NULL, 'id1,"ID2",gr1,gr2', FALSE);
SELECT assert(count(*) = 13, 'Wrong number of samples') FROM out;
DROP TABLE IF EXISTS out;
-SELECT stratified_sample('test', 'out', 0.5, 'gr1,gr2', 'id1,id2', FALSE);
+SELECT stratified_sample('"TEST"', 'out', 0.5, 'gr1,gr2', 'id1,"ID2"', FALSE);
SELECT assert(count(*) = 3, 'Wrong number of samples')
-FROM (SELECT DISTINCT id1,id2 FROM out WHERE gr1 = 1 AND gr2 = 2)x;
+FROM (SELECT DISTINCT id1,"ID2" FROM out WHERE gr1 = 1 AND gr2 = 2)x;
DROP TABLE IF EXISTS out;
-SELECT stratified_sample('test', 'out', 0.5, NULL, 'id1,id2,gr1,gr2', TRUE);
+SELECT stratified_sample('"TEST"', 'out', 0.5, NULL, 'id1,"ID2",gr1,gr2', TRUE);
SELECT assert(count(*) = 13, 'Wrong number of samples') FROM out;
DROP TABLE IF EXISTS out;
-SELECT stratified_sample('test', 'out', 0.5, 'gr1,gr2', 'id1,id2', TRUE);
+SELECT stratified_sample('"TEST"', 'out', 0.5, 'gr1,gr2', 'id1,"ID2"', TRUE);
SELECT assert(count(*) = 6, 'Wrong number of samples')
FROM out WHERE gr1 = 1 AND gr2 = 1;
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/utilities/test/pivot.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/utilities/test/pivot.sql_in b/src/ports/postgres/modules/utilities/test/pivot.sql_in
index 3dafd18..fb034e7 100644
--- a/src/ports/postgres/modules/utilities/test/pivot.sql_in
+++ b/src/ports/postgres/modules/utilities/test/pivot.sql_in
@@ -19,15 +19,15 @@
*
*//* ----------------------------------------------------------------------- */
-DROP TABLE IF EXISTS pivset;
+DROP TABLE IF EXISTS "PIVSET";
-CREATE TABLE pivset(
+CREATE TABLE "PIVSET"(
id INTEGER,
piv INTEGER,
val INTEGER
);
-INSERT INTO pivset VALUES
+INSERT INTO "PIVSET" VALUES
(0, 10, 1),
(0, 10, 2),
(0, 20, 3),
@@ -40,7 +40,7 @@ INSERT INTO pivset VALUES
(0, 10, NULL);
DROP TABLE IF EXISTS pivout;
-SELECT pivot('pivset', 'pivout', 'id', 'piv', 'val');
+SELECT pivot('"PIVSET"', 'pivout', 'id', 'piv', 'val');
SELECT * FROM pivout;
SELECT assert(val_avg_piv_20 = 3, 'Wrong output in pivoting') FROM pivout WHERE id = 0;
@@ -48,10 +48,10 @@ SELECT assert(val_avg_piv_20 = 3, 'Wrong output in pivoting') FROM pivout WHERE
DROP VIEW IF EXISTS pivset_ext;
CREATE VIEW pivset_ext AS
SELECT *,
- COALESCE(id + (pivset.val / 3), 0) AS id2,
- COALESCE(piv + (pivset.val / 3), 0) AS piv2,
+ COALESCE(id + ("PIVSET".val / 3), 0) AS id2,
+ COALESCE(piv + ("PIVSET".val / 3), 0) AS piv2,
COALESCE(val + 10, 0) AS val2
- FROM pivset;
+ FROM "PIVSET";
SELECT id,id2,piv,piv2,val,val2 FROM pivset_ext
ORDER BY id,id2,piv,piv2,val,val2;
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/f1aa9af6/src/ports/postgres/modules/utilities/test/sessionize.sql_in
----------------------------------------------------------------------
diff --git a/src/ports/postgres/modules/utilities/test/sessionize.sql_in b/src/ports/postgres/modules/utilities/test/sessionize.sql_in
index 845e572..808970c 100644
--- a/src/ports/postgres/modules/utilities/test/sessionize.sql_in
+++ b/src/ports/postgres/modules/utilities/test/sessionize.sql_in
@@ -88,7 +88,10 @@ SELECT sessionize(
SELECT
assert(
- relative_error(array_agg(CASE WHEN original_session_id NOTNULL THEN original_session_id ELSE 0 END), array_agg(CASE WHEN session_id NOTNULL THEN session_id ELSE 0 END)) < 1e-6,
+ relative_error(array_agg(CASE WHEN original_session_id NOTNULL
+ THEN original_session_id ELSE 0 END),
+ array_agg(CASE WHEN session_id NOTNULL
+ THEN session_id ELSE 0 END)) < 1e-6,
'wrong output in sessionization')
FROM sessionize_output_v;
SELECT * FROM sessionize_output_v;
@@ -105,7 +108,8 @@ SELECT sessionize(
SELECT
assert(
- relative_error(array_agg(CASE WHEN eventlog_installchk.part_expr THEN 1 ELSE 0 END), array_agg(CASE WHEN sessionize_output_t.uid THEN 1 ELSE 0 END)) != 0,
+ relative_error(array_agg(CASE WHEN eventlog_installchk.part_expr THEN 1 ELSE 0 END),
+ array_agg(CASE WHEN sessionize_output_t.uid THEN 1 ELSE 0 END)) != 0,
'wrong output in sessionization')
FROM sessionize_output_t, eventlog_installchk;
SELECT * FROM sessionize_output_t;