7
CREATE TABLE PATH_TBL (f1 path);
9
INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)]');
11
INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))');
13
INSERT INTO PATH_TBL VALUES ('[(0,0),(3,0),(4,5),(1,6)]');
15
INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))');
17
INSERT INTO PATH_TBL VALUES ('1,2 ,3,4');
19
INSERT INTO PATH_TBL VALUES ('[1,2,3, 4]');
21
INSERT INTO PATH_TBL VALUES ('[11,12,13,14]');
23
INSERT INTO PATH_TBL VALUES ('(11,12,13,14)');
25
-- bad values for parser testing
26
INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]');
28
INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)');
30
SELECT f1 FROM PATH_TBL;
32
SELECT '' AS count, f1 AS open_path FROM PATH_TBL WHERE isopen(f1);
34
SELECT '' AS count, f1 AS closed_path FROM PATH_TBL WHERE isclosed(f1);
36
SELECT '' AS count, pclose(f1) AS closed_path FROM PATH_TBL;
38
SELECT '' AS count, popen(f1) AS open_path FROM PATH_TBL;