diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/catalog/information_schema.sql | 70 | ||||
| -rw-r--r-- | src/backend/catalog/sql_feature_packages.txt | 29 | ||||
| -rw-r--r-- | src/backend/catalog/sql_features.txt | 4 | ||||
| -rw-r--r-- | src/include/catalog/catversion.h | 2 | ||||
| -rw-r--r-- | src/test/regress/expected/sanity_check.out | 3 |
5 files changed, 1 insertions, 107 deletions
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index c42e76ea894..5d64791c5d8 100644 --- a/src/backend/catalog/information_schema.sql +++ b/src/backend/catalog/information_schema.sql @@ -1649,56 +1649,6 @@ GRANT SELECT ON sql_implementation_info TO PUBLIC; /* - * SQL_LANGUAGES table - * apparently removed in SQL:2008 - */ - -CREATE TABLE sql_languages ( - sql_language_source character_data, - sql_language_year character_data, - sql_language_conformance character_data, - sql_language_integrity character_data, - sql_language_implementation character_data, - sql_language_binding_style character_data, - sql_language_programming_language character_data -); - -INSERT INTO sql_languages VALUES ('ISO 9075', '1999', 'CORE', NULL, NULL, 'DIRECT', NULL); -INSERT INTO sql_languages VALUES ('ISO 9075', '1999', 'CORE', NULL, NULL, 'EMBEDDED', 'C'); -INSERT INTO sql_languages VALUES ('ISO 9075', '2003', 'CORE', NULL, NULL, 'DIRECT', NULL); -INSERT INTO sql_languages VALUES ('ISO 9075', '2003', 'CORE', NULL, NULL, 'EMBEDDED', 'C'); - -GRANT SELECT ON sql_languages TO PUBLIC; - - -/* - * SQL_PACKAGES table - * removed in SQL:2011 - */ - -CREATE TABLE sql_packages ( - feature_id character_data, - feature_name character_data, - is_supported yes_or_no, - is_verified_by character_data, - comments character_data -); - -INSERT INTO sql_packages VALUES ('PKG000', 'Core', 'NO', NULL, ''); -INSERT INTO sql_packages VALUES ('PKG001', 'Enhanced datetime facilities', 'YES', NULL, ''); -INSERT INTO sql_packages VALUES ('PKG002', 'Enhanced integrity management', 'NO', NULL, ''); -INSERT INTO sql_packages VALUES ('PKG003', 'OLAP facilities', 'NO', NULL, ''); -INSERT INTO sql_packages VALUES ('PKG004', 'PSM', 'NO', NULL, 'PL/pgSQL is similar.'); -INSERT INTO sql_packages VALUES ('PKG005', 'CLI', 'NO', NULL, 'ODBC is similar.'); -INSERT INTO sql_packages VALUES ('PKG006', 'Basic object support', 'NO', NULL, ''); -INSERT INTO sql_packages VALUES ('PKG007', 'Enhanced object support', 'NO', NULL, ''); -INSERT INTO sql_packages VALUES ('PKG008', 'Active database', 'NO', NULL, ''); -INSERT INTO sql_packages VALUES ('PKG010', 'OLAP', 'NO', NULL, 'NO'); - -GRANT SELECT ON sql_packages TO PUBLIC; - - -/* * 5.59 * SQL_PARTS table */ @@ -1769,26 +1719,6 @@ GRANT SELECT ON sql_sizing TO PUBLIC; /* - * SQL_SIZING_PROFILES table - * removed in SQL:2011 - */ - --- The data in this table are defined by various profiles of SQL. --- Since we don't have any information about such profiles, we provide --- an empty table. - -CREATE TABLE sql_sizing_profiles ( - sizing_id cardinal_number, - sizing_name character_data, - profile_id character_data, - required_value cardinal_number, - comments character_data -); - -GRANT SELECT ON sql_sizing_profiles TO PUBLIC; - - -/* * 5.61 * TABLE_CONSTRAINTS view */ diff --git a/src/backend/catalog/sql_feature_packages.txt b/src/backend/catalog/sql_feature_packages.txt index 382e4aea5c2..1d87a3e31e4 100644 --- a/src/backend/catalog/sql_feature_packages.txt +++ b/src/backend/catalog/sql_feature_packages.txt @@ -22,46 +22,17 @@ F021 Core F031 Core F041 Core F051 Core -F052 Enhanced datetime facilities F081 Core F131 Core F181 Core -F191 Enhanced integrity management F201 Core F221 Core F261 Core F311 Core -F411 Enhanced datetime facilities F471 Core F481 Core -F491 Enhanced integrity management F501 Core -F521 Enhanced integrity management -F555 Enhanced datetime facilities -F671 Enhanced integrity management -F701 Enhanced integrity management F812 Core S011 Core -S023 Basic object support -S024 Enhanced object support -S041 Basic object support -S043 Enhanced object support -S051 Basic object support -S071 Enhanced object support -S081 Enhanced object support -S111 Enhanced object support -S151 Basic object support -S161 Enhanced object support -S211 Enhanced object support -S231 Enhanced object support -T041 Basic object support -T191 Enhanced integrity management -T201 Enhanced integrity management -T211 Active database -T211 Enhanced integrity management -T212 Enhanced integrity management T321 Core -T322 PSM -T431 OLAP -T611 OLAP T631 Core diff --git a/src/backend/catalog/sql_features.txt b/src/backend/catalog/sql_features.txt index 9c68292a54d..ab3e381cffb 100644 --- a/src/backend/catalog/sql_features.txt +++ b/src/backend/catalog/sql_features.txt @@ -285,11 +285,7 @@ F492 Optional table constraint enforcement NO F501 Features and conformance views YES F501 Features and conformance views 01 SQL_FEATURES view 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 F531 Temporary tables YES F555 Enhanced seconds precision YES diff --git a/src/include/catalog/catversion.h b/src/include/catalog/catversion.h index c689b8fd0b2..1f6de76e9c4 100644 --- a/src/include/catalog/catversion.h +++ b/src/include/catalog/catversion.h @@ -53,6 +53,6 @@ */ /* yyyymmddN */ -#define CATALOG_VERSION_NO 201909251 +#define CATALOG_VERSION_NO 201910251 #endif diff --git a/src/test/regress/expected/sanity_check.out b/src/test/regress/expected/sanity_check.out index d6e75ffce6d..070de78e85c 100644 --- a/src/test/regress/expected/sanity_check.out +++ b/src/test/regress/expected/sanity_check.out @@ -177,11 +177,8 @@ shighway|t slow_emp4000|f sql_features|f sql_implementation_info|f -sql_languages|f -sql_packages|f sql_parts|f sql_sizing|f -sql_sizing_profiles|f stud_emp|f student|f tableam_parted_a_heap2|f |