@embedded-postgres/darwin-arm64 - npm Package Compare versions

Comparing version 10.20.0-beta.6 to 10.23.0-beta.6

native/pg-symlinks.json

@@ -1,1 +0,1 @@
-[{"source":"native/lib/libcrypto.1.1.dylib","target":"native/lib/libcrypto.dylib"},{"source":"native/lib/libedit.0.dylib","target":"native/lib/libedit.dylib"},{"source":"native/lib/libicudata.57.2.dylib","target":"native/lib/libicudata.57.dylib"},{"source":"native/lib/libicudata.68.2.dylib","target":"native/lib/libicudata.68.dylib"},{"source":"native/lib/libicudata.57.2.dylib","target":"native/lib/libicudata.dylib"},{"source":"native/lib/libicui18n.57.2.dylib","target":"native/lib/libicui18n.57.dylib"},{"source":"native/lib/libicui18n.68.2.dylib","target":"native/lib/libicui18n.68.dylib"},{"source":"native/lib/libicui18n.57.2.dylib","target":"native/lib/libicui18n.dylib"},{"source":"native/lib/libicuuc.57.2.dylib","target":"native/lib/libicuuc.57.dylib"},{"source":"native/lib/libicuuc.68.2.dylib","target":"native/lib/libicuuc.68.dylib"},{"source":"native/lib/libicuuc.57.2.dylib","target":"native/lib/libicuuc.dylib"},{"source":"native/lib/liblz4.1.9.3.dylib","target":"native/lib/liblz4.1.dylib"},{"source":"native/lib/liblz4.1.9.3.dylib","target":"native/lib/liblz4.dylib"},{"source":"native/lib/libpq.5.10.dylib","target":"native/lib/libpq.5.dylib"},{"source":"native/lib/libpq.5.10.dylib","target":"native/lib/libpq.dylib"},{"source":"native/lib/libssl.1.1.dylib","target":"native/lib/libssl.dylib"},{"source":"native/lib/libxml2.2.dylib","target":"native/lib/libxml2.dylib"},{"source":"native/lib/libz.1.2.8.dylib","target":"native/lib/libz.1.dylib"},{"source":"native/lib/libz.1.2.8.dylib","target":"native/lib/libz.dylib"}]
+[{"source":"native/lib/libcrypto.3.dylib","target":"native/lib/libcrypto.dylib"},{"source":"native/lib/libedit.0.dylib","target":"native/lib/libedit.dylib"},{"source":"native/lib/libicudata.57.2.dylib","target":"native/lib/libicudata.57.dylib"},{"source":"native/lib/libicudata.68.2.dylib","target":"native/lib/libicudata.68.dylib"},{"source":"native/lib/libicudata.68.2.dylib","target":"native/lib/libicudata.dylib"},{"source":"native/lib/libicui18n.57.2.dylib","target":"native/lib/libicui18n.57.dylib"},{"source":"native/lib/libicui18n.68.2.dylib","target":"native/lib/libicui18n.68.dylib"},{"source":"native/lib/libicui18n.68.2.dylib","target":"native/lib/libicui18n.dylib"},{"source":"native/lib/libicuuc.57.2.dylib","target":"native/lib/libicuuc.57.dylib"},{"source":"native/lib/libicuuc.68.2.dylib","target":"native/lib/libicuuc.68.dylib"},{"source":"native/lib/libicuuc.68.2.dylib","target":"native/lib/libicuuc.dylib"},{"source":"native/lib/liblz4.1.9.3.dylib","target":"native/lib/liblz4.1.dylib"},{"source":"native/lib/liblz4.1.9.3.dylib","target":"native/lib/liblz4.dylib"},{"source":"native/lib/libpq.5.15.dylib","target":"native/lib/libpq.5.dylib"},{"source":"native/lib/libpq.5.15.dylib","target":"native/lib/libpq.dylib"},{"source":"native/lib/libssl.3.dylib","target":"native/lib/libssl.dylib"},{"source":"native/lib/libxml2.2.dylib","target":"native/lib/libxml2.dylib"},{"source":"native/lib/libz.1.2.12.dylib","target":"native/lib/libz.1.dylib"},{"source":"native/lib/libz.1.2.12.dylib","target":"native/lib/libz.dylib"},{"source":"native/lib/libzstd.1.5.2.dylib","target":"native/lib/libzstd.1.dylib"},{"source":"native/lib/libzstd.1.5.2.dylib","target":"native/lib/libzstd.dylib"},{"source":"native/lib/libncursesw.6.dylib","target":"native/opt/local/lib/libncurses.6.dylib"}]

native/share/postgresql/errcodes.txt

@@ -5,3 +5,3 @@ #
 #
-# Copyright (c) 2003-2018, PostgreSQL Global Development Group
+# Copyright (c) 2003-2022, PostgreSQL Global Development Group
 #
@@ -22,3 +22,3 @@ # This list serves as the basis for generating source files containing error
 #
-#   doc/src/sgml/errcodes-list.sgml
+#   doc/src/sgml/errcodes-table.sgml
 #      a SGML table of error codes for inclusion in the documentation
@@ -211,2 +211,19 @@ #
 2200T    E    ERRCODE_INVALID_XML_PROCESSING_INSTRUCTION                     invalid_xml_processing_instruction
+22030    E    ERRCODE_DUPLICATE_JSON_OBJECT_KEY_VALUE                        duplicate_json_object_key_value
+22031    E    ERRCODE_INVALID_ARGUMENT_FOR_SQL_JSON_DATETIME_FUNCTION        invalid_argument_for_sql_json_datetime_function
+22032    E    ERRCODE_INVALID_JSON_TEXT                                      invalid_json_text
+22033    E    ERRCODE_INVALID_SQL_JSON_SUBSCRIPT                             invalid_sql_json_subscript
+22034    E    ERRCODE_MORE_THAN_ONE_SQL_JSON_ITEM                            more_than_one_sql_json_item
+22035    E    ERRCODE_NO_SQL_JSON_ITEM                                       no_sql_json_item
+22036    E    ERRCODE_NON_NUMERIC_SQL_JSON_ITEM                              non_numeric_sql_json_item
+22037    E    ERRCODE_NON_UNIQUE_KEYS_IN_A_JSON_OBJECT                       non_unique_keys_in_a_json_object
+22038    E    ERRCODE_SINGLETON_SQL_JSON_ITEM_REQUIRED                       singleton_sql_json_item_required
+22039    E    ERRCODE_SQL_JSON_ARRAY_NOT_FOUND                               sql_json_array_not_found
+2203A    E    ERRCODE_SQL_JSON_MEMBER_NOT_FOUND                              sql_json_member_not_found
+2203B    E    ERRCODE_SQL_JSON_NUMBER_NOT_FOUND                              sql_json_number_not_found
+2203C    E    ERRCODE_SQL_JSON_OBJECT_NOT_FOUND                              sql_json_object_not_found
+2203D    E    ERRCODE_TOO_MANY_JSON_ARRAY_ELEMENTS                           too_many_json_array_elements
+2203E    E    ERRCODE_TOO_MANY_JSON_OBJECT_MEMBERS                           too_many_json_object_members
+2203F    E    ERRCODE_SQL_JSON_SCALAR_REQUIRED                               sql_json_scalar_required
+2203G    E    ERRCODE_SQL_JSON_ITEM_CANNOT_BE_CAST_TO_TARGET_TYPE            sql_json_item_cannot_be_cast_to_target_type
 
@@ -407,2 +424,3 @@ Section: Class 23 - Integrity Constraint Violation
 55P03    E    ERRCODE_LOCK_NOT_AVAILABLE                                     lock_not_available
+55P04    E    ERRCODE_UNSAFE_NEW_ENUM_VALUE_USAGE                            unsafe_new_enum_value_usage
 
@@ -418,2 +436,3 @@ Section: Class 57 - Operator Intervention
 57P04    E    ERRCODE_DATABASE_DROPPED                                       database_dropped
+57P05    E    ERRCODE_IDLE_SESSION_TIMEOUT                                   idle_session_timeout
 
@@ -420,0 +439,0 @@ Section: Class 58 - System Error (errors external to PostgreSQL itself)

native/share/postgresql/sql_features.txt

@@ -31,3 +31,13 @@ B011	Embedded Ada			NO
 B127	Routine language PL/I			NO	
-B128	Routine language SQL			NO	
+B128	Routine language SQL			YES	
+B200	Polymorphic table functions			NO	
+B201	More than one PTF generic table parameter			NO	
+B202	PTF Copartitioning			NO	
+B203	More than one copartition specification			NO	
+B204	PRUNE WHEN EMPTY			NO	
+B205	Pass-through columns			NO	
+B206	PTF descriptor parameters			NO	
+B207	Cross products of partitionings			NO	
+B208	PTF component procedure interface			NO	
+B209	PTF extended names			NO	
 B211	Module language Ada: VARCHAR and NUMERIC support			NO	
@@ -141,3 +151,3 @@ B221	Routine language Ada: VARCHAR and NUMERIC support			NO
 E171	SQLSTATE support			YES	
-E182	Module language			NO	
+E182	Host language binding			YES	
 F021	Basic information schema			YES	
@@ -201,3 +211,3 @@ F021	Basic information schema	01	COLUMNS view	YES
 F171	Multiple schemas per user			YES	
-F181	Multiple module support			NO	
+F181	Multiple module support			YES	
 F191	Referential delete actions			YES	
@@ -224,2 +234,3 @@ F200	TRUNCATE TABLE statement			YES
 F291	UNIQUE predicate			NO	
+F292	UNIQUE null treatment			YES	SQL:202x draft
 F301	CORRESPONDING in query expressions			NO	
@@ -230,3 +241,3 @@ F302	INTERSECT table operator			YES
 F304	EXCEPT ALL table operator			YES	
-F311	Schema definition statement			NO	
+F311	Schema definition statement			YES	
 F311	Schema definition statement	01	CREATE SCHEMA	YES	
@@ -237,7 +248,7 @@ F311	Schema definition statement	02	CREATE TABLE for persistent base tables	YES
 F311	Schema definition statement	05	GRANT statement	YES	
-F312	MERGE statement			NO	consider INSERT ... ON CONFLICT DO UPDATE
-F313	Enhanced MERGE statement			NO	
-F314	MERGE statement with DELETE branch			NO	
+F312	MERGE statement			YES	
+F313	Enhanced MERGE statement			YES	
+F314	MERGE statement with DELETE branch			YES	
 F321	User authorization			YES	
-F341	Usage tables			NO	no ROUTINE_*_USAGE tables
+F341	Usage tables			YES	
 F361	Subprogram support			YES	
@@ -251,3 +262,3 @@ F381	Extended schema manipulation			YES
 F384	Drop identity property clause			YES	
-F385	Drop column generation expression clause			NO	
+F385	Drop column generation expression clause			YES	
 F386	Set identity column generation clause			YES	
@@ -257,3 +268,3 @@ F391	Long identifiers			YES
 F393	Unicode escapes in literals			YES	
-F394	Optional normal form specification			NO	
+F394	Optional normal form specification			YES	
 F401	Extended joined table			YES	
@@ -265,2 +276,3 @@ F401	Extended joined table	01	NATURAL JOIN	YES
 F403	Partitioned joined tables			NO	
+F404	Range variable for common column names			YES	
 F411	Time zone specification			YES	differences regarding literal interpretation
@@ -286,7 +298,3 @@ F421	National character			YES
 F501	Features and conformance views	02	SQL_SIZING view	YES	
-F501	Features and conformance views	03	SQL_LANGUAGES view	YES	
 F502	Enhanced documentation tables			YES	
-F502	Enhanced documentation tables	01	SQL_SIZING_PROFILES view	YES	
-F502	Enhanced documentation tables	02	SQL_IMPLEMENTATION_INFO view	YES	
-F502	Enhanced documentation tables	03	SQL_PACKAGES view	YES	
 F521	Assertions			NO	
@@ -304,2 +312,3 @@ F531	Temporary tables			YES
 F672	Retrospective check constraints			YES	
+F673	Reads SQL-data routine invocations in CHECK constraints			NO	
 F690	Collation support			YES	but no character set support
@@ -329,7 +338,7 @@ F692	Extended collation support			YES
 F831	Full cursor update	02	Updatable ordered cursors	NO	
-F841	LIKE_REGEX predicate			NO	
-F842	OCCURRENCES_REGEX function			NO	
-F843	POSITION_REGEX function			NO	
-F844	SUBSTRING_REGEX function			NO	
-F845	TRANSLATE_REGEX function			NO	
+F841	LIKE_REGEX predicate			NO	consider regexp_like()
+F842	OCCURRENCES_REGEX function			NO	consider regexp_matches()
+F843	POSITION_REGEX function			NO	consider regexp_instr()
+F844	SUBSTRING_REGEX function			NO	consider regexp_substr()
+F845	TRANSLATE_REGEX function			NO	consider regexp_replace()
 F846	Octet support in regular expression operators			NO	
@@ -352,3 +361,6 @@ F847	Nonconstant regular expressions			NO
 F866	FETCH FIRST clause: PERCENT option			NO	
-F867	FETCH FIRST clause: WITH TIES option			NO	
+F867	FETCH FIRST clause: WITH TIES option			YES	
+R010	Row pattern recognition: FROM clause			NO	
+R020	Row pattern recognition: WINDOW clause			NO	
+R030	Row pattern recognition: full aggregate support			NO	
 S011	Distinct data types			NO	
@@ -368,5 +380,5 @@ S011	Distinct data types	01	USER_DEFINED_TYPES view	NO
 S091	Basic array support			NO	partially supported
-S091	Basic array support	01	Arrays of built-in data types	NO	
+S091	Basic array support	01	Arrays of built-in data types	YES	
 S091	Basic array support	02	Arrays of distinct types	NO	
-S091	Basic array support	03	Array expressions	NO	
+S091	Basic array support	03	Array expressions	YES	
 S092	Arrays of user-defined types			YES	
@@ -379,3 +391,3 @@ S094	Arrays of reference types			NO
 S111	ONLY in query expressions			YES	
-S151	Type predicate			NO	
+S151	Type predicate			NO	see pg_typeof()
 S161	Subtype treatment			NO	
@@ -405,3 +417,3 @@ S162	Subtype treatment for references			NO
 S403	ARRAY_MAX_CARDINALITY			NO	
-S404	TRIM_ARRAY			NO	
+S404	TRIM_ARRAY			YES	
 T011	Timestamp in Information Schema			NO	
@@ -423,6 +435,6 @@ T021	BINARY and VARBINARY data types			NO
 T051	Row types			NO	
-T052	MAX and MIN for row types			NO	
 T053	Explicit aliases for all-fields reference			NO	
 T061	UCS support			NO	
 T071	BIGINT data type			YES	
+T076	DECFLOAT data type			NO	
 T101	Enhanced nullability determination			NO	
@@ -434,2 +446,3 @@ T111	Updatable joins, unions, and columns			NO
 T132	Recursive query in subquery			YES	
+T133	Enhanced cycle mark values			YES	SQL:202x draft
 T141	SIMILAR predicate			YES	
@@ -442,4 +455,4 @@ T151	DISTINCT predicate			YES
 T174	Identity columns			YES	
-T175	Generated columns			NO	
-T176	Sequence generator support			NO	
+T175	Generated columns			NO	mostly supported
+T176	Sequence generator support			NO	supported except for NEXT VALUE FOR
 T177	Sequence generator support: simple restart option			YES	
@@ -462,6 +475,6 @@ T178	Identity columns:  simple restart option			YES
 T213	INSTEAD OF triggers			YES	
-T231	Sensitive cursors			YES	
+T231	Sensitive cursors			NO	
 T241	START TRANSACTION statement			YES	
 T251	SET TRANSACTION statement: LOCAL option			NO	
-T261	Chained transactions			NO	
+T261	Chained transactions			YES	
 T271	Savepoints			YES	
@@ -473,8 +486,8 @@ T272	Enhanced savepoint management			NO
 T312	OVERLAY function			YES	
-T321	Basic SQL-invoked routines			NO	
+T321	Basic SQL-invoked routines			NO	partially supported
 T321	Basic SQL-invoked routines	01	User-defined functions with no overloading	YES	
-T321	Basic SQL-invoked routines	02	User-defined stored procedures with no overloading	NO	
+T321	Basic SQL-invoked routines	02	User-defined stored procedures with no overloading	YES	
 T321	Basic SQL-invoked routines	03	Function invocation	YES	
-T321	Basic SQL-invoked routines	04	CALL statement	NO	
-T321	Basic SQL-invoked routines	05	RETURN statement	NO	
+T321	Basic SQL-invoked routines	04	CALL statement	YES	
+T321	Basic SQL-invoked routines	05	RETURN statement	YES	
 T321	Basic SQL-invoked routines	06	ROUTINES view	YES	
@@ -488,3 +501,3 @@ T321	Basic SQL-invoked routines	07	PARAMETERS view	YES
 T331	Basic roles			YES	
-T332	Extended roles			NO	mostly supported
+T332	Extended roles			YES	
 T341	Overloading of SQL-invoked functions and procedures			YES	
@@ -495,3 +508,3 @@ T351	Bracketed SQL comments (/*...*/ comments)			YES
 T433	Multiargument GROUPING function			YES	
-T434	GROUP BY DISTINCT			NO	
+T434	GROUP BY DISTINCT			YES	
 T441	ABS and MOD functions			YES	
@@ -506,4 +519,7 @@ T461	Symmetric BETWEEN predicate			YES
 T511	Transaction counts			NO	
-T521	Named arguments in CALL statement			NO	
+T521	Named arguments in CALL statement			YES	
 T522	Default values for IN parameters of SQL-invoked procedures			NO	supported except DEFAULT key word in invocation
+T523	Default values for INOUT parameters of SQL-invoked procedures			YES	
+T524	Named arguments in routine invocations other than a CALL statement			YES	
+T525	Default values for parameters of SQL-invoked functions			YES	
 T551	Optional key words for default syntax			YES	
@@ -517,3 +533,3 @@ T561	Holdable locators			NO
 T611	Elementary OLAP operations			YES	
-T612	Advanced OLAP operations			NO	some forms supported
+T612	Advanced OLAP operations			YES	
 T613	Sampling			YES	
@@ -526,4 +542,8 @@ T614	NTILE function			YES
 T619	Nested window functions			NO	
-T620	WINDOW clause: GROUPS option			NO	
+T620	WINDOW clause: GROUPS option			YES	
 T621	Enhanced numeric functions			YES	
+T622	Trigonometric functions			YES	
+T623	General logarithm functions			YES	
+T624	Common logarithm functions			YES	
+T625	LISTAGG			NO	
 T631	IN predicate with one list element			YES	
@@ -533,5 +553,28 @@ T641	Multiple column assignment			NO	only some syntax variants supported
 T652	SQL-dynamic statements in SQL routines			NO	
-T653	SQL-schema statements in external routines			NO	
+T653	SQL-schema statements in external routines			YES	
 T654	SQL-dynamic statements in external routines			NO	
 T655	Cyclically dependent routines			YES	
+T811	Basic SQL/JSON constructor functions			NO	
+T812	SQL/JSON: JSON_OBJECTAGG			NO	
+T813	SQL/JSON: JSON_ARRAYAGG with ORDER BY			NO	
+T814	Colon in JSON_OBJECT or JSON_OBJECTAGG			NO	
+T821	Basic SQL/JSON query operators			NO	
+T822	SQL/JSON: IS JSON WITH UNIQUE KEYS predicate			NO	
+T823	SQL/JSON: PASSING clause			NO	
+T824	JSON_TABLE: specific PLAN clause			NO	
+T825	SQL/JSON: ON EMPTY and ON ERROR clauses			NO	
+T826	General value expression in ON ERROR or ON EMPTY clauses			NO	
+T827	JSON_TABLE: sibling NESTED COLUMNS clauses			NO	
+T828	JSON_QUERY			NO	
+T829	JSON_QUERY: array wrapper options			NO	
+T830	Enforcing unique keys in SQL/JSON constructor functions			NO	
+T831	SQL/JSON path language: strict mode			YES	
+T832	SQL/JSON path language: item method			YES	
+T833	SQL/JSON path language: multiple subscripts			YES	
+T834	SQL/JSON path language: wildcard member accessor			YES	
+T835	SQL/JSON path language: filter expressions			YES	
+T836	SQL/JSON path language: starts with predicate			YES	
+T837	SQL/JSON path language: regex_like predicate			YES	
+T838	JSON_TABLE: PLAN DEFAULT clause			NO	
+T839	Formatted cast of datetimes to/from character strings			NO	
 M001	Datalinks			NO	
@@ -665,4 +708,4 @@ M002	Datalinks via SQL/CLI			NO
 X211	XML 1.1 support			NO	
-X221	XML passing mechanism BY VALUE			NO	
-X222	XML passing mechanism BY REF			YES	
+X221	XML passing mechanism BY VALUE			YES	
+X222	XML passing mechanism BY REF			NO	parser accepts BY REF but ignores it; passing is always BY VALUE
 X231	XML(CONTENT(UNTYPED)) type			NO	
@@ -669,0 +712,0 @@ X232	XML(CONTENT(ANY)) type			NO

package.json

 {
   "name": "@embedded-postgres/darwin-arm64",
-  "version": "10.20.0-beta.6",
+  "version": "10.23.0-beta.6",
   "description": "",
@@ -22,4 +22,4 @@ "main": "dist/index.js",
   "devDependencies": {
-    "@embedded-postgres/downloader": "^10.20.0-beta.6",
-    "@embedded-postgres/symlink-reader": "^10.20.0-beta.6"
+    "@embedded-postgres/downloader": "^10.23.0-beta.6",
+    "@embedded-postgres/symlink-reader": "^10.23.0-beta.6"
   },
@@ -34,3 +34,3 @@ "publishConfig": {
   ],
-  "gitHead": "cd036d8f57156ebe727546d44f24fc4285300df7"
+  "gitHead": "342dfeae879ebaeca2709ec51721cfac011f255d"
 }

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Native code

Supply chain risk

Contains native code (e.g., compiled binaries or shared libraries). Including native code can obscure malicious behavior.

Found 9 instances in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

203187121

increased by0.21%

Number of package files

1075

increased by1.32%

Worsened metrics

Number of medium supply chain risk alerts

722

increased by1.26%

No dependency changes