1--
2-- LSEG
3-- Line segments
4--
5
6--DROP TABLE LSEG_TBL;
7CREATE TABLE LSEG_TBL (s lseg);
8
9INSERT INTO LSEG_TBL VALUES ('[(1,2),(3,4)]');
10INSERT INTO LSEG_TBL VALUES ('(0,0),(6,6)');
11INSERT INTO LSEG_TBL VALUES ('10,-10 ,-3,-4');
12INSERT INTO LSEG_TBL VALUES ('[-1e6,2e2,3e5, -4e1]');
13INSERT INTO LSEG_TBL VALUES (lseg(point(11, 22), point(33,44)));
14INSERT INTO LSEG_TBL VALUES ('[(-10,2),(-10,3)]');	-- vertical
15INSERT INTO LSEG_TBL VALUES ('[(0,-20),(30,-20)]');	-- horizontal
16INSERT INTO LSEG_TBL VALUES ('[(NaN,1),(NaN,90)]');	-- NaN
17
18-- bad values for parser testing
19INSERT INTO LSEG_TBL VALUES ('(3asdf,2 ,3,4r2)');
20INSERT INTO LSEG_TBL VALUES ('[1,2,3, 4');
21INSERT INTO LSEG_TBL VALUES ('[(,2),(3,4)]');
22INSERT INTO LSEG_TBL VALUES ('[(1,2),(3,4)');
23
24select * from LSEG_TBL;
25