Debian Codegraph @

mysql-test/suite/compat/oracle/t/gis.test

raw
1 -- source include/have_geometry.inc
2
3 SET sql_mode=ORACLE;
4
5
6 SELECT CONTAINS(POINT(1,1), POINT(1,1));
7 SELECT CONTAINS(POINT(1,1), POINT(0,0));
8
9 SELECT WITHIN(POINT(1,1), POINT(1,1));
10 SELECT WITHIN(POINT(1,1), POINT(0,0));
11
12 --echo #
13 --echo # Start of 10.5 tests
14 --echo #
15
16 --echo #
17 --echo # MDEV-19994 Add class Function_collection
18 --echo #
19
20 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
21 SELECT CONTAINS();
22 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
23 SELECT CONTAINS(POINT(1,1));
24 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
25 SELECT CONTAINS(POINT(1,1), POINT(1,1), POINT(1,1));
26
27 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
28 SELECT WITHIN();
29 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
30 SELECT WITHIN(POINT(1,1));
31 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
32 SELECT WITHIN(POINT(1,1), POINT(1,1), POINT(1,1));
33
34 --echo #
35 --echo # MDEV-20009 Add CAST(expr AS pluggable_type)
36 --echo #
37
38 --error ER_UNKNOWN_OPERATOR
39 SELECT CAST(1 AS GEOMETRY);
40 --error ER_UNKNOWN_OPERATOR
41 SELECT CAST(1 AS GEOMETRYCOLLECTION);
42 --error ER_UNKNOWN_OPERATOR
43 SELECT CAST(1 AS POINT);
44 --error ER_UNKNOWN_OPERATOR
45 SELECT CAST(1 AS LINESTRING);
46 --error ER_UNKNOWN_OPERATOR
47 SELECT CAST(1 AS POLYGON);
48 --error ER_UNKNOWN_OPERATOR
49 SELECT CAST(1 AS MULTIPOINT);
50 --error ER_UNKNOWN_OPERATOR
51 SELECT CAST(1 AS MULTILINESTRING);
52 --error ER_UNKNOWN_OPERATOR
53 SELECT CAST(1 AS MULTIPOLYGON);
54
55
56 --error ER_UNKNOWN_OPERATOR
57 SELECT CONVERT(1, GEOMETRY);
58 --error ER_UNKNOWN_OPERATOR
59 SELECT CONVERT(1, GEOMETRYCOLLECTION);
60 --error ER_UNKNOWN_OPERATOR
61 SELECT CONVERT(1, POINT);
62 --error ER_UNKNOWN_OPERATOR
63 SELECT CONVERT(1, LINESTRING);
64 --error ER_UNKNOWN_OPERATOR
65 SELECT CONVERT(1, POLYGON);
66 --error ER_UNKNOWN_OPERATOR
67 SELECT CONVERT(1, MULTIPOINT);
68 --error ER_UNKNOWN_OPERATOR
69 SELECT CONVERT(1, MULTILINESTRING);
70 --error ER_UNKNOWN_OPERATOR
71 SELECT CONVERT(1, MULTIPOLYGON);
72
73
74 --echo #
75 --echo # End of 10.5 tests
76 --echo #