38 Commits

Author SHA1 Message Date
jennifersp 14760fd32d support OUT parameter in functions (#2972) 2026-07-30 20:49:51 +00:00
Daylon Wilkins 2937c294da Context collections accept a database 2026-06-15 05:43:55 -07:00
Jason Fulghum 62c8a1686b Merge pull request #2832 from AniruthKarthik/fix-returns-table-substitution
Fix incorrect variable substitution for column references in PL/pgSQL
2026-06-10 11:52:14 -07:00
test 06c90bcf2c Fix incorrect variable substitution for column references in PL/pgSQL
This commit addresses issue #2354 where field names matching parameter or
variable names inside a PL/pgSQL function were incorrectly substituted
by the interpreter when used as part of a table alias or record (e.g. c.id).
By checking if a token is preceded by a dot (.), we can accurately
skip variable substitution for field identifiers.
2026-06-09 22:55:20 +05:30
Daylon Wilkins cfd2dc822c Added CREATE CAST alongside general bug fixes 2026-06-09 05:55:41 -07:00
jennifersp 7c6b9d817d support nested block statements and call statement in plpgsql (#2570) 2026-04-13 18:08:27 +00:00
jennifersp 09d90ef055 allow running multiple statements in function (#2501) 2026-04-06 18:30:16 +00:00
jennifersp 5da908162d add is distinct and not distinct from exprs (#2494) 2026-03-30 10:21:39 -07:00
jennifersp 2e722e9423 add fors plpgsql statement (#2472) 2026-03-24 05:41:10 +00:00
jennifersp 8fb1c2e108 support fori plpgsql statement (#2447) 2026-03-12 11:29:23 -07:00
jennifersp 43b468c000 Merge pull request #2350 from dolthub/jennifer/fix
add `plpgsql-dynexecute` statement for CREATE FUNCTION
2026-02-19 13:16:39 -08:00
jennifersp 8f66d1acfe add plpgsql-dynexecute statement 2026-02-18 12:47:53 -08:00
Jason Fulghum eea384490c pr feedback/notes/todos 2026-02-18 10:12:24 -08:00
Jason Fulghum 9f14225515 bugfix: support records containing non-DoltgresType values 2026-02-17 11:41:07 -08:00
Jason Fulghum 65f44d865f fixup: fix merge issue 2026-01-27 11:48:52 -08:00
Jason Fulghum 8175878b81 Support for UDFs with RETURNS TABLE 2026-01-27 11:32:40 -08:00
Jason Fulghum de5955f08b Initial support for UDFs with RETURNS SETOF 2026-01-27 11:29:59 -08:00
Daylon Wilkins 39898ce712 Fixed PL/pgSQL panic and part of issue #2197 2026-01-23 07:24:49 -08:00
Jason Fulghum 7b3a5bcd9a Initial support for UDFs with RETURNS SETOF 2026-01-13 11:07:11 -08:00
Daylon Wilkins f639d5e4ee Updated pganalyze 2025-12-15 04:30:46 -08:00
Daylon Wilkins 74ad3f92c8 Tables as types 2025-12-12 05:41:02 -08:00
Daylon Wilkins 9edc4b95b8 More dump-related fixes 2025-10-14 05:02:29 -07:00
James Cor 40960acbca [no-release-notes] move interpreter interfaces (#1435) 2025-04-30 13:48:38 -07:00
Daylon Wilkins 3d1e87e5bc Added support for triggers 2025-04-25 04:23:53 -07:00
Daylon Wilkins b44f7cea7a Fixed interpretation calls within DML 2025-04-22 18:53:02 -07:00
Daylon Wilkins 19a4ca14bf Root Object Rework 2025-03-28 05:46:54 -07:00
Jason Fulghum a9262ea849 Initial support for RAISE in PL/pgSQL 2025-03-12 12:57:09 -07:00
Jason Fulghum f6b16a800e Add support for CASE ... WHEN in PL/pgSQL 2025-02-27 15:35:55 -08:00
Daylon Wilkins 58a3ff4ad6 Changed created functions to persist on the root 2025-02-18 06:02:17 -08:00
Daylon Wilkins 99cf6f438b Added loop structures and label support 2025-02-14 04:38:37 -08:00
Jason Fulghum 9717f0acf7 Moving While::Convert method 2025-02-12 16:06:12 -08:00
Jason Fulghum 6b4836dde9 Adding support for WHILE statements 2025-02-12 13:45:52 -08:00
Daylon Wilkins 6bd6b6b91d Fixed CREATE FUNCTION not executing some statements 2025-02-12 05:44:12 -08:00
Daylon Wilkins 4c772a9dba Added SELECT ... INTO and PERFORM, plus bugfixes 2025-02-11 06:31:16 -08:00
Jason Fulghum df95bad355 Fixing bugs in function variable reference substitution 2025-02-10 16:16:22 -08:00
Daylon Wilkins 4d1c49faa6 PR feedback 2025-02-07 01:19:49 -08:00
Jason Fulghum 2c40fd3dde Merge branch 'main' into daylon/create-function-conversion 2025-02-05 16:47:59 -08:00
Daylon Wilkins c49b3b65f1 Parse CREATE FUNCTION into runnable functions 2025-02-05 09:49:28 -08:00