1--
2-- PATH
3--
4
5--DROP TABLE PATH_TBL;
6
7CREATE TABLE PATH_TBL (f1 path);
8
9INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)]');
10
11INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))');
12
13INSERT INTO PATH_TBL VALUES ('[(0,0),(3,0),(4,5),(1,6)]');
14
15INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))');
16
17INSERT INTO PATH_TBL VALUES ('1,2 ,3,4');
18
19INSERT INTO PATH_TBL VALUES ('[1,2,3, 4]');
20
21INSERT INTO PATH_TBL VALUES ('[11,12,13,14]');
22
23INSERT INTO PATH_TBL VALUES ('(11,12,13,14)');
24
25-- bad values for parser testing
26INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]');
27
28INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)');
29
30SELECT f1 FROM PATH_TBL;
31
32SELECT '' AS count, f1 AS open_path FROM PATH_TBL WHERE isopen(f1);
33
34SELECT '' AS count, f1 AS closed_path FROM PATH_TBL WHERE isclosed(f1);
35
36SELECT '' AS count, pclose(f1) AS closed_path FROM PATH_TBL;
37
38SELECT '' AS count, popen(f1) AS open_path FROM PATH_TBL;
39