Debian Codegraph @

mysql-test/suite/compat/oracle/r/gis.result

raw
1 SET sql_mode=ORACLE;
2 SELECT CONTAINS(POINT(1,1), POINT(1,1));
3 CONTAINS(POINT(1,1), POINT(1,1))
4 1
5 SELECT CONTAINS(POINT(1,1), POINT(0,0));
6 CONTAINS(POINT(1,1), POINT(0,0))
7 0
8 SELECT WITHIN(POINT(1,1), POINT(1,1));
9 WITHIN(POINT(1,1), POINT(1,1))
10 1
11 SELECT WITHIN(POINT(1,1), POINT(0,0));
12 WITHIN(POINT(1,1), POINT(0,0))
13 0
14 #
15 # Start of 10.5 tests
16 #
17 #
18 # MDEV-19994 Add class Function_collection
19 #
20 SELECT CONTAINS();
21 ERROR 42000: Incorrect parameter count in the call to native function 'CONTAINS()'
22 SELECT CONTAINS(POINT(1,1));
23 ERROR 42000: Incorrect parameter count in the call to native function 'CONTAINS(POINT(1,1))'
24 SELECT CONTAINS(POINT(1,1), POINT(1,1), POINT(1,1));
25 ERROR 42000: Incorrect parameter count in the call to native function 'CONTAINS(POINT(1,1), POINT(1,1), POINT(1,1))'
26 SELECT WITHIN();
27 ERROR 42000: Incorrect parameter count in the call to native function 'WITHIN()'
28 SELECT WITHIN(POINT(1,1));
29 ERROR 42000: Incorrect parameter count in the call to native function 'WITHIN(POINT(1,1))'
30 SELECT WITHIN(POINT(1,1), POINT(1,1), POINT(1,1));
31 ERROR 42000: Incorrect parameter count in the call to native function 'WITHIN(POINT(1,1), POINT(1,1), POINT(1,1))'
32 #
33 # MDEV-20009 Add CAST(expr AS pluggable_type)
34 #
35 SELECT CAST(1 AS GEOMETRY);
36 ERROR HY000: Operator does not exist: 'CAST(expr AS geometry)'
37 SELECT CAST(1 AS GEOMETRYCOLLECTION);
38 ERROR HY000: Operator does not exist: 'CAST(expr AS geometrycollection)'
39 SELECT CAST(1 AS POINT);
40 ERROR HY000: Operator does not exist: 'CAST(expr AS point)'
41 SELECT CAST(1 AS LINESTRING);
42 ERROR HY000: Operator does not exist: 'CAST(expr AS linestring)'
43 SELECT CAST(1 AS POLYGON);
44 ERROR HY000: Operator does not exist: 'CAST(expr AS polygon)'
45 SELECT CAST(1 AS MULTIPOINT);
46 ERROR HY000: Operator does not exist: 'CAST(expr AS multipoint)'
47 SELECT CAST(1 AS MULTILINESTRING);
48 ERROR HY000: Operator does not exist: 'CAST(expr AS multilinestring)'
49 SELECT CAST(1 AS MULTIPOLYGON);
50 ERROR HY000: Operator does not exist: 'CAST(expr AS multipolygon)'
51 SELECT CONVERT(1, GEOMETRY);
52 ERROR HY000: Operator does not exist: 'CAST(expr AS geometry)'
53 SELECT CONVERT(1, GEOMETRYCOLLECTION);
54 ERROR HY000: Operator does not exist: 'CAST(expr AS geometrycollection)'
55 SELECT CONVERT(1, POINT);
56 ERROR HY000: Operator does not exist: 'CAST(expr AS point)'
57 SELECT CONVERT(1, LINESTRING);
58 ERROR HY000: Operator does not exist: 'CAST(expr AS linestring)'
59 SELECT CONVERT(1, POLYGON);
60 ERROR HY000: Operator does not exist: 'CAST(expr AS polygon)'
61 SELECT CONVERT(1, MULTIPOINT);
62 ERROR HY000: Operator does not exist: 'CAST(expr AS multipoint)'
63 SELECT CONVERT(1, MULTILINESTRING);
64 ERROR HY000: Operator does not exist: 'CAST(expr AS multilinestring)'
65 SELECT CONVERT(1, MULTIPOLYGON);
66 ERROR HY000: Operator does not exist: 'CAST(expr AS multipolygon)'
67 #
68 # End of 10.5 tests
69 #