mirror of
https://github.com/FerretDB/documentdb.git
synced 2026-11-08 03:52:41 -05:00
Parag Jain
60dc82a14c
### Does this PR have any customer impact? ### Type (Feature, Refactoring, Bugfix, DevOps, Testing, Perf, etc) ### Does it involve schema level changes? (Table, Column, Index, UDF, etc level changes) ### Are you introducing any new config? If yes, do you have tests with and without them being set? ### ChangeLog (Refer [Template](../oss/CHANGELOG.md)) ### Description Fixing collection/empty API for new tables which has 3 columns only.
22 lines
824 B
SQL
22 lines
824 B
SQL
/*
|
|
* __API_SCHEMA__.collection() can be used to query collections, e.g.:
|
|
* SELECT * FROM __API_SCHEMA__.collection('db','collection')
|
|
*
|
|
* While this seems slow, we use the planner hook to replace this function
|
|
* directly with the table, so we usually do not call it directly.
|
|
*
|
|
* Output arguments need to match data tables exactly.
|
|
*/
|
|
DROP FUNCTION IF EXISTS __API_SCHEMA_V2__.collection(text,text);
|
|
CREATE OR REPLACE FUNCTION __API_SCHEMA_V2__.collection(
|
|
p_database_name text,
|
|
p_collection_name text,
|
|
OUT shard_key_value bigint,
|
|
OUT object_id __CORE_SCHEMA__.bson,
|
|
OUT document __CORE_SCHEMA__.bson)
|
|
RETURNS SETOF record
|
|
LANGUAGE c
|
|
STRICT
|
|
AS 'MODULE_PATHNAME', $function$command_api_collection$function$;
|
|
COMMENT ON FUNCTION __API_SCHEMA_V2__.collection(text,text)
|
|
IS 'query a collection'; |