/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/gis/t/ |
H A D | st_x.test | 1 # This test tests the ST_X function. 4 SELECT ST_X(NULL); 5 SELECT ST_X(NULL, NULL); 6 SELECT ST_X(NULL, 1); 7 SELECT ST_X(ST_GEOMFROMTEXT('POINT(0 0)', 4326), NULL); 11 DO ST_X(x'000000000123456789abcdef'); 26 DO ST_X(ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1)', 0)); 30 DO ST_X(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 0)); 71 SELECT ST_X(ST_GEOMFROMTEXT('POINT(1 0)', 0)); 75 SELECT ST_X(ST_GEOMFROMTEXT('POINT(1 0)', 3857)); [all …]
|
H A D | spatial_utility_functions_xy.test | 58 --echo # ST_X(point) 90 --echo # ST_X(point) 97 SELECT ST_ASTEXT(ST_X(NULL, 5)); 98 SELECT ST_ASTEXT(ST_X(POINT(4, 5), NULL)); 99 SELECT ST_ASTEXT(ST_X(NULL, NULL)); 101 SELECT ST_ASTEXT(ST_X(ST_POINTFROMWKB(NULL), NULL)); 116 SELECT ST_ASTEXT(ST_X(ST_POINTFROMTEXT('NULL'), NULL)); 166 SELECT ST_X(POINT(pow(2, 2048), 4), 5); 173 SELECT ST_X(POINT(4, pow(2, 2048)), 5); 176 SELECT ST_X(POINT(4, 5), pow(2, 2048)); [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/gis/r/ |
H A D | st_x.result | 2 SELECT ST_X(NULL); 3 ST_X(NULL) 5 SELECT ST_X(NULL, NULL); 6 ST_X(NULL, NULL) 8 SELECT ST_X(NULL, 1); 9 ST_X(NULL, 1) 12 ST_X(ST_GEOMFROMTEXT('POINT(0 0)', 4326), NULL) 15 DO ST_X(x'000000000123456789abcdef'); 74 ST_X(ST_GEOMFROMTEXT('POINT(1 0)', 0)) 81 ST_X(ST_GEOMFROMTEXT('POINT(1 0)', 3857)) [all …]
|
H A D | spatial_utility_functions_xy.result | 41 # ST_X(point) 83 # ST_X(point) 85 SELECT ST_ASTEXT(ST_X(NULL, 5)); 86 ST_ASTEXT(ST_X(NULL, 5)) 88 SELECT ST_ASTEXT(ST_X(POINT(4, 5), NULL)); 89 ST_ASTEXT(ST_X(POINT(4, 5), NULL)) 91 SELECT ST_ASTEXT(ST_X(NULL, NULL)); 92 ST_ASTEXT(ST_X(NULL, NULL)) 141 SELECT ST_X(POINT(pow(2, 2048), 4), 5); 147 SELECT ST_X(POINT(4, pow(2, 2048)), 5); [all …]
|
/dports/databases/postgis32/postgis-3.2.0/regress/core/ |
H A D | point_coordinates.sql | 1 SELECT 'X1', ST_X('POINT (0 0)'::geometry); 2 SELECT 'X2', ST_X('POINTZ (1 2 3)'::geometry); 3 SELECT 'X3', ST_X('POINTM (6 7 8)'::geometry); 4 SELECT 'X4', ST_X('POINTZM (10 11 12 13)'::geometry); 5 SELECT 'X5', ST_X('MULTIPOINT ((0 0), (1 1))'::geometry); 6 SELECT 'X6', ST_X('LINESTRING (0 0, 1 1)'::geometry); 7 SELECT 'X7', ST_X('GEOMETRYCOLLECTION (POINT(0 0))'::geometry); 8 SELECT 'X8', ST_X('GEOMETRYCOLLECTION (POINT(0 1), LINESTRING(0 0, 1 1))'::geometry);
|
H A D | quantize_coordinates.sql | 8 SELECT 't4', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 3)) = ST_Y(ST_QuantizeCoord… 10 SELECT 't5', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 7, 4)) != ST_Y(ST_QuantizeC… 13 SELECT 't6', bool_and(abs(ST_X(geom)-ST_X(ST_QuantizeCoordinates(geom, i))) < pow(10, -i))
|
H A D | point_coordinates_expected | 5 ERROR: Argument to ST_X() must have type POINT 6 ERROR: Argument to ST_X() must have type POINT 7 ERROR: Argument to ST_X() must have type POINT 8 ERROR: Argument to ST_X() must have type POINT
|
/dports/databases/postgis30/postgis-3.0.4/regress/core/ |
H A D | point_coordinates.sql | 1 SELECT 'X1', ST_X('POINT (0 0)'::geometry); 2 SELECT 'X2', ST_X('POINTZ (1 2 3)'::geometry); 3 SELECT 'X3', ST_X('POINTM (6 7 8)'::geometry); 4 SELECT 'X4', ST_X('POINTZM (10 11 12 13)'::geometry); 5 SELECT 'X5', ST_X('MULTIPOINT ((0 0), (1 1))'::geometry); 6 SELECT 'X6', ST_X('LINESTRING (0 0, 1 1)'::geometry); 7 SELECT 'X7', ST_X('GEOMETRYCOLLECTION (POINT(0 0))'::geometry); 8 SELECT 'X8', ST_X('GEOMETRYCOLLECTION (POINT(0 1), LINESTRING(0 0, 1 1))'::geometry);
|
H A D | quantize_coordinates.sql | 8 SELECT 't4', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 3)) = ST_Y(ST_QuantizeCoord… 10 SELECT 't5', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 7, 4)) != ST_Y(ST_QuantizeC… 13 SELECT 't6', bool_and(abs(ST_X(geom)-ST_X(ST_QuantizeCoordinates(geom, i))) < pow(10, -i))
|
H A D | point_coordinates_expected | 5 ERROR: Argument to ST_X() must have type POINT 6 ERROR: Argument to ST_X() must have type POINT 7 ERROR: Argument to ST_X() must have type POINT 8 ERROR: Argument to ST_X() must have type POINT
|
/dports/databases/postgis31/postgis-3.1.4/regress/core/ |
H A D | point_coordinates.sql | 1 SELECT 'X1', ST_X('POINT (0 0)'::geometry); 2 SELECT 'X2', ST_X('POINTZ (1 2 3)'::geometry); 3 SELECT 'X3', ST_X('POINTM (6 7 8)'::geometry); 4 SELECT 'X4', ST_X('POINTZM (10 11 12 13)'::geometry); 5 SELECT 'X5', ST_X('MULTIPOINT ((0 0), (1 1))'::geometry); 6 SELECT 'X6', ST_X('LINESTRING (0 0, 1 1)'::geometry); 7 SELECT 'X7', ST_X('GEOMETRYCOLLECTION (POINT(0 0))'::geometry); 8 SELECT 'X8', ST_X('GEOMETRYCOLLECTION (POINT(0 1), LINESTRING(0 0, 1 1))'::geometry);
|
H A D | quantize_coordinates.sql | 8 SELECT 't4', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 3)) = ST_Y(ST_QuantizeCoord… 10 SELECT 't5', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 7, 4)) != ST_Y(ST_QuantizeC… 13 SELECT 't6', bool_and(abs(ST_X(geom)-ST_X(ST_QuantizeCoordinates(geom, i))) < pow(10, -i))
|
H A D | point_coordinates_expected | 5 ERROR: Argument to ST_X() must have type POINT 6 ERROR: Argument to ST_X() must have type POINT 7 ERROR: Argument to ST_X() must have type POINT 8 ERROR: Argument to ST_X() must have type POINT
|
/dports/games/libretro-prboom/libretro-prboom-cc80175/src/ |
H A D | st_stuff.c | 69 #define ST_FX (ST_X+143) 100 #define ST_FACESX (ST_X+143) 125 #define ST_AMMOX (ST_X+44) 133 #define ST_HEALTHX (ST_X+90) 140 #define ST_ARMSX (ST_X+111) 153 #define ST_FRAGSX (ST_X+138) 162 #define ST_ARMORX (ST_X+221) 171 #define ST_KEY0X (ST_X+239) 177 #define ST_KEY1X (ST_X+239) 183 #define ST_KEY2X (ST_X+239) [all …]
|
/dports/games/prboom/prboom-2.5.0/src/ |
H A D | st_stuff.c | 65 #define ST_X 0 macro 69 #define ST_FX (ST_X+143) 100 #define ST_FACESX (ST_X+143) 125 #define ST_AMMOX (ST_X+44) 133 #define ST_HEALTHX (ST_X+90) 140 #define ST_ARMSX (ST_X+111) 142 #define ST_ARMSBGX (ST_X+104) 153 #define ST_FRAGSX (ST_X+138) 162 #define ST_ARMORX (ST_X+221) 171 #define ST_KEY0X (ST_X+239) [all …]
|
/dports/games/prboom-plus/prboom-plus-2.5.1.3/src/ |
H A D | st_stuff.c | 70 #define ST_X 0 macro 74 #define ST_FX (ST_X+143) 105 #define ST_FACESX (ST_X+143) 130 #define ST_AMMOX (ST_X+44) 138 #define ST_HEALTHX (ST_X+90) 145 #define ST_ARMSX (ST_X+111) 147 #define ST_ARMSBGX (ST_X+104) 158 #define ST_FRAGSX (ST_X+138) 167 #define ST_ARMORX (ST_X+221) 176 #define ST_KEY0X (ST_X+239) [all …]
|
/dports/databases/postgis25/postgis-2.5.5/regress/ |
H A D | quantize_coordinates.sql | 8 SELECT 't4', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 3)) = ST_Y(ST_QuantizeCoord… 10 SELECT 't5', ST_X(ST_QuantizeCoordinates('POINT (1.2345678 1.2345678)', 7, 4)) != ST_Y(ST_QuantizeC… 13 SELECT 't6', bool_and(abs(ST_X(geom)-ST_X(ST_QuantizeCoordinates(geom, i))) < pow(10, -i))
|
/dports/databases/pgrouting/pgrouting-3.2.0/sql/topology/ |
H A D | extractVertices.sql | 183 …SELECT row_number() over(ORDER BY ST_X(geom), ST_Y(geom)) AS id, in_edges, out_edges, ST_X(geom), … 202 SELECT DISTINCT ST_X(startpoint) AS x, ST_Y(startpoint) AS y, startpoint AS geom 207 SELECT DISTINCT ST_X(endpoint) AS x, ST_Y(endpoint) AS y, endpoint AS geom 217 …SELECT row_number() over(ORDER BY ST_X(geom), ST_Y(geom)) AS id, NULL::BIGINT[], NULL::BIGINT[], … 257 …SELECT row_number() over(ORDER BY ST_X(geom), ST_Y(geom)) AS id, in_edges, out_edges, ST_X(geom),… 271 SELECT DISTINCT ST_X(startpoint) AS x, ST_Y(startpoint) AS y, startpoint AS geom 276 SELECT DISTINCT ST_X(endpoint) AS x, ST_Y(endpoint) AS y, endpoint AS geom 286 …SELECT row_number() over(ORDER BY ST_X(geom), ST_Y(geom)) AS id, NULL::BIGINT[], NULL::BIGINT[], …
|
/dports/databases/rrdtool/rrdtool-1.7.2/tests/ |
H A D | create-with-source-3 | 65 ST_X=$ST 108 $RRDTOOL create ${PREFIX}a2_x.rrd --start $ST_X --step 60 --source ${PREFIX}ab2_xy.rrd DS:a:GAUGE:1… 116 $RRDTOOL create ${PREFIX}b2_x.rrd --start $ST_X --step 60 --source ${PREFIX}ab2_xy.rrd DS:b:GAUGE:1… 127 $RRDTOOL dump ${PREFIX}a1_y.rrd | data_filter_by_time $FIRST $ST_X > ${PREFIX}a1_y.xml 128 $RRDTOOL dump ${PREFIX}a2_y.rrd | data_filter_by_time $FIRST $ST_X > ${PREFIX}a2_y.xml 136 $RRDTOOL dump ${PREFIX}b1_y.rrd | data_filter_by_time $FIRST $ST_X > ${PREFIX}b1_y.xml 137 $RRDTOOL dump ${PREFIX}b2_y.rrd | data_filter_by_time $FIRST $ST_X > ${PREFIX}b2_y.xml
|
/dports/databases/spatialite/libspatialite-5.0.1/test/sql_stmt_tests/ |
H A D | st_x1.testcase | 3 SELECT ST_X(MakePointZ(-71.1043443253471, 42.3150676015829, 4326)); 6 ST_X(MakePointZ(-71.1043443253471, 42.3150676015829, 4326))
|
H A D | st_x7.testcase | 3 SELECT ST_X(MakePointZ(-71.1043443253471, 42.3150676015829, 0.0038723129645, 4326)); 6 ST_X(MakePointZ(-71.1043443253471, 42.3150676015829, 0.0038723129645, 4326))
|
H A D | st_x8.testcase | 3 SELECT ST_X(MakePointM(-71.1043443253471, 42.3150676015829, 12.6389, 4326)); 6 ST_X(MakePointM(-71.1043443253471, 42.3150676015829, 12.6389, 4326))
|
H A D | st_x9.testcase | 3 SELECT ST_X(MakePointZM(-71.1043443253471, 42.3150676015829, 0.0038723129645, 12.6389, 4326)); 6 ST_X(MakePointZM(-71.1043443253471, 42.3150676015829, 0.0038723129645, 12.6389, 4326))
|
H A D | st_x6.testcase | 3 SELECT ST_X(zeroblob(10)); 6 ST_X(zeroblob(10))
|
H A D | st_x4.testcase | 3 SELECT ST_X(GeomFromText('POINTM(136 -35 -8.6)')); 6 ST_X(GeomFromText('POINTM(136 -35 -8.6)'))
|