diff options
| author | Tom Lane | 2008-09-01 20:42:46 +0000 |
|---|---|---|
| committer | Tom Lane | 2008-09-01 20:42:46 +0000 |
| commit | b153c0920960a6059b67969469166fb29c0105d7 (patch) | |
| tree | 4e7100ecdca88746c369ae2a6a43468925f3194d /contrib/cube | |
| parent | 9ac4299163247645c6e391f5f65735c6cb78ccb9 (diff) | |
Add a bunch of new error location reports to parse-analysis error messages.
There are still some weak spots around JOIN USING and relation alias lists,
but most errors reported within backend/parser/ now have locations.
Diffstat (limited to 'contrib/cube')
| -rw-r--r-- | contrib/cube/expected/cube.out | 60 | ||||
| -rw-r--r-- | contrib/cube/expected/cube_1.out | 60 | ||||
| -rw-r--r-- | contrib/cube/expected/cube_2.out | 60 |
3 files changed, 180 insertions, 0 deletions
diff --git a/contrib/cube/expected/cube.out b/contrib/cube/expected/cube.out index 86b33483a54..101a63b7236 100644 --- a/contrib/cube/expected/cube.out +++ b/contrib/cube/expected/cube.out @@ -257,88 +257,144 @@ SELECT '[(0,0,0,0),(1,0,0,0)]'::cube AS cube; -- invalid input: parse errors SELECT ''::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT ''::cube AS cube; + ^ DETAIL: syntax error at end of input SELECT 'ABC'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT 'ABC'::cube AS cube; + ^ DETAIL: syntax error at or near "A" SELECT '()'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '()'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '[]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[]'::cube AS cube; + ^ DETAIL: syntax error at or near "]" SELECT '[()]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[()]'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '[(1)]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1)]'::cube AS cube; + ^ DETAIL: syntax error at or near "]" SELECT '[(1),]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1),]'::cube AS cube; + ^ DETAIL: syntax error at or near "]" SELECT '[(1),2]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1),2]'::cube AS cube; + ^ DETAIL: syntax error at or near "2" SELECT '[(1),(2),(3)]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1),(2),(3)]'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '1,'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '1,'::cube AS cube; + ^ DETAIL: syntax error at end of input SELECT '1,2,'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '1,2,'::cube AS cube; + ^ DETAIL: syntax error at end of input SELECT '1,,2'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '1,,2'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '(1,)'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '(1,)'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '(1,2,)'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '(1,2,)'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '(1,,2)'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '(1,,2)'::cube AS cube; + ^ DETAIL: syntax error at or near "," -- invalid input: semantic errors and trailing garbage SELECT '[(1),(2)],'::cube AS cube; -- 0 ERROR: bad cube representation +LINE 1: SELECT '[(1),(2)],'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '[(1,2,3),(2,3)]'::cube AS cube; -- 1 ERROR: bad cube representation +LINE 1: SELECT '[(1,2,3),(2,3)]'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2,3) and (2,3). SELECT '[(1,2),(1,2,3)]'::cube AS cube; -- 1 ERROR: bad cube representation +LINE 1: SELECT '[(1,2),(1,2,3)]'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2) and (1,2,3). SELECT '(1),(2),'::cube AS cube; -- 2 ERROR: bad cube representation +LINE 1: SELECT '(1),(2),'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '(1,2,3),(2,3)'::cube AS cube; -- 3 ERROR: bad cube representation +LINE 1: SELECT '(1,2,3),(2,3)'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2,3) and (2,3). SELECT '(1,2),(1,2,3)'::cube AS cube; -- 3 ERROR: bad cube representation +LINE 1: SELECT '(1,2),(1,2,3)'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2) and (1,2,3). SELECT '(1,2,3)ab'::cube AS cube; -- 4 ERROR: bad cube representation +LINE 1: SELECT '(1,2,3)ab'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '(1,2,3)a'::cube AS cube; -- 5 ERROR: bad cube representation +LINE 1: SELECT '(1,2,3)a'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '(1,2)('::cube AS cube; -- 5 ERROR: bad cube representation +LINE 1: SELECT '(1,2)('::cube AS cube; + ^ DETAIL: syntax error at or near "(" SELECT '1,2ab'::cube AS cube; -- 6 ERROR: bad cube representation +LINE 1: SELECT '1,2ab'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '1 e7'::cube AS cube; -- 6 ERROR: bad cube representation +LINE 1: SELECT '1 e7'::cube AS cube; + ^ DETAIL: syntax error at or near "e" SELECT '1,2a'::cube AS cube; -- 7 ERROR: bad cube representation +LINE 1: SELECT '1,2a'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '1..2'::cube AS cube; -- 7 ERROR: bad cube representation +LINE 1: SELECT '1..2'::cube AS cube; + ^ DETAIL: syntax error at or near ".2" -- -- Testing building cubes from float8 values @@ -430,9 +486,13 @@ ERROR: Index out of bounds -- select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)'::cube; ERROR: bad cube representation +LINE 1: select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0... + ^ DETAIL: A cube cannot have more than 100 dimensions. select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)'::cube; ERROR: bad cube representation +LINE 1: select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0... + ^ DETAIL: A cube cannot have more than 100 dimensions. -- -- testing the operators diff --git a/contrib/cube/expected/cube_1.out b/contrib/cube/expected/cube_1.out index 8609c261062..55f6861dafb 100644 --- a/contrib/cube/expected/cube_1.out +++ b/contrib/cube/expected/cube_1.out @@ -257,88 +257,144 @@ SELECT '[(0,0,0,0),(1,0,0,0)]'::cube AS cube; -- invalid input: parse errors SELECT ''::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT ''::cube AS cube; + ^ DETAIL: syntax error at end of input SELECT 'ABC'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT 'ABC'::cube AS cube; + ^ DETAIL: syntax error at or near "A" SELECT '()'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '()'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '[]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[]'::cube AS cube; + ^ DETAIL: syntax error at or near "]" SELECT '[()]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[()]'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '[(1)]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1)]'::cube AS cube; + ^ DETAIL: syntax error at or near "]" SELECT '[(1),]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1),]'::cube AS cube; + ^ DETAIL: syntax error at or near "]" SELECT '[(1),2]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1),2]'::cube AS cube; + ^ DETAIL: syntax error at or near "2" SELECT '[(1),(2),(3)]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1),(2),(3)]'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '1,'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '1,'::cube AS cube; + ^ DETAIL: syntax error at end of input SELECT '1,2,'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '1,2,'::cube AS cube; + ^ DETAIL: syntax error at end of input SELECT '1,,2'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '1,,2'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '(1,)'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '(1,)'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '(1,2,)'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '(1,2,)'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '(1,,2)'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '(1,,2)'::cube AS cube; + ^ DETAIL: syntax error at or near "," -- invalid input: semantic errors and trailing garbage SELECT '[(1),(2)],'::cube AS cube; -- 0 ERROR: bad cube representation +LINE 1: SELECT '[(1),(2)],'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '[(1,2,3),(2,3)]'::cube AS cube; -- 1 ERROR: bad cube representation +LINE 1: SELECT '[(1,2,3),(2,3)]'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2,3) and (2,3). SELECT '[(1,2),(1,2,3)]'::cube AS cube; -- 1 ERROR: bad cube representation +LINE 1: SELECT '[(1,2),(1,2,3)]'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2) and (1,2,3). SELECT '(1),(2),'::cube AS cube; -- 2 ERROR: bad cube representation +LINE 1: SELECT '(1),(2),'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '(1,2,3),(2,3)'::cube AS cube; -- 3 ERROR: bad cube representation +LINE 1: SELECT '(1,2,3),(2,3)'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2,3) and (2,3). SELECT '(1,2),(1,2,3)'::cube AS cube; -- 3 ERROR: bad cube representation +LINE 1: SELECT '(1,2),(1,2,3)'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2) and (1,2,3). SELECT '(1,2,3)ab'::cube AS cube; -- 4 ERROR: bad cube representation +LINE 1: SELECT '(1,2,3)ab'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '(1,2,3)a'::cube AS cube; -- 5 ERROR: bad cube representation +LINE 1: SELECT '(1,2,3)a'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '(1,2)('::cube AS cube; -- 5 ERROR: bad cube representation +LINE 1: SELECT '(1,2)('::cube AS cube; + ^ DETAIL: syntax error at or near "(" SELECT '1,2ab'::cube AS cube; -- 6 ERROR: bad cube representation +LINE 1: SELECT '1,2ab'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '1 e7'::cube AS cube; -- 6 ERROR: bad cube representation +LINE 1: SELECT '1 e7'::cube AS cube; + ^ DETAIL: syntax error at or near "e" SELECT '1,2a'::cube AS cube; -- 7 ERROR: bad cube representation +LINE 1: SELECT '1,2a'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '1..2'::cube AS cube; -- 7 ERROR: bad cube representation +LINE 1: SELECT '1..2'::cube AS cube; + ^ DETAIL: syntax error at or near ".2" -- -- Testing building cubes from float8 values @@ -430,9 +486,13 @@ ERROR: Index out of bounds -- select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)'::cube; ERROR: bad cube representation +LINE 1: select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0... + ^ DETAIL: A cube cannot have more than 100 dimensions. select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)'::cube; ERROR: bad cube representation +LINE 1: select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0... + ^ DETAIL: A cube cannot have more than 100 dimensions. -- -- testing the operators diff --git a/contrib/cube/expected/cube_2.out b/contrib/cube/expected/cube_2.out index d8737c3cb38..c4493958180 100644 --- a/contrib/cube/expected/cube_2.out +++ b/contrib/cube/expected/cube_2.out @@ -257,88 +257,144 @@ SELECT '[(0,0,0,0),(1,0,0,0)]'::cube AS cube; -- invalid input: parse errors SELECT ''::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT ''::cube AS cube; + ^ DETAIL: syntax error at end of input SELECT 'ABC'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT 'ABC'::cube AS cube; + ^ DETAIL: syntax error at or near "A" SELECT '()'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '()'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '[]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[]'::cube AS cube; + ^ DETAIL: syntax error at or near "]" SELECT '[()]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[()]'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '[(1)]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1)]'::cube AS cube; + ^ DETAIL: syntax error at or near "]" SELECT '[(1),]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1),]'::cube AS cube; + ^ DETAIL: syntax error at or near "]" SELECT '[(1),2]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1),2]'::cube AS cube; + ^ DETAIL: syntax error at or near "2" SELECT '[(1),(2),(3)]'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '[(1),(2),(3)]'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '1,'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '1,'::cube AS cube; + ^ DETAIL: syntax error at end of input SELECT '1,2,'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '1,2,'::cube AS cube; + ^ DETAIL: syntax error at end of input SELECT '1,,2'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '1,,2'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '(1,)'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '(1,)'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '(1,2,)'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '(1,2,)'::cube AS cube; + ^ DETAIL: syntax error at or near ")" SELECT '(1,,2)'::cube AS cube; ERROR: bad cube representation +LINE 1: SELECT '(1,,2)'::cube AS cube; + ^ DETAIL: syntax error at or near "," -- invalid input: semantic errors and trailing garbage SELECT '[(1),(2)],'::cube AS cube; -- 0 ERROR: bad cube representation +LINE 1: SELECT '[(1),(2)],'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '[(1,2,3),(2,3)]'::cube AS cube; -- 1 ERROR: bad cube representation +LINE 1: SELECT '[(1,2,3),(2,3)]'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2,3) and (2,3). SELECT '[(1,2),(1,2,3)]'::cube AS cube; -- 1 ERROR: bad cube representation +LINE 1: SELECT '[(1,2),(1,2,3)]'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2) and (1,2,3). SELECT '(1),(2),'::cube AS cube; -- 2 ERROR: bad cube representation +LINE 1: SELECT '(1),(2),'::cube AS cube; + ^ DETAIL: syntax error at or near "," SELECT '(1,2,3),(2,3)'::cube AS cube; -- 3 ERROR: bad cube representation +LINE 1: SELECT '(1,2,3),(2,3)'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2,3) and (2,3). SELECT '(1,2),(1,2,3)'::cube AS cube; -- 3 ERROR: bad cube representation +LINE 1: SELECT '(1,2),(1,2,3)'::cube AS cube; + ^ DETAIL: Different point dimensions in (1,2) and (1,2,3). SELECT '(1,2,3)ab'::cube AS cube; -- 4 ERROR: bad cube representation +LINE 1: SELECT '(1,2,3)ab'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '(1,2,3)a'::cube AS cube; -- 5 ERROR: bad cube representation +LINE 1: SELECT '(1,2,3)a'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '(1,2)('::cube AS cube; -- 5 ERROR: bad cube representation +LINE 1: SELECT '(1,2)('::cube AS cube; + ^ DETAIL: syntax error at or near "(" SELECT '1,2ab'::cube AS cube; -- 6 ERROR: bad cube representation +LINE 1: SELECT '1,2ab'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '1 e7'::cube AS cube; -- 6 ERROR: bad cube representation +LINE 1: SELECT '1 e7'::cube AS cube; + ^ DETAIL: syntax error at or near "e" SELECT '1,2a'::cube AS cube; -- 7 ERROR: bad cube representation +LINE 1: SELECT '1,2a'::cube AS cube; + ^ DETAIL: syntax error at or near "a" SELECT '1..2'::cube AS cube; -- 7 ERROR: bad cube representation +LINE 1: SELECT '1..2'::cube AS cube; + ^ DETAIL: syntax error at or near ".2" -- -- Testing building cubes from float8 values @@ -430,9 +486,13 @@ ERROR: Index out of bounds -- select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)'::cube; ERROR: bad cube representation +LINE 1: select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0... + ^ DETAIL: A cube cannot have more than 100 dimensions. select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)'::cube; ERROR: bad cube representation +LINE 1: select '(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0... + ^ DETAIL: A cube cannot have more than 100 dimensions. -- -- testing the operators |
