From: Alan Knowles <alan@roojs.com>
Date: Wed, 9 Dec 2020 07:14:40 +0000 (+0800)
Subject: mysql/core_translate_lookup.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=3870a8edb0364bf3a8b0404f60064ca17abebd11

mysql/core_translate_lookup.sql
---

diff --git a/mysql/core_translate_lookup.sql b/mysql/core_translate_lookup.sql
index 30e130a0..04223bb4 100644
--- a/mysql/core_translate_lookup.sql
+++ b/mysql/core_translate_lookup.sql
@@ -18,8 +18,9 @@ RETURNS TEXT NOT DETERMINISTIC READS SQL DATA
         SET v_id = 0;
         
         SELECT
-            v_id,
-            v_ret
+            id , txt
+            INTO
+            v_id, v_ret
         FROM
             core_templatestr
         WHERE