File: regress_proj_cache_overflow.sql

package info (click to toggle)
postgis 3.5.2%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 70,052 kB
  • sloc: ansic: 162,204; sql: 93,950; xml: 53,121; cpp: 12,646; perl: 5,658; sh: 5,369; makefile: 3,434; python: 1,205; yacc: 447; lex: 151; pascal: 58
file content (13 lines) | stat: -rw-r--r-- 1,266 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
--- Overflow proj cache
SELECT 13, count(*) FROM
(
  SELECT ST_Transform('SRID=4326; POINT(0 0)'::geometry, srid) AS g
  FROM (
    SELECT srid
    FROM spatial_ref_sys
    WHERE srid IN (
      2309, 2310, 2311, 4037, 3349, 4038, 3395, 3832, 3857, 3994, 3997, 5223, 5523, 5842, 6703, 6720, /**6722,**/ 6871, 6893/**, 7777, 7778, 7779, 7780, 7781, 7782, 7783, 7784, 7785, 7786, 7787**/, 8035, 8036, 32605, 32606, 32607, 32608, 32609, 32610, 32611, 32612, 32613/**, 32614, 32615**/, 32601, 32602, 32603, 32604/**, 32616, 32617**/, 32618, 32619, 32620, 32621, 32622, 32623, 32624, 32625, 32626, 32627, 32628, 32629, 32630, 32631, 32632, 32633, 32634, 32635, 32636, 32637, 32638, 32639, 32640, 32641, 32642, 32643/**, 32644, 32645, 32646, 32647, 32648**/, 32649, 32650, 32651, 32652, 32653, 32654, 32655, 32656, 32657, 32658, 32659, 32660/**, 32664, 32665, 32666, 32667**/, 32701, 32702, 32703, 32704, 32705, 32706, 32707, 32708, 32709, 32710, 32711, 32712, 32713/**, 32714, 32715, 32716, 32717**/, 32718, 32719, 32720, 32721, 32722, 32723, 32724, 32725, 32726, 32727, 32728, 32729, 32730, 32731, 32732, 32733, 32734, 32735, 32736, 32737, 32738, 32739, 32740, 32741, 32742/**, 32743, 32744, 32745, 32746, 32747**/, 32748, 32749, 32750

 )) _a
) _b
WHERE g IS NOT NULL;