[TEST] adding a test function

cvvergara · cvvergara · commit 89e09ec50a13 · 2018-09-12T09:21:41.000-05:00
diff --git a/VERSION b/VERSION
@@ -1 +1 @@
-v2.5.4-6764-7064964 release/2.5
+v2.5.4-6765-bb77143 release/2.5
diff --git a/sql/common/utilities_pgr.sql b/sql/common/utilities_pgr.sql
@@ -214,7 +214,7 @@ BEGIN
     IF (sql IS NULL) THEN
       RETURN   o_sql;
     ELSE
-      RETURN  regexp_replace(sql, '(.)* as ', '', 'i');
+      RETURN  regexp_replace(regexp_replace(regexp_replace(sql, '\s(as)\s', '___foo___', 'i'), '^.*___foo___', '','i'), ';$', '');
     END IF;
 END
 $BODY$
diff --git a/tools/testers/no_crash_test.sql b/tools/testers/no_crash_test.sql
@@ -0,0 +1,40 @@
+
+CREATE OR REPLACE FUNCTION no_crash_test(func TEXT, params TEXT[], subs TEXT[])
+RETURNS SETOF TEXT AS
+$BODY$
+DECLARE
+mp TEXT[];
+q1 TEXT;
+q TEXT;
+separator TEXT;
+BEGIN
+    FOR i IN 0..array_length(params, 1) LOOP
+        separator = ' ';
+        mp := params;
+        IF i != 0 THEN
+            mp[i] = subs[i];
+        END IF;
+
+        q1 := 'SELECT * FROM ' || $1 || ' (';
+
+        FOR i IN 1..array_length(mp, 1) LOOP
+            q1 := q1 || separator || mp[i];
+            separator :=',';
+        END LOOP;
+
+        q1 := q1 || ')';
+
+
+
+        RETURN query SELECT * FROM lives_ok(q1);
+        IF i = 0 THEN
+            RETURN query SELECT * FROM isnt_empty(q1);
+        ELSE
+            RETURN query SELECT * FROM is_empty(q1);
+        END IF;
+
+    END LOOP;
+
+END
+$BODY$
+LANGUAGE plpgsql VOLATILE;
diff --git a/tools/testers/setup_db.sql b/tools/testers/setup_db.sql
@@ -22,9 +22,12 @@ CREATE EXTENSION pgrouting;
 BEGIN;
 
     \i sampledata.sql
+    \i vrppdtw_data.sql
+    \i vrpOneDepot.data
     \i innerQuery.sql
     \i innerQuery_old.sql
     \i inner_styles.sql
     \i old_inner_styles.sql
+    \i no_crash_test.sql
 
 END;

Original file line number	Diff line number	Diff line change
`@@ -1 +1 @@`
`1`		`-v2.5.4-6764-7064964 release/2.5`
	`1`	`+v2.5.4-6765-bb77143 release/2.5`