Fix TsClient multi-command type generation for UnnamedSingleColumnSet

vbilopav · claude · vbilopav · commit d7fdfdf98e5d · 2026-03-28T12:08:24.000+01:00
Single-column commands in multi-command SQL files now generate flat array
types (e.g., string[]) instead of object array types when
UnnamedSingleColumnSet is enabled, matching the actual JSON response shape.

Co-Authored-By: Claude Opus 4.6 (1M context) &lt;noreply@anthropic.com&gt;
diff --git a/plugins/NpgsqlRest.TsClient/TsClient.cs b/plugins/NpgsqlRest.TsClient/TsClient.cs
@@ -508,9 +508,15 @@ string GetReturnExp(string responseExp)
                         // Void command → rows affected count
                         mcResp.AppendLine($"    {cmdInfo.Name}: number;");
                     }
+                    else if (cmdInfo.ColumnCount == 1 && cmdInfo.ReturnsUnnamedSet)
+                    {
+                        // Single column with UnnamedSingleColumnSet — flat array
+                        var tsType = GetTsType(cmdInfo.ColumnTypeDescriptors[0], true);
+                        mcResp.AppendLine($"    {cmdInfo.Name}: {tsType}[];");
+                    }
                     else if (cmdInfo.ColumnCount == 1)
                     {
-                        // Single column
+                        // Single column — object array
                         var tsType = GetTsType(cmdInfo.ColumnTypeDescriptors[0], true);
                         mcResp.AppendLine($"    {cmdInfo.Name}: {{ {cmdInfo.ColumnNames[0]}: {tsType} }}[];");
                     }

Original file line number	Diff line number	Diff line change
`@@ -508,9 +508,15 @@ string GetReturnExp(string responseExp)`
`508`	`508`	`// Void command → rows affected count`
`509`	`509`	`mcResp.AppendLine($" {cmdInfo.Name}: number;");`
`510`	`510`	`}`
	`511`	`+ else if (cmdInfo.ColumnCount == 1 && cmdInfo.ReturnsUnnamedSet)`
	`512`	`+ {`
	`513`	`+ // Single column with UnnamedSingleColumnSet — flat array`
	`514`	`+ var tsType = GetTsType(cmdInfo.ColumnTypeDescriptors[0], true);`
	`515`	`+ mcResp.AppendLine($" {cmdInfo.Name}: {tsType}[];");`
	`516`	`+ }`
`511`	`517`	`else if (cmdInfo.ColumnCount == 1)`
`512`	`518`	`{`
`513`		`- // Single column`
	`519`	`+ // Single column — object array`
`514`	`520`	`var tsType = GetTsType(cmdInfo.ColumnTypeDescriptors[0], true);`
`515`	`521`	`mcResp.AppendLine($" {cmdInfo.Name}: {{ {cmdInfo.ColumnNames[0]}: {tsType} }}[];");`
`516`	`522`	`}`