codekingpro/portable-devtools
114k
1 XnV �� П` ��^ h�d 0�h ��d ��f ��b X�^ �p �j ��p `�� �� Ȝ� ��x 0�� �z ��n ��j @�r �v ��r ��t H�p �p ؙl ��t X�x �t ؘv ��r X�r �~ ȗ� ��l @�� �h Жp ��z H�� �� ȕl p�� �� ��n ��� �� ȓ� x�� (�� ��� ��r 0�� ؑ� ��� �"��� H�� ��� ��� H�� ؎� ��� 0�� �` ��� p�� (�� �| ��� H�� Ћ� p�� �� ��� X�� ��� ��� 8�� ؈� h�� �� ��� 8�� Ȇ� h�� ��� ��� �� ��� H�� �x ��� P�� ��� `� �� ȁj � b _ E081#Basic Privileges YES � a _ E0711Basic query expressions06=Table operators in subqueries YES � ` _ E0711Basic query expressions05�Columns combined via table operators need not have exactly the same data type YES � _ _ E0711Basic query expressions03?EXCEPT DISTINCT table operator YES � ^ _ E0711Basic query expressions023UNION ALL table operator YES � ] _ E0711Basic query expressions01=UNION DISTINCT table operator YES � \ _ E0711Basic query expressions YES � [ _ E061OBasic predicates and search conditions14#Search condition YES � Z _ E061OBasic predicates and search conditions13-Correlated subqueries YES � Y _ E061OBasic predicates and search conditions12]Subqueries in quantified comparison predicate YES � X _ E061OBasic predicates and search conditions117Subqueries in IN predicate YES � W _ E061OBasic predicates and search conditions09GSubqueries in comparison predicate YES � V _ E061OBasic predicates and search conditions08#EXISTS predicate YES � U _ E061OBasic predicates and search conditions07AQuantified comparison predicate YES � T _ E061OBasic predicates and search conditions06 NULL predicate YES � S _ E061OBasic predicates and search conditions05;LIKE predicate ESCAPE clause YES � R _ E061OBasic predicates and search conditions04 LIKE predicate YES � Q _ E061OBasic predicates and search conditions03CIN predicate with list of values YES � P _ E061OBasic predicates and search conditions02%BETWEEN predicate YES � O _ E061OBasic predicates and search conditions01+Comparison predicate YES � N _ E061OBasic predicates and search conditions YES � M _ E0515Basic query specification09ERename columns in the FROM clause YES � L _ E0515Basic query specification08KCorrelation names in the FROM clause YES � K _ E0515Basic query specification077Qualified * in select list YES � J _ E0515Basic query specification06 HAVING clause YES � I _ E0515Basic query specification05CSelect list items can be renamed YES� H _ E0515Basic query specification04eGROUP BY can contain columns not in <select list> YES � G _ E0515Basic query specification02!GROUP BY clause YES � F _ E0515Basic query specification01!SELECT DISTINCT YES � E _ E0515Basic query specification YES � D _ E031Identifiers03)Trailing underscore YES � C _ E031Identifiers02/Lower case identifiers YES� B _ E031Identifiers01-Delimited identifiers YES � A _ E031Identifiers YES� @ _ E021/Character string types12+Character comparison YES � ? _ E021/Character string types11%POSITION function YES � > _ E021/Character string types10eImplicit casting among the character string types YES � = _ E021/Character string types09 TRIM function YES � < _ E021/Character string types085UPPER and LOWER functions YES � ; _ E021/Character string types071Character concatenation YES � : _ E021/Character string types06'SUBSTRING function YES � 9 _ E021/Character string types05-OCTET_LENGTH function YES � 8 _ E021/Character string types045CHARACTER_LENGTH function YESytrims trailing spaces from CHARACTER values before counting � 7 _ E021/Character string types03'Character literals YES � 6 _ E021/Character string types029CHARACTER VARYING data type YES� 5 _ E021/Character string types01)CHARACTER data type YES� 4 _ E021+Character data types YES � 3 _ E011'Numeric data types06]Implicit casting among the numeric data types YES � 2 _ E011'Numeric data types05'Numeric comparison YES � 1 _ E011'Numeric data types04+Arithmetic operators YES � 0 _ E011'Numeric data types03?DECIMAL and NUMERIC data types YES � / _ E011'Numeric data types02[REAL, DOUBLE PRECISION, and FLOAT data types YES � . _ E011'Numeric data types01AINTEGER and SMALLINT data types YES� - _ E011'Numeric data types YES � , _ B221eRoutine language Ada: VARCHAR and NUMERIC supportNO � + _ B211cModule language Ada: VARCHAR and NUMERIC supportNO � * _ B209'PTF extended namesNO � ) _ B208EPTF component procedure interfaceNO � ( _ B207ACross products of partitioningsNO � ' _ B2065PTF descriptor parametersNO � & _ B205+Pass-through columnsNO� % _ B204#PRUNE WHEN EMPTYNO � $ _ B203QMore than one copartition specificationNO � # _ B202'PTF copartitioningNO � " _ B201UMore than one PTF generic table parameterNO � ! _ B2009Polymorphic table functionsNO � _ B128+Routine language SQL YES � _ B127-Routine language PL/INO � _ B1261Routine language PascalNO � _ B125/Routine language MUMPSNO � _ B1243Routine language FortranNO � _ B123/Routine language COBOLNO � _ B122'Routine language CNO � _ B121+Routine language AdaNO� _ B117+Module language PL/INO� _ B116/Module language PascalNO � _ B115-Module language MUMPSNO � _ B1141Module language FortranNO � _ B113-Module language COBOLNO � _ B112%Module language CNO � _ B111)Module language AdaNO � _ B0515Enhanced execution rightsNO � _ B041eExtensions to embedded SQL exception declarationsNO � _ B0363Describe input statementNO � _ B035=Non-extended descriptor namesNO �
_ B034WDynamic specification of cursor attributesNO � _ B033OUntyped SQL-invoked function argumentsNO � _ B032+Extended dynamic SQLNO� 2 _ B031%Basic dynamic SQLNO � _ B030+Enhanced dynamic SQLNO� _ B021Direct SQL YES � _ B017 Embedded PL/INO � _ B016!Embedded PascalNO � _ B015 Embedded MUMPSNO � _ B014#Embedded FortranNO � _ B013 Embedded COBOLNO � _ B012Embedded C YES � _ B011Embedded AdaNO ��V |� ��� p�� �� ��� P�� � ��� H�� �� ��� ��d H�n �r Лn ��n `�n �� К� ��x @�� 虮 ��� P�� �r ��� X�� ��� ��� P�� ��� ��� P�� �� ��� h�� �� ��� H�� ��t0�� ؒ� p�� ��� ��p p�� �� ؐ� P�ȏ��� 0�� ��j ��t x�z (�� ؍� ��� 0�� Ќ� x�� 8�| ��� h�� �� ��� H�� ��� x�� 8�t 舜 ��| p�p �� Ї� ��� H�n ؆� ��� H�� ��� ��� ���� h�p ��� X�8��X0�� ��� � Y _ F051)Basic date and time05�Explicit CAST between datetime types and character string types YES � X _ F051)Basic date and time04{Comparison predicate on DATE, TIME, and TIMESTAMP data types YES � W _ F051)Basic date and time03�TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 YES � V _ F051)Basic date and time02�TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 YES � U _ F051)Basic date and time01gDATE data type (including support of DATE literal) YES � T _ F051)Basic date and time YES� S _ F041'Basic joined table08yAll comparison operators are supported (rather than just =) YES � R _ F041'Basic joined table07�The inner table in a left or right outer join can also be used in an inner join YES� Q _ F041'Basic joined table055Outer joins can be nested YES � P _ F041'Basic joined table04#RIGHT OUTER JOIN YES � O _ F041'Basic joined table03!LEFT OUTER JOIN YES� N _ F041'Basic joined table02 INNER keyword YES � M _ F041'Basic joined table01gInner join (but not necessarily the INNER keyword) YES � L _ F041'Basic joined table YES � K _ F038QREVOKE of a WITH GRANT OPTION privilege YES � J _ F037UREVOKE statement: GRANT OPTION FOR clause YES � I _ F036QREVOKE statement performed by non-owner YES � H _ F035)REVOKE with CASCADE YES� G _ F0345Extended REVOKE statement YES � F _ F033UALTER TABLE statement: DROP COLUMN clause YES � E _ F032-CASCADE drop behavior YES � D _ F0315Basic schema manipulation19EREVOKE statement: RESTRICT clause YES � C _ F0315Basic schema manipulation16KDROP VIEW statement: RESTRICT clause YES � B _ F0315Basic schema manipulation13MDROP TABLE statement: RESTRICT clause YES � A _ F0315Basic schema manipulation04SALTER TABLE statement: ADD COLUMN clause YES� @ _ F0315Basic schema manipulation03!GRANT statement YES � ? _ F0315Basic schema manipulation02-CREATE VIEW statement YES � > _ F0315Basic schema manipulation01qCREATE TABLE statement to create persistent base tables YES � = _ F0315Basic schema manipulation YES � < _ F0213Basic information schema06/CHECK_CONSTRAINTS view YES � ; _ F0213Basic information schema05;REFERENTIAL_CONSTRAINTS view YES � : _ F0213Basic information schema04/TABLE_CONSTRAINTS view YES � 9 _ F0213Basic information schema03VIEWS view YES � 8 _ F0213Basic information schema02TABLES view YES � 7 _ F0213Basic information schema01COLUMNS view YES � 6 _ F0213Basic information schema YES � 5 _ E182-Host language binding YES � 4 _ E171#SQLSTATE support YES � 3 _ E161QSQL comments using leading double minus YES � 2 _ E153EUpdatable queries with subqueries YES � 1 _ E152ABasic SET TRANSACTION statement02ySET TRANSACTION statement: READ ONLY and READ WRITE clauses YES � 0 _ E152ABasic SET TRANSACTION statement01SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause YES � / _ E152ABasic SET TRANSACTION statement YES � . _ E151)Transaction support02'ROLLBACK statement YES � - _ E151)Transaction support01#COMMIT statement YES � , _ E151)Transaction support YES� + _ E1419Basic integrity constraints10kNames in a foreign key can be specified in any order YES � * _ E1419Basic integrity constraints08CNOT NULL inferred on PRIMARY KEY YES � ) _ E1419Basic integrity constraints07!Column defaults YES � ( _ E1419Basic integrity constraints06%CHECK constraints YES � ' _ E1419Basic integrity constraints04�Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action YES � & _ E1419Basic integrity constraints031PRIMARY KEY constraints YES � % _ E1419Basic integrity constraints02OUNIQUE constraints of NOT NULL columns YES� $ _ E1419Basic integrity constraints01+NOT NULL constraints YES � # _ E1419Basic integrity constraints YES� " _ E131[Null value support (nulls in lieu of values) YES � ! _ E121+Basic cursor support17%WITH HOLD cursors YES � _ E121+Basic cursor support10=FETCH statement implicit NEXT YES� _ E121+Basic cursor support08!CLOSE statement YES � _ E121+Basic cursor support079Positioned DELETE statement YES � _ E121+Basic cursor support069Positioned UPDATE statement YES � _ E121+Basic cursor support04 OPEN statement YES � _ E121+Basic cursor support03KValue expressions in ORDER BY clause YES � _ E121+Basic cursor support02YORDER BY columns need not be in select list YES � _ E121+Basic cursor support01 DECLARE CURSOR YES � _ E121+Basic cursor support YES � _ E1119Single row SELECT statement YES� _ E1011Basic data manipulation045Searched DELETE statement YES � _ E1011Basic data manipulation035Searched UPDATE statement YES � _ E1011Basic data manipulation01#INSERT statement YES � _ E1011Basic data manipulation YES � _ E091 Set functions07)DISTINCT quantifier YES � _ E091 Set functions06 ALL quantifier YES � _ E091 Set functions05 SUM YES � _ E091 Set functions04 MIN YES � _ E091 Set functions03 MAX YES �
_ E091 Set functions02
COUNT YES � _ E091 Set functions01 AVG YES � _ E091 Set functions YES � 3 _ E081#Basic Privileges10%EXECUTE privilege YES� _ E081#Basic Privileges09!USAGE privilege YES � _ E081#Basic Privileges08%WITH GRANT OPTION YES� _ E081#Basic Privileges07SREFERENCES privilege at the column level YES � _ E081#Basic Privileges06QREFERENCES privilege at the table level YES � _ E081#Basic Privileges05KUPDATE privilege at the column level YES � _ E081#Basic Privileges04IUPDATE privilege at the table level YES � _ E081#Basic Privileges03IINSERT privilege at the table level YES � _ E081#Basic Privileges02#DELETE privilege YES � _ E081#Basic Privileges01#SELECT privilege YES �V �� ��� p�� (�� ��� ��n X�� �| ȝ� ��� 8�� � ��z p�� (�� �f ��� `�n ؚh�� ��� ��� �� ��| ��x @�~ �z ȗd p�� 8�l 薘 ��j x�f @�h ��� ��� p�x 0�| �z ��� X�� �l �h ��t `�� �z ؒ� ��| P�� �� ��� P�� �� ��� H�� �h Џz ��� P�n �b ��n ��� X�v �~ Ѝ� ��� 0�� ��� ��� P�j �� ȋ� ��� @�t 芮 ��v X�� �b �h ��^ P�� �n Ј� ��z `�` 0�^ �` ȇf ��f X�n �� ��� ��x H�p �v ȅx ��t 8�� ��� ��� @�� ��� ȃ\ ��j P�~ �v l ��f `�r �~ ��x � n _ F6511Catalog name qualifiers YES � m _ F6417Row and table constructors YES � l _ F611+Indicator data types YES � k _ F591 Derived tables YES � j _ F571%Truth value tests YES � i _ F561/Full value expressions YES � h _ F5557Enhanced seconds precision YES � g _ F531#Temporary tables YES � f _ F521AssertionsNO � e _ F502=Enhanced documentation tables YES � d _ F501?Features and conformance views02!SQL_SIZING view YES � c _ F501?Features and conformance views01%SQL_FEATURES view YES � b _ F501?Features and conformance views YES � a _ F492MOptional table constraint enforcementNO � ` _ F491-Constraint management YES � _ _ F4811Expanded NULL predicate YES � ^ _ F471/Scalar subquery values YES � ] _ F461+Named character setsNO� \ _ F4513Character set definitionNO � [ _ F442SMixed column references in set functions YES � Z _ F441=Extended set function support YES � Y _ F438'Scrollable cursors YES � X _ F437 FETCH RELATIVE YES � W _ F436 FETCH ABSOLUTE YES � V _ F435FETCH PRIOR YES� U _ F434FETCH LAST YES � T _ F433FETCH FIRST YES� S _ F4323FETCH with explicit NEXT YES � R _ F431;Read-only scrollable cursors YES � Q _ F421'National character YES � P _ F4111Time zone specification YES[differences regarding literal interpretation� O _ F407CROSS JOIN YES � N _ F406!FULL OUTER JOIN YES � M _ F405NATURAL JOIN YES � L _ F404ORange variable for common column names YES � K _ F4031Partitioned join tablesNO � J _ F402gNamed column joins for LOBs, arrays, and multisets YES � I _ F401-Extended joined table YES � H _ F394GOptional normal form specification YES � G _ F3939Unicode escapes in literals YES� F _ F392?Unicode escapes in identifiers YES � E _ F391#Long identifiers YES � D _ F388eALTER TABLE statement: ADD/DROP CONSTRAINT clause YES � C _ F387WALTER TABLE statement: ALTER COLUMN clause YES � B _ F386MSet identity column generation clause YES � A _ F385SDrop column generation expression clause YES � @ _ F384=Drop identity property clause YES � ? _ F3837Set column not null clause YES � > _ F382/Alter column data type YES � = _ F381;Extended schema manipulation YES � < _ F361'Subprogram support YES � ; _ F341Usage tables YES � : _ F321'User authorization YES � 9 _ F314GMERGE statement with DELETE branch YES � 8 _ F3133Enhanced MERGE statement YES � 7 _ F312!MERGE statement YES � 6 _ F3119Schema definition statement05!GRANT statement YES � 5 _ F3119Schema definition statement04?CREATE VIEW: WITH CHECK OPTION YES� 4 _ F3119Schema definition statement03CREATE VIEW YES � 3 _ F3119Schema definition statement02QCREATE TABLE for persistent base tables YES � 2 _ F3119Schema definition statement01 CREATE SCHEMA YES � 1 _ F3119Schema definition statement YES� 0 _ F305;INTERSECT ALL table operator YES � / _ F3045EXCEPT ALL table operator YES � . _ F303EINTERSECT DISTINCT table operator YES � - _ F3023INTERSECT table operator YES � , _ F301GCORRESPONDING in query expressionsNO � + _ F292-UNIQUE null treatment YES � * _ F291#UNIQUE predicateNO � ) _ F281%LIKE enhancements YES � ( _ F2719Compound character literals YES� ' _ F263kComma-separated predicates in simple CASE expressionNO� & _ F2623Extended CASE expression YES � % _ F261!CASE expression04COALESCE YES � $ _ F261!CASE expression03NULLIF YES � # _ F261!CASE expression02 Searched CASE YES � " _ F261!CASE expression01Simple CASE YES � ! _ F261!CASE expression YES � _ F251 Domain support YES � _ F231#Privilege tables YES � _ F222QINSERT statement: DEFAULT VALUES clause YES � _ F221%Explicit defaults YES � _ F202_TRUNCATE TABLE: identity column restart option YES � _ F201 CAST function YES � _ F2003TRUNCATE TABLE statement YES � _ F1917Referential delete actions YES � _ F1811Multiple module support YES � _ F1715Multiple schemas per user YES � _ F131'Grouped operations05�Single row SELECT with GROUP BY and HAVING clauses and grouped views YES � _ F131'Grouped operations04}Subqueries with GROUP BY and HAVING clauses and grouped views YES � _ F131'Grouped operations03mSet functions supported in queries with grouped views YES � _ F131'Grouped operations02qMultiple tables supported in queries with grouped views YES� _ F131'Grouped operations01�WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views YES � _ F131'Grouped operations YES � _ F124gSET TRANSACTION statement: DIAGNOSTICS SIZE clauseNO � _ F123!All diagnosticsNO � _ F122AEnhanced diagnostics managementNO �
_ F121;Basic diagnostics managementNO� _ F1205Get diagnostics statementNO � _ F114AIsolation level REPEATABLE READ YES � 4 _ F113?Isolation level READ COMMITTED YES � _ F112CIsolation level READ UNCOMMITTED YES � _ F111SIsolation levels other than SERIALIZABLE YES � _ F0815UNION and EXCEPT in views YES � _ F054OTIMESTAMP in DATE type precedence listNO � _ F053'OVERLAPS predicate YES � _ F052EIntervals and datetime arithmetic YES � _ F051)Basic date and time08 LOCALTIMESTAMP YES� _ F051)Basic date and time07LOCALTIME YES � _ F051)Basic date and time06CURRENT_DATE YES p�V �� ȟd p�� (�� Ȟ� ��l P�~ �� ȝn ��� @�~ �b ��� p�z �� ��x ��n p�h 8�f ��t ��� ��p H�l �d ؙj ��t `�l �� ��z ��� 8�� ��� ��� 0�� ؖ� ��� @�� �v ��� x�� (�� ؔ� ��| P�� �� ��� x�r 0�� �| ��� `�� �� Б| ��� @�� � ��� `�n �� Џt ��z P�t �� ��� x�~ 8�r ��x ��� P�� �Z ��t ��� H�� �x ȋz ��� H�t �x ؊\ ��l `�| �� ��j ��� P�� �� Јj ��� H�� �x Їd ��j `�n �z ��t ��p h�t �� ��� ��z `�v �� ��h ��� H�� �r ^ ��� H�� ��� ��x p�z 8�l ��| � q _ T0397CLOB locator: non-holdableNO � p _ T031%BOOLEAN data type YES � o _ T0245Spaces in binary literalsNO � n _ T0233Compound binary literalsNO � m _ T022kAdvanced support for BINARY and VARBINARY data typesNO� l _ T021ABINARY and VARBINARY data typesNO � k _ T011ATimestamp in Information SchemaNO � j _ S404TRIM_ARRAY YES � i _ S403-ARRAY_MAX_CARDINALITYNO � h _ S402ODistinct types based on multiset typesNO � g _ S401IDistinct types based on array typesNO � f _ S301!Enhanced UNNEST YES � e _ S291AUnique constraint on entire rowNO � d _ S2811Nested collection typesNO � c _ S2755Advanced multiset supportNO � b _ S274;Multisets of reference typesNO� a _ S272AMultisets of user-defined typesNO � ` _ S271/Basic multiset supportNO � _ _ S261+Specific type methodNO� ^ _ S251/User-defined orderingsNO � ] _ S2425Alter transform statementNO � \ _ S241)Transform functionsNO � [ _ S233%Multiset locatorsNO � Z _ S232 Array locatorsNO � Y _ S2313Structured type locatorsNO � X _ S2119User-defined cast functions YES� W _ S204EArray as result type of functions YES � V _ S203#Array parameters YES � U _ S202ESQL-invoked routines on multisetsNO � T _ S201?SQL-invoked routines on arrays YES � S _ S162CSubtype treatment for referencesNO � R _ S161%Subtype treatmentNO � Q _ S151 Type predicateNO!see pg_typeof() � P _ S1115ONLY in query expressions YES � O _ S099%Array expressions YES � N _ S098ARRAY_AGG YES � M _ S0973Array element assignmentNO � L _ S096-Optional array bounds YES � K _ S0959Array constructors by query YES� J _ S0945Arrays of reference typesNO � I _ S0933Arrays of distinct typesNO � H _ S092;Arrays of user-defined types YES � G _ S091)Basic array supportNO)partially supported � F _ S090-Minimal array support YES � E _ S081SubtablesNO � D _ S071_SQL paths in function and type name resolution YES � C _ S051+Create table of typeNO)partially supported � B _ S0433Enhanced reference typesNO � A _ S041-Basic reference typesNO � @ _ S0289Permutable UDT options listNO � ? _ S027MCreate method by specific method nameNO � > _ S026ESelf-referencing structured typesNO � = _ S025/Final structured typesNO � < _ S0245Enhanced structured typesNO � ; _ S023/Basic structured typesNO � : _ S011)Distinct data types011USER_DEFINED_TYPES viewNO� 9 _ S011)Distinct data typesNO � 8 _ R030aRow pattern recognition: full aggregate supportNO � 7 _ R020ORow pattern recognition: WINDOW clauseNO � 6 _ R010KRow pattern recognition: FROM clauseNO� 5 _ F869GSQL implementation info population YES � 4 _ F8685ORDER BY in grouped table YES � 3 _ F867KFETCH FIRST clause: WITH TIES option YES � 2 _ F866GFETCH FIRST clause: PERCENT optionNO � 1 _ F865GDynamic offset row count in OFFSET YES � 0 _ F8645Top-level OFFSET in views YES � / _ F863ENested OFFSET in query expression YES � . _ F862+OFFSET in subqueries YES � - _ F861KTop-level OFFSET in query expression YES � , _ F860=Dynamic FETCH FIRST row count YES � + _ F859?Top-level FETCH FIRST in views YES � * _ F8585FETCH FIRST in subqueries YES � ) _ F857UTop-level FETCH FIRST in query expression YES � ( _ F856ONested FETCH FIRST in query expression YES � ' _ F855INested ORDER BY in query expression YES� & _ F8529Top-level ORDER BY in views YES� % _ F851/ORDER BY in subqueries YES � $ _ F850OTop-level ORDER BY in query expression YES � # _ F847CNon-constant regular expressionsNO � " _ F846]Octet support in regular expression operatorsNO � ! _ F8453TRANSLATE_REGEX functionNO5consider regexp_replace() � _ F8443SUBSTRING_REGEX functionNO3consider regexp_substr() � _ F8431POSITION_REGEX functionNO1consider regexp_instr() � _ F8427OCCURRENCES_REGEX functionNO5consider regexp_matches() � _ F841+LIKE_REGEX predicateNO/consider regexp_like() � _ F8335Updatable ordered cursorsNO � _ F832;Updatable scrollable cursorsNO� _ F831'Full cursor updateNO � _ F821/Local table referencesNO � _ F813%Extended flaggingNO � _ F812 Basic flaggingNO � _ F801%Full set function YES � _ F791)Insensitive cursors YES� _ F7819Self-referencing operations YES� _ F771-Connection management YES � _ F763 CURRENT_SCHEMA YES � _ F762!CURRENT_CATALOG YES � _ F761'Session management YES � _ F7511View CHECK enhancements YES � _ F7411Referential MATCH typesNO+no partial match yet �
_ F7313INSERT column privileges YES � _ F721/Deferrable constraintsNO;foreign and unique keys only � _ F711ALTER domain YES � 5 _ F7017Referential update actions YES � _ F696KAdditional translation documentationNO� _ F695)Translation supportNO � _ F693SSQL-session and client module collationsNO � _ F6927Extended collation support YES � _ F690%Collation support YES � _ F673qReads SQL-data routine invocations in CHECK constraintsNO � _ F672ARetrospective CHECK constraints YES � _ F671ASubqueries in CHECK constraintsNO-intentionally omitted� _ F661 Simple tables YES ȓV �� ��t ��~ 8�� �` ؞` ��d h�d �� ȝt ��| �� ��Z ��� @�� �z ��� ��` H�t �j ؚl ��� @�� ��� ��� P�� �h ؘ� ��~ `�l (�n ��� ��� H�� ��� ��j x�� �� ��� h�� (�v ��� ��� P�� ��� ��x x�� @�p �h Вf h�� 0�l ��� x�j 8�� 萖 ��r h�� 8�^ ��� ��� X�� �� Ўj x�� �� ��� 8�� 茞 ��� @�� ��� ��� X�� �� Ȋ� ��f `�` (�f ��� ��n @�� ��� ��� p�l 0�t ��� ��x x�f 8�t ��� ��| h�j 0�l 腌 X���� ��� (�� � ��j H�� ��� ��� P�� �v Ё~ � j _ T6117Elementary OLAP operations YES � i _ T6011Local cursor referencesNO � h _ T591YUNIQUE constraints of possibly null columns YES� g _ T581MRegular expression substring function YES � f _ T572eMultiset-returning external SQL-invoked functionsNO � e _ T571_Array-returning external SQL-invoked functionsNO � d _ T561%Holdable locatorsNO � c _ T551MOptional key words for default syntax YES � b _ T525oDefault values for parameters of SQL-invoked functions YES � a _ T524�Named arguments in routine invocations other than a CALL statement YES � ` _ T523}Default values for INOUT parameters of SQL-invoked procedures YES � _ _ T522wDefault values for IN parameters of SQL-invoked proceduresNOasupported except DEFAULT key word in invocation � ^ _ T521ENamed arguments in CALL statement YES � ] _ T511'Transaction countsNO � \ _ T502%Period predicatesNO � [ _ T5015Enhanced EXISTS predicate YES � Z _ T495GCombined data change and retrievalNO#different syntax � Y _ T491-LATERAL derived table YES � X _ T472!DESCRIBE CURSORNO � W _ T4713Result sets return valueNO � V _ T4619Symmetric BETWEEN predicate YES� U _ T441-ABS and MOD functions YES � T _ T434%GROUP BY DISTINCT YES � S _ T433CMulti-argument GROUPING function YES � R _ T432MNested and concatenated GROUPING SETS YES � Q _ T431?Extended grouping capabilities YES � P _ T351'Bracketed comments YES � O _ T341�Overloading of SQL-invoked functions and SQL-invoked procedures YES � N _ T332 Extended roles YES � M _ T331Basic roles YES� L _ T326!Table functionsNO � K _ T325GQualified SQL parameter references YES � J _ T324GExplicit security for SQL routinesNO � I _ T323QExplicit security for external routines YES � H _ T322=Declared data type attributesNO � G _ T3217Basic SQL-invoked routines07!PARAMETERS view YES� F _ T3217Basic SQL-invoked routines06 ROUTINES view YES � E _ T3217Basic SQL-invoked routines05#RETURN statement YES � D _ T3217Basic SQL-invoked routines04 CALL statement YES � C _ T3217Basic SQL-invoked routines03)Function invocation YES � B _ T3217Basic SQL-invoked routines02gUser-defined stored procedures with no overloading YES � A _ T3217Basic SQL-invoked routines01WUser-defined functions with no overloading YES � @ _ T3217Basic SQL-invoked routinesNO)partially supported � ? _ T312#OVERLAY function YES � > _ T3011Functional dependenciesNO)partially supported � = _ T285=Enhanced derived column names YES � < _ T281SSELECT privilege with column granularity YES � ; _ T272=Enhanced savepoint managementNO � : _ T271Savepoints YES � 9 _ T262;Multiple server transactionsNO� 8 _ T261+Chained transactions YES � 7 _ T251QSET TRANSACTION statement: LOCAL optionNO � 6 _ T2419START TRANSACTION statement YES� 5 _ T231%Sensitive cursorsNO � 4 _ T218�Multiple triggers for the same event executed in the order createdNO-intentionally omitted � 3 _ T217%TRIGGER privilege YES � 2 _ T216�Ability to require true search condition before trigger is invoked YES � 1 _ T215 AFTER triggers YES � 0 _ T214!BEFORE triggers YES � / _ T213)INSTEAD OF triggers YES� . _ T2129Enhanced trigger capability YES� - _ T2113Basic trigger capabilityNO � , _ T201eComparable data types for referential constraints YES � + _ T200Trigger DDLNOCsimilar but not fully compatible � * _ T1919Referential action RESTRICT YES� ) _ T181?Application-time period tablesNO � ( _ T1801System-versioned tablesNO � ' _ T178QIdentity columns: simple restart option YES � & _ T177eSequence generator support: simple restart option YES � % _ T1767Sequence generator supportNOIsupported except for NEXT VALUE FOR � $ _ T175%Generated columnsNO#mostly supported � # _ T174#Identity columns YES � " _ T173SExtended LIKE clause in table definition YES � ! _ T172OAS subquery clause in table definition YES � _ T171ALIKE clause in table definition YES � _ T152CDISTINCT predicate with negation YES � _ T151'DISTINCT predicate YES � _ T141%SIMILAR predicate YES � _ T1337Enhanced cycle mark values YES � _ T1329Recursive query in subquery YES� _ T131!Recursive query YES � _ T122OWITH (excluding RECURSIVE) in subquery YES � _ T121_WITH (excluding RECURSIVE) in query expression YES � _ T111KUpdatable joins, unions, and columnsNO� _ T101GEnhanced nullability determinationNO � _ T081KOptional string types maximum length YES � _ T076'DECFLOAT data typeNO � _ T071#BIGINT data type YES � _ T062/Character length unitsNO � _ T061UCS support YES� _ T056?Multi-character TRIM functions YES � _ T0553String padding functions YES � _ T054'GREATEST and LEAST YES1different null handling �
_ T053UExplicit aliases for all-fields referenceNO � _ T051Row typesNO � _ T050�POSITION, CHAR_LENGTH, OCTET_LENGTH, LOWER, TRIM, UPPER, and SUBSTRING for CLOBsNO � 6 _ T0497BLOB locator: non-holdableNO � _ T048/Concatenation of BLOBsNO � _ T047mPOSITION, OCTET_LENGTH, TRIM, and SUBSTRING for BLOBsNO � _ T046 CLOB data typeNO � _ T045 BLOB data typeNO � _ T044Multiplier PNO� _ T043Multiplier TNO� _ T042?Extended LOB data type supportNO � _ T0419Basic LOB data type supportNO � _ T040/Concatenation of CLOBsNO �V �� ��z ��Z X�f �v ��� p�� �� Нv ��� H�~ �x Ȝ� ��~ X�V (�\ ��� ��� 0�� ��� ��� @�� � ��� `�� �� И� ��d X�v �l З� ��z @�� � ��� P�� �x ȕ� x�� �� Ȕ� ��\ P�� � ��� `�� �� ��� h�� �� ��� p�� �� ��� `�� �� ��� @�� Ȏ� ��� @�� ��� ��� p�� �� Ȍ� ��� 8�� ��� ��� h�� �� ؊� ��� 8�� 艔 ��� 8�� �Z Ȉr ��| 8�� ��t ��p ��f @�� ��� ��j ��f H�n �r Ѕf ��p `�l �� ��� P�� ��� ��� H�� ��� ��� X�� (�Z ��n � h _ X011'Arrays of XML type YES � g _ X010XML type YES � f _ M031MForeign-data wrapper general routinesNO � e _ M030ASQL-server foreign data supportNO � d _ M024aForeign-data wrapper interface routines in PL/INO � c _ M023eForeign-data wrapper interface routines in PascalNO � b _ M022cForeign-data wrapper interface routines in MUMPSNO � a _ M021gForeign-data wrapper interface routines in FortranNO � ` _ M020cForeign-data wrapper interface routines in COBOLNO � _ _ M019[Foreign-data wrapper interface routines in CNO different API � ^ _ M018_Foreign-data wrapper interface routines in AdaNO � ] _ M017'Datalinks via PL/INO � \ _ M016+Datalinks via PascalNO� [ _ M015!Datalinks via MNO � Z _ M014-Datalinks via FortranNO � Y _ M013)Datalinks via COBOLNO � X _ M012!Datalinks via CNO � W _ M011%Datalinks via AdaNO � V _ M010;Foreign-data wrapper supportNO different API � U _ M009GGetOpts and GetStatistics routinesNO � T _ M007!TransmitRequestNO � S _ M006+GetSQLString routineNO� R _ M005/Foreign schema supportNO � Q _ M004+Foreign data supportNO)partially supported � P _ M0037Datalinks via Embedded SQLNO � O _ M002-Datalinks via SQL/CLINO � N _ M001DatalinksNO � M _ T882[JSON in multiset element grouping operationsNO� L _ T8819JSON in ordering operationsNOAwith jsonb, partially supported � K _ T8809JSON in grouping operations YESwith jsonb � J _ T8799JSON in equality operations YESwith jsonb � I _ T878USQL/JSON item method: timestamp precisionNO � H _ T877KSQL/JSON item method: timestamp_tz()NO� G _ T876ESQL/JSON item method: timestamp()NO � F _ T875KSQL/JSON item method: time precisionNO� E _ T874ASQL/JSON item method: time_tz()NO � D _ T873;SQL/JSON item method: time()NO� C _ T872?SQL/JSON item method: string()NO � B _ T871?SQL/JSON item method: number()NO � A _ T870ASQL/JSON item method: integer()NO � @ _ T869sSQL/JSON item method: decimal() with precision and scaleNO � ? _ T868ASQL/JSON item method: decimal()NO � > _ T867;SQL/JSON item method: date()NO� = _ T866ASQL/JSON item method: boolean()NO � < _ T865?SQL/JSON item method: bigint()NO � ; _ T864;SQL/JSON simplified accessorNO� : _ T863�SQL/JSON simplified accessor: single-quoted string literal as member accessorNO � 9 _ T862oSQL/JSON simplified accessor: wildcard member accessorNO � 8 _ T861�SQL/JSON simplified accessor: case-sensitive JSON member accessorNO � 7 _ T860iSQL/JSON simplified accessor: column reference onlyNO � 6 _ T851_SQL/JSON: optional keywords for default syntax YES � 5 _ T840_Hex integer literals in SQL/JSON path language YES � 4 _ T839mFormatted cast of datetimes to/from character stringsNO � 3 _ T838AJSON_TABLE: PLAN DEFAULT clauseNO � 2 _ T837[SQL/JSON path language: regex_like predicate YES � 1 _ T836]SQL/JSON path language: starts with predicate YES � 0 _ T835WSQL/JSON path language: filter expressions YES � / _ T834cSQL/JSON path language: wildcard member accessor YES � . _ T833YSQL/JSON path language: multiple subscripts YES� - _ T832ISQL/JSON path language: item method YES� , _ T831ISQL/JSON path language: strict mode YES� + _ T830qEnforcing unique keys in SQL/JSON constructor functions YES � * _ T829EJSON_QUERY: array wrapper optionsNO � ) _ T828JSON_QUERYNO � ( _ T827WJSON_TABLE: sibling NESTED COLUMNS clausesNO � ' _ T826sGeneral value expression in ON ERROR or ON EMPTY clausesNO � & _ T825QSQL/JSON: ON EMPTY and ON ERROR clausesNO � % _ T824CJSON_TABLE: specific PLAN clauseNO � $ _ T8233SQL/JSON: PASSING clauseNO � # _ T822[SQL/JSON: IS JSON WITH UNIQUE KEYS predicate YES � " _ T821?Basic SQL/JSON query operatorsNO � ! _ T814OColon in JSON_OBJECT or JSON_OBJECTAGG YES � _ T813MSQL/JSON: JSON_ARRAYAGG with ORDER BY YES � _ T8123SQL/JSON: JSON_OBJECTAGG YES � _ T811KBasic SQL/JSON constructor functions YES � _ T803%String-based JSON YES � _ T8021Enhanced JSON data typeNO � _ T801 JSON data typeNO � _ T670CSchema and data statement mixing YES � _ T662AUnderscores in numeric literals YES � _ T661;Non-decimal integer literals YES � _ T655=Cyclically dependent routines YES � _ T654YSQL-dynamic statements in external routinesNO � _ T653WSQL-schema statements in external routines YES � _ T652OSQL-dynamic statements in SQL routinesNO � _ T651MSQL-schema statements in SQL routines YES � _ T6417Multiple column assignmentNOIonly some syntax variants supported � _ T631GIN predicate with one list element YES � _ T627;Window framed COUNT DISTINCT YES � _ T626ANY_VALUE YES � _ T625LISTAGGNO �
_ T6247Common logarithm functions YES � _ T6239General logarithm functions YES� _ T6221Trigonometric functions YES � 7 _ T6217Enhanced numeric functions YES � _ T620;WINDOW clause: GROUPS option YES � _ T6191Nested window functionsNO � _ T618'NTH_VALUE functionNOUfunction exists, but some options missing � _ T617KFIRST_VALUE and LAST_VALUE functions YES � _ T616cNull treatment option for LEAD and LAG functionsNO � _ T615/LEAD and LAG functions YES � _ T614 NTILE function YES � _ T613Sampling YES � _ T6123Advanced OLAP operations YES x�V �� ��r ��| @�v �l Ȟt ��\ h�V 8�^ �^ ؝\ ��V h�x 8�^ �T V ��p X�� �� ��� p�� �� ؚ� ��� (�� Й� ��v H�� �� ��� `�� �� ��� h�� �� ��� P�� � ��� @�� �j Ȕr `�� ��� ��� @�� ؒ� ��� H�r ��� ��� h�� �� А� ��� 0�� 菂 ��� X�v �r ؎v ��� (�� Ѝ� ��� 0�� Ќ� p�� (�� ��� ��� `�v �v Њ� ��� @�� ��� ��� `�� �� ��� p�� �� ȇ� p�� �� ��� x�z 8�x ��~ ��v ��l 8�� ��� ȄX ��~ H�� �� ��� h�� �� �f ��� � ��| � h _ X2317XML(CONTENT(UNTYPED)) typeNO � g _ X222;XML passing mechanism BY REFNO�parser accepts BY REF but ignores it; passing is always BY VALUE� f _ X221?XML passing mechanism BY VALUE YES � e _ X211!XML 1.1 supportNO � d _ X206?XMLQuery: NULL ON EMPTY optionNO � c _ X205AXMLQuery: EMPTY ON EMPTY optionNO � b _ X204UXMLQuery: initializing an XQuery variableNO � a _ X203CXMLQuery: passing a context itemNO � ` _ X202;XMLQuery: RETURNING SEQUENCENO� _ _ X2019XMLQuery: RETURNING CONTENTNO � ^ _ X200XMLQueryNO � ] _ X192;XML(CONTENT(XMLSCHEMA)) typeNO� \ _ X191=XML(DOCUMENT(XMLSCHEMA)) typeNO � [ _ X190'XML(SEQUENCE) typeNO � Z _ X1821XML(DOCUMENT(ANY)) typeNO � Y _ X1819XML(DOCUMENT(UNTYPED)) typeNO � X _ X1713NIL ON NO CONTENT optionNO � W _ X1705XML null handling optionsNO � V _ X161oAdvanced Information Schema for registered XML schemasNO � U _ X160iBasic Information Schema for registered XML schemasNO � T _ X157kIS VALID predicate: NO NAMESPACE with ELEMENT clauseNO� S _ X155kIS VALID predicate: NAMESPACE without ELEMENT clauseNO� R _ X153SIS VALID predicate: with SEQUENCE optionNO � Q _ X152QIS VALID predicate: with CONTENT optionNO � P _ X151SIS VALID predicate: with DOCUMENT optionNO � O _ X145[IS VALID predicate outside check constraintsNO� N _ X144IIS VALID predicate: schema locationNO � M _ X143GIS VALID predicate: ELEMENT clauseNO � L _ X142QIS VALID predicate: ACCORDING TO clauseNO � K _ X141KIS VALID predicate: data-driven caseNO� J _ X135?XMLBINARY clause in subqueriesNO � I _ X134QXMLBINARY clause in compound statementsNO � H _ X1331XMLBINARY clause in DDLNO � G _ X1321XMLBINARY clause in DMLNO � F _ X131;Query-level XMLBINARY clauseNO� E _ X121IXML parameters in external routines YES� D _ X120?XML parameters in SQL routines YES � C _ X114uHost language support for XML: PRESERVE WHITESPACE optionNO � B _ X113oHost language support for XML: STRIP WHITESPACE optionNO � A _ X112YHost language support for XML: BLOB mappingNO � @ _ X111YHost language support for XML: CLOB mappingNO � ? _ X110_Host language support for XML: VARCHAR mappingNO � > _ X101_Host language support for XML: DOCUMENT optionNO � = _ X100]Host language support for XML: CONTENT optionNO � < _ X096XMLExistsNO XPath 1.0 only � ; _ X091-XML content predicateNO � : _ X090/XML document predicate YES � 9 _ X086OXML namespace declarations in XMLTableNO � 8 _ X085=Predefined namespace prefixesNO � 7 _ X084eXML namespace declarations in compound statementsNO � 6 _ X083EXML namespace declarations in DDLNO � 5 _ X082EXML namespace declarations in DMLNO � 4 _ X081OQuery-level XML namespace declarationsNO � 3 _ X080;Namespaces in XML publishingNO� 2 _ X078OXMLSerialize: explicit XML declarationNO � 1 _ X077OXMLSerialize: explicit ENCODING optionNO � 0 _ X076-XMLSerialize: VERSIONNO � / _ X075UXMLSerialize: binary string serializationNO � . _ X074}XMLSerialize: binary string serialization and DOCUMENT optionNO � - _ X073{XMLSerialize: binary string serialization and CONTENT optionNO� , _ X072[XMLSerialize: character string serialization YES � + _ X071�XMLSerialize: character string serialization and DOCUMENT option YES � * _ X070�XMLSerialize: character string serialization and CONTENT option YES � ) _ X069+XMLSerialize: INDENT YES � ( _ X068%XMLSerialize: BOMNO � ' _ X066eXMLParse: binary string input and DOCUMENT optionNO � & _ X065cXMLParse: binary string input and CONTENT optionNO � % _ X061kXMLParse: character string input and DOCUMENT option YES � $ _ X060iXMLParse: character string input and CONTENT option YES� # _ X059oAdvanced table mapping: hex encoding of binary strings YES � " _ X058uAdvanced table mapping: base64 encoding of binary strings YES � ! _ X057SAdvanced table mapping: metadata mapping YES � _ X056KAdvanced table mapping: data mapping YES � _ X055]Advanced table mapping: with target namespace YES � _ X054SAdvanced table mapping: table as element YES � _ X053QAdvanced table mapping: table as forest YES � _ X052IAdvanced table mapping: null as nil YES� _ X051IAdvanced table mapping: null absent YES� _ X050/Advanced table mapping YES � _ X049iBasic table mapping: hex encoding of binary strings YES� _ X048oBasic table mapping: base64 encoding of binary strings YES � _ X047MBasic table mapping: metadata mapping YES � _ X046EBasic table mapping: data mapping YES � _ X045WBasic table mapping: with target namespace YES � _ X044MBasic table mapping: table as element YES � _ X043KBasic table mapping: table as forest YES � _ X042CBasic table mapping: null as nil YES � _ X041CBasic table mapping: null absent YES � _ X040)Basic table mapping YES� _ X038XMLTextNO � _ X037
XMLPI YES �
_ X036XMLComment YES � _ X0351XMLAgg: ORDER BY option YES � _ X034XMLAgg YES � 8 _ X032XMLForest YES � _ X031XMLElement YES � _ X030XMLDocumentNO � _ X025XMLCastNO � _ X020XMLConcat YES � _ X016-Persistent XML values YES � _ X015'Fields of XML typeNO � _ X014/Attributes of XML type YES � _ X0137Distinct types of XML typeNO � _ X012-Multisets of XML typeNO 8�V � � ��t x�� 0�� ؞� ��� (�� Н� ��� �� ��� ��x 0�� ��� ��z X�� �� К~ ��� H�� �� ��� `�� �� Șt x�� 0�� 藈 ��� 8�� ��� ��� � _ X410CAlter column data type: XML type YES � _ X4009Name and identifier mapping YES� _ X305UXMLTable: initializing an XQuery variableNO � _ X304CXMLTable: passing a context item YES+must be XML DOCUMENT � _ X303AXMLTable: column default option YES � _ X302GXMLTable: ordinality column option YES � _ X301KXMLTable: derived column list option YES � _ X300XMLTableNO XPath 1.0 only � _ X286]XMLValidate: NO NAMESPACE with ELEMENT clauseNO � _ X284]XMLValidate: NAMESPACE without ELEMENT clauseNO � _ X283CXMLValidate with SEQUENCE optionNO � _ X282AXMLValidate with CONTENT optionNO � _ X281CXMLValidate with DOCUMENT optionNO � _ X274;XMLValidate: schema locationNO� _ X2739XMLValidate: ELEMENT clauseNO � _ X272CXMLValidate: ACCORDING TO clauseNO � _ X271=XMLValidate: data-driven caseNO � _ X2645XML type: schema locationNO �
_ X263WXML type: NO NAMESPACE with ELEMENT clauseNO � _ X261WXML type: NAMESPACE without ELEMENT clauseNO � _ X2603XML type: ELEMENT clauseNO � 9 _ X257mPersistent XML values of XML(CONTENT(XMLSCHEMA)) typeNO � _ X256oPersistent XML values of XML(DOCUMENT(XMLSCHEMA)) typeNO � _ X255YPersistent XML values of XML(SEQUENCE) typeNO � _ X254aPersistent XML values of XML(CONTENT(ANY)) typeNO � _ X253iPersistent XML values of XML(CONTENT(UNTYPED)) typeNO � _ X252cPersistent XML values of XML(DOCUMENT(ANY)) typeNO � _ X251kPersistent XML values of XML(DOCUMENT(UNTYPED)) typeNO� _ X242KRETURNING SEQUENCE in XML publishingNO� _ X241IRETURNING CONTENT in XML publishingNO � _ X232/XML(CONTENT(ANY)) typeNO