)]}'
{
  "commit": "4e8b2fbcfe70df15736e1349c4efc92ea657a72d",
  "tree": "3e6c52c279fc502293fb948962eefe2eec411725",
  "parents": [
    "6571d3d20cf3e1cba8ef71a5af619d5d8454d635"
  ],
  "author": {
    "name": "sshiv012",
    "email": "sshiv012@ucr.edu",
    "time": "Fri Apr 24 16:11:42 2026 -0700"
  },
  "committer": {
    "name": "Ian Maxon",
    "email": "imaxon@apache.org",
    "time": "Wed May 13 17:43:28 2026 +0000"
  },
  "message": "[ASTERIXDB-3542][SQL++] Add CRS support and st_transform function\n\n  - New metadata entity: CoordinateReferenceSystem (SRID, name, WKT)\n    backed by a dedicated metadata index and tuple translator\n  - DDL: CREATE CRS, DROP CRS\n  - SQL++ parser (SQLPP.jj): grammar rules for CREATE/DROP CRS\n  - ST_Transform(geom, fromSRID, toSRID): compile-time WKT lookup via\n    metadata, runtime coordinate transformation via Apache SIS\n  - ST_Distance_Spheroid(geom1, geom2): geodesic distance on WGS-84\n    ellipsoid using SIS GeodeticCalculator\n  - Metadata lock support: acquireCRSReadLock / acquireCRSWriteLock\n  - Error codes 1244-1249 covering CRS DDL and function failure modes\n  - Test suite: 13 test cases covering DDL lifecycle, ST_Transform,\n    ST_Distance_Spheroid, and negative cases\n  - Documentation: DDL reference and geo-functions markdown updated\n  - Apache SIS + GeoAPI dependencies added (asterix-geo, asterix-app)\n\nSome parts of this commit were Generated-by: Claude code\n\nChange-Id: Ia6e37080a581292744ddc9020b214926412c16ac\nReviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20968\nIntegration-Tests: Jenkins \u003cjenkins@fulliautomatix.ics.uci.edu\u003e\nReviewed-by: Ian Maxon \u003cimaxon@apache.org\u003e\nTested-by: Jenkins \u003cjenkins@fulliautomatix.ics.uci.edu\u003e\n",
  "tree_diff": [
    {
      "type": "modify",
      "old_id": "b74363d1c93a2e69047bff4e94f74aecd6c5c763",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-algebra/src/main/java/org/apache/asterix/compiler/provider/DefaultRuleSetFactory.java",
      "new_id": "bf9d4fb80545f659d1c599ca7fc29f8c5695d2b6",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-algebra/src/main/java/org/apache/asterix/compiler/provider/DefaultRuleSetFactory.java"
    },
    {
      "type": "modify",
      "old_id": "5defe1474fbde29134b0ad5c14523b8672a49715",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/base/RuleCollections.java",
      "new_id": "241bda17d4f49d17f3e25a6489f6c962c8814698",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/base/RuleCollections.java"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "fdd646b48eac7cb97a936d2ec6b8d779739f8e42",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/STTransformResolveCRSRule.java"
    },
    {
      "type": "modify",
      "old_id": "ca997e0de6c17d8b0f41775d2c0382c00b2e117c",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/util/SpatialJoinUtils.java",
      "new_id": "6279a45f5e31593a42c6abcc37f33a6cd0a57efc",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/util/SpatialJoinUtils.java"
    },
    {
      "type": "modify",
      "old_id": "7fc758bd3f63eb5fbb6f27beef7b357960468645",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-algebra/src/main/java/org/apache/asterix/translator/AbstractLangTranslator.java",
      "new_id": "2b6dbbc01f71299c0343ceef7c9df13023e90987",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-algebra/src/main/java/org/apache/asterix/translator/AbstractLangTranslator.java"
    },
    {
      "type": "modify",
      "old_id": "059c8f6d48b02083f85c58e211501ea07d29a655",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-app/pom.xml",
      "new_id": "30eb1a9efdf9c8061b9593018bb4b728fe8b0a9e",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/pom.xml"
    },
    {
      "type": "modify",
      "old_id": "ea42a3d1db330605fad1dcd9023a5ba73d0c56ab",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-app/src/main/java/org/apache/asterix/app/translator/QueryTranslator.java",
      "new_id": "df52f9cd1bd1c9a99e48dc525b5d8f00e5b9fa31",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/main/java/org/apache/asterix/app/translator/QueryTranslator.java"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "4a822bf7d6fe41e3af529b0df105e2091cf778e2",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/main/java/org/apache/asterix/app/translator/handlers/CRSStatementHandler.java"
    },
    {
      "type": "modify",
      "old_id": "876b010348521d82ea5b28aedd7a7856f03c24a9",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-app/src/test/resources/metadata/results/basic/metadata_dataset/metadata_dataset.1.adm",
      "new_id": "891f53b65e95ba15fa932e8cf85becc331a4eaea",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/metadata/results/basic/metadata_dataset/metadata_dataset.1.adm"
    },
    {
      "type": "modify",
      "old_id": "1e3618afbc7c7ff21aeec2c63a421049a4d88d0f",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-app/src/test/resources/metadata/results/basic/metadata_datatype/metadata_datatype.1.adm",
      "new_id": "f8105ebbe972789f67485ea1c471e122bc1e43e3",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/metadata/results/basic/metadata_datatype/metadata_datatype.1.adm"
    },
    {
      "type": "modify",
      "old_id": "5973911fead5ce499f1404446c004fc274ecad90",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-app/src/test/resources/metadata/results/basic/metadata_index/metadata_index.1.adm",
      "new_id": "10c625477b0ec7b8bc82256dcf5d763feb89c42e",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/metadata/results/basic/metadata_index/metadata_index.1.adm"
    },
    {
      "type": "modify",
      "old_id": "ef5b44091c323ad512d0368d16c38c4a99d4383a",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-app/src/test/resources/metadata/results/basic/metadata_selfjoin/metadata_selfjoin.1.adm",
      "new_id": "2390ceb5d629c11763f7acc8bb1ee1e34ad2e22c",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/metadata/results/basic/metadata_selfjoin/metadata_selfjoin.1.adm"
    },
    {
      "type": "modify",
      "old_id": "ce37cfc81c3c7fdf46a21a905353725bf4c88aa3",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/GeoJSONQueries.xml",
      "new_id": "6847c6b2b2caa7c24a870091e5527c5f668572dd",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/GeoJSONQueries.xml"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "be2f55e615e40220c65417a9ee89e86ca25eca8d",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/dataverse-scoping/dataverse-scoping.01.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "7f3841f65196cbd95c9ba367dbf87f61e38931e1",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/dataverse-scoping/dataverse-scoping.02.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "f36a75a6c7a6613637a0548167e2409e5cdeb96c",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/dataverse-scoping/dataverse-scoping.03.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "de236eea9a7350d90345607002147a5ea73dcdfc",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/dataverse-scoping/dataverse-scoping.04.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "f36a75a6c7a6613637a0548167e2409e5cdeb96c",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/dataverse-scoping/dataverse-scoping.05.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "b01c4befabe4f31a13eedaba3c63e33101b70f21",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/dataverse-scoping/dataverse-scoping.06.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "9fc0c5bae963706117cfd65ebd76b972552afe5a",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.01.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "3f590eb97232d84069cd0aa374e0e575a59dae95",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.02.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "8335a9319b9592ea5e136e388999c026478c6f24",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.03.update.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "2df0518367b18f3e714905ea156bf645592db3ad",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.04.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "a13f66df56ede18cf1711e8059bd931175cb83d1",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.05.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "be6618dcc6753040f8324fe2c2a772d4b0b916ce",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.06.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "87ee630cdc705a9f91c2a9fe066e54e3c68c389f",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.08.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "35fb4ed798d0b92d8679bd3495b20aa33ac9f0b3",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.09.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "e74b41f123250b5e17541068d6d2c5d4fa47b1e4",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.10.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "5e8355aa0586e030ae2174785d1063e3cbcf06c1",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.11.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "800106252a91d0f7aa74c8507d36230245b3d755",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/functions/crs.99.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "61ed6af2f0d290ff24eeacadc8af7b4ad2ae9895",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/negative/crs-create-metadata-namespace/crs-create-metadata-namespace.01.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "a771af617e5c57c32c1835643eb3319e87b5cccf",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/negative/crs-distance-spheroid-srid/crs-distance-spheroid-srid.01.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "ee8f07cc281ada0c46aae8e92f6ade39de389018",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/negative/crs-drop-not-found/crs-drop-not-found.01.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "846a4e748da70d374edba82a6a4e36f8df0b32c5",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/negative/crs-duplicate/crs-duplicate.01.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "25b73596ff2a6d8b8e9d3048f0bb3028cccb84ac",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/negative/crs-invalid-wkt/crs-invalid-wkt.01.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "49f3650f88a320870f48164548698ab4b79d1e28",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/negative/crs-transform-not-found/crs-transform-not-found.00.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "2f508c9505da06f43673650ff3a4a60ff169be42",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/negative/crs-transform-not-found/crs-transform-not-found.01.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "2ec699eaa2c0a7782ebf9db002d279e08f0aac0b",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/negative/crs-transform-not-found/crs-transform-not-found.99.ddl.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "39d0395e1964b4238a9572c447e399f3f8f4752d",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/negative/crs-transform-srid-too-large/crs-transform-srid-too-large.01.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "a979b87aa44ee96e49cfc63813bc38ab7bc5eeec",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/geojson/crs/negative/crs-transform-srid-zero/crs-transform-srid-zero.01.query.sqlpp"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "b25227ea8e1d3feb10564bb857d07d643c30b6ff",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/dataverse-scoping/dataverse-scoping.03.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "c48626c555dcc2181fb23ae810b0a162c498bb54",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/dataverse-scoping/dataverse-scoping.05.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "2bf6910d6a7482775e9799a6116b56abba24c349",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/functions/result.04.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "3b966341f9062c99528e55719e1dacea893ac6bd",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/functions/result.05.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "869f6b1e8bcea9eaa0bde756c76732efc19a62af",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/functions/result.06.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "60cb0212ebe1c61d571049cd16af1112a2b390c8",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/functions/result.08.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "40f40b0424cdc196d96255c5d0369588f6a086ff",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/functions/result.09.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "a5c04ef7016f338f17119df5e3b2df32257a5268",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/functions/result.10.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "8b137891791fe96927ad78e64b0aad7bded08bdc",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/negative-fractional/crs-fractional-srid.01.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "8b137891791fe96927ad78e64b0aad7bded08bdc",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/negative-srid-fromtext/crs-negative-srid-fromtext.01.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "8b137891791fe96927ad78e64b0aad7bded08bdc",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/negative-srid/crs-negative-srid.01.adm"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "a33fd135eba3a783b0f4466e3382cb33a5ef2fc1",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/geojson/crs/negative/crs-distance-spheroid-srid.01.adm"
    },
    {
      "type": "modify",
      "old_id": "8798c6d482c302a74a74f66fc65148ee77025af5",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/user-defined-functions/udf23/udf23.1.adm",
      "new_id": "58ee22288c033e3903399a51c5a2cd6fc614e62c",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results/user-defined-functions/udf23/udf23.1.adm"
    },
    {
      "type": "modify",
      "old_id": "d2f3fcbc5e50a2dbaff75c23f18d6676739562d4",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/user-defined-functions/udf23/udf23.1.adm",
      "new_id": "d43094018000c4779592b7de513c7b0e3c46a1c7",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/user-defined-functions/udf23/udf23.1.adm"
    },
    {
      "type": "modify",
      "old_id": "8b09580d0ad1ae3e2be0be883a88e7131c9caa24",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-common/src/main/java/org/apache/asterix/common/api/IMetadataLockManager.java",
      "new_id": "4b2d77cd3559616b6511977149b04e9b72c368ea",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-common/src/main/java/org/apache/asterix/common/api/IMetadataLockManager.java"
    },
    {
      "type": "modify",
      "old_id": "9555fd3269d97330664787ed44c378546276a338",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-common/src/main/java/org/apache/asterix/common/exceptions/ErrorCode.java",
      "new_id": "5942bfea7a56e4269fe4164e4ac5396be346280b",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-common/src/main/java/org/apache/asterix/common/exceptions/ErrorCode.java"
    },
    {
      "type": "modify",
      "old_id": "07a1442d1ba5692eb5627f338fec218622b90401",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-common/src/main/java/org/apache/asterix/common/metadata/IMetadataLockUtil.java",
      "new_id": "2064e781fc2cc5776d21721a8ce87d7bd7dc271f",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-common/src/main/java/org/apache/asterix/common/metadata/IMetadataLockUtil.java"
    },
    {
      "type": "modify",
      "old_id": "9079d886960508ac9de6e81a3ccfe2683d8a6fee",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-common/src/main/java/org/apache/asterix/common/metadata/MetadataConstants.java",
      "new_id": "041d224aef895e4843319e18c34ae6cc758584a1",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-common/src/main/java/org/apache/asterix/common/metadata/MetadataConstants.java"
    },
    {
      "type": "modify",
      "old_id": "d7dcff307d3a5e389cd5818161281ca25c40e9c2",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-common/src/main/resources/asx_errormsg/en.properties",
      "new_id": "1034864b12b599415cf6a74c9b5b14a7d30d6eb0",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-common/src/main/resources/asx_errormsg/en.properties"
    },
    {
      "type": "modify",
      "old_id": "71e6af5a31bb0ad10623a77e94b9f7a11b051309",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-doc/src/main/markdown/sqlpp/7_ddl_dml.md",
      "new_id": "4f7174cad4af5af6f404e02919e333a357d3e5f8",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-doc/src/main/markdown/sqlpp/7_ddl_dml.md"
    },
    {
      "type": "modify",
      "old_id": "e91568f4d4d50520a87edb10e91410ebf5ab0251",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-doc/src/site/markdown/geo/functions.md",
      "new_id": "f6d605cff75c115c54f168911534f0d60ccbf600",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-doc/src/site/markdown/geo/functions.md"
    },
    {
      "type": "modify",
      "old_id": "f2784ce4dbbe13540d9ded00489417a12f1fa572",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-geo/pom.xml",
      "new_id": "bd9ee2459943ce8d382278374971401dadbbdb0b",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-geo/pom.xml"
    },
    {
      "type": "modify",
      "old_id": "ba20fa4c3de4064a3be6f491db1fe45325d57f26",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-geo/src/main/java/org/apache/asterix/geo/evaluators/GeoFunctionRegistrant.java",
      "new_id": "9c370ef51a6700850c57457380fc605e9b0b66ed",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-geo/src/main/java/org/apache/asterix/geo/evaluators/GeoFunctionRegistrant.java"
    },
    {
      "type": "modify",
      "old_id": "db6615c7076fd5c890046329756cd048817ee60c",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-geo/src/main/java/org/apache/asterix/geo/evaluators/GeoFunctionTypeInferers.java",
      "new_id": "0568117afce430f9ba29381265be782d4fe4aa1d",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-geo/src/main/java/org/apache/asterix/geo/evaluators/GeoFunctionTypeInferers.java"
    },
    {
      "type": "modify",
      "old_id": "8221c313cfa56996a46fb156403d8f1e4bb0f392",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-geo/src/main/java/org/apache/asterix/geo/evaluators/functions/AbstractSTDoubleGeometryDescriptor.java",
      "new_id": "7f3b89f5f46ea0b4dc4f586ccd27b26d39f2bd83",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-geo/src/main/java/org/apache/asterix/geo/evaluators/functions/AbstractSTDoubleGeometryDescriptor.java"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "50e7b7ecab60fe64a4a97178513246452b009cd1",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-geo/src/main/java/org/apache/asterix/geo/evaluators/functions/STDistanceSpheroidDescriptor.java"
    },
    {
      "type": "modify",
      "old_id": "7ad3277189b14bb4af6d1c889b3ae541c3e5f8ca",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-geo/src/main/java/org/apache/asterix/geo/evaluators/functions/STFlipCoordinatesDescriptor.java",
      "new_id": "1c2b93af2ab5e300ef706c681431dbe74e00daee",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-geo/src/main/java/org/apache/asterix/geo/evaluators/functions/STFlipCoordinatesDescriptor.java"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "a57ca7a699937d6ea6c4edf6a388ae5ac871b23c",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-geo/src/main/java/org/apache/asterix/geo/evaluators/functions/STTransformDescriptor.java"
    },
    {
      "type": "modify",
      "old_id": "6acaa07eb126fecfba8ab729d1f06d071a52b70f",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-lang-common/src/main/java/org/apache/asterix/lang/common/base/Statement.java",
      "new_id": "7a5aa172cf5ff40597842a34b557aa6b47d71469",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-lang-common/src/main/java/org/apache/asterix/lang/common/base/Statement.java"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "2c2384546fb673ae59da00061faa3912f81a7eb5",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-lang-common/src/main/java/org/apache/asterix/lang/common/statement/crs/CRSCreateStatement.java"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "3707d8d158b1436a000f58477635fffe78de3c61",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-lang-common/src/main/java/org/apache/asterix/lang/common/statement/crs/CRSDropStatement.java"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "d3539ddf9d5927f7e1dd1b0f54a254ba00197ac6",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-lang-common/src/main/java/org/apache/asterix/lang/common/statement/crs/CRSStatement.java"
    },
    {
      "type": "modify",
      "old_id": "b08750c60e055d3bfa381d02af10f46080d2b42f",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-lang-sqlpp/src/main/javacc/SQLPP.jj",
      "new_id": "cbe0e7e735cbdc76e4d1f9c856bfe7976a9d44ed",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-lang-sqlpp/src/main/javacc/SQLPP.jj"
    },
    {
      "type": "modify",
      "old_id": "638e4f3a17f4406e12edbf7e0086a82ed83bc387",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/MetadataCache.java",
      "new_id": "81eb535b4ba573db5582af1e9eb86e10c80c718f",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/MetadataCache.java"
    },
    {
      "type": "modify",
      "old_id": "f7d0378ef618dce2bc9e740163934a6b95d79b68",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/MetadataManager.java",
      "new_id": "53b4dcb98a23d9d324bc05e5693321efc0102245",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/MetadataManager.java"
    },
    {
      "type": "modify",
      "old_id": "fa7db2f28dd8c3d04005d82e49650d54b1e804f7",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/MetadataNode.java",
      "new_id": "076a6a7ae252e6fbe5d4740b5b867b3130dd9a28",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/MetadataNode.java"
    },
    {
      "type": "modify",
      "old_id": "483c4f23e60ee468015ea4ef52a5329772749b9b",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/MetadataTransactionContext.java",
      "new_id": "b7d64f4aefbed5e522632aad3297a468d9473e01",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/MetadataTransactionContext.java"
    },
    {
      "type": "modify",
      "old_id": "acd3fe8df5d26c9fbd33a914db9f98aac16898b1",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/api/IMetadataManager.java",
      "new_id": "7578b0b93f2719e5f393c20e216aea6baa59c45b",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/api/IMetadataManager.java"
    },
    {
      "type": "modify",
      "old_id": "4c1426af23186a7e9361c71a881be4ef97260ec4",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/api/IMetadataNode.java",
      "new_id": "45d91f24d90f87f415770207ffcbee1f19cc9441",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/api/IMetadataNode.java"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "8b8413ef5c233af20655aa668eeedca1fdd08922",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/bootstrap/CRSEntity.java"
    },
    {
      "type": "modify",
      "old_id": "1f8c4dc300af4af0159c09fd97bcff8675d61f86",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/bootstrap/MetadataBootstrap.java",
      "new_id": "c2f75b3455f5f092e5ea6df499f3e3f6528355a9",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/bootstrap/MetadataBootstrap.java"
    },
    {
      "type": "modify",
      "old_id": "3b686f4400327a8d41f41cd9ebe9faf0431e8512",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/bootstrap/MetadataIndexesProvider.java",
      "new_id": "5519769c15ad0d684d6e410ed6d584ea7c51279e",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/bootstrap/MetadataIndexesProvider.java"
    },
    {
      "type": "modify",
      "old_id": "ba0cc2cbc6f4d42d3305a36778cce43dd3f35b11",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/bootstrap/MetadataPrimaryIndexes.java",
      "new_id": "7d9f3edb5b763749bc327e13d341366c689decc3",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/bootstrap/MetadataPrimaryIndexes.java"
    },
    {
      "type": "modify",
      "old_id": "820cbb91fa8c2bb44a6a69788ad790ffa9911c92",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/bootstrap/MetadataRecordTypes.java",
      "new_id": "179aff1b72898e44a4caa9a93706b8c73de16375",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/bootstrap/MetadataRecordTypes.java"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "283cb6bc3649878427e9a9fd4e26f25d4da648cc",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/entities/CoordinateReferenceSystem.java"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "373f37438e8686a334458e5ab62987e60e637e87",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/entitytupletranslators/CRSTupleTranslator.java"
    },
    {
      "type": "modify",
      "old_id": "74a4940bc0e85e899773012b68959a5d15f5cf8c",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/entitytupletranslators/MetadataTupleTranslatorProvider.java",
      "new_id": "0fcb6d69a8a658f96fd0addd0c66f7a4a8fc3636",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/entitytupletranslators/MetadataTupleTranslatorProvider.java"
    },
    {
      "type": "modify",
      "old_id": "27a1b8495fd7c5198f7dd202d31c4bcf398f5b42",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/lock/MetadataLockKey.java",
      "new_id": "d42dea512085d5294237d4d7b5357cb6e942b1b5",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/lock/MetadataLockKey.java"
    },
    {
      "type": "modify",
      "old_id": "40c3cd19191a7ad24cffd005729ad3468f2f7bec",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/lock/MetadataLockManager.java",
      "new_id": "09765300af4cb21890ad4b2f3890903416304968",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/lock/MetadataLockManager.java"
    },
    {
      "type": "modify",
      "old_id": "07f62c9a76e5ca6cc73d9c0228d362787b96a26e",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/utils/MetadataLockUtil.java",
      "new_id": "88870647fdae3378524a8c5698e31811f534b2b4",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-metadata/src/main/java/org/apache/asterix/metadata/utils/MetadataLockUtil.java"
    },
    {
      "type": "modify",
      "old_id": "144a389a365b6c6a8c0aebc479acc3d7da428f3d",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-om/src/main/java/org/apache/asterix/om/functions/BuiltinFunctions.java",
      "new_id": "4ca36d3641ee7ee54aa580ae4ad5c708d588c746",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-om/src/main/java/org/apache/asterix/om/functions/BuiltinFunctions.java"
    },
    {
      "type": "modify",
      "old_id": "c7b1e39534f6ac317328e490b856f91d6c9ecfa9",
      "old_mode": 33188,
      "old_path": "asterixdb/asterix-server/pom.xml",
      "new_id": "2aa04c8fa04cc85ca7925c5f7b02214e2cfb417f",
      "new_mode": 33188,
      "new_path": "asterixdb/asterix-server/pom.xml"
    },
    {
      "type": "modify",
      "old_id": "9369e5c619cb773fd935c14d9b1efc356aee18e9",
      "old_mode": 33188,
      "old_path": "asterixdb/pom.xml",
      "new_id": "fd7d670855b7e863cdac486d8cf9d4f999b3ba03",
      "new_mode": 33188,
      "new_path": "asterixdb/pom.xml"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "4a357aa3b9bde0ae607c6a98b92c01c4812e71a8",
      "new_mode": 33188,
      "new_path": "asterixdb/src/main/licenses/content/javax.measure--unit-api--2.1.3_LICENSE.txt"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "65fcd5aa6b021fcdc12399c1aa5399bb4c58e07e",
      "new_mode": 33188,
      "new_path": "asterixdb/src/main/licenses/content/raw.githubusercontent.com_opengeospatial_geoapi_master_LICENSE.txt"
    }
  ]
}
