changeset 336:08165f6b7828

Searching into file names cause JOIN failure,... disabled.
author HIROSE Yuuji <yuuji@gentei.org>
date Sat, 22 Oct 2016 00:39:53 +0859
parents a120ba2d719b
children 48d0b6c4de65
files s4-blog.sh
diffstat 1 files changed, 4 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/s4-blog.sh	Sat Oct 22 00:15:09 2016 +0859
+++ b/s4-blog.sh	Sat Oct 22 00:39:53 2016 +0859
@@ -521,19 +521,20 @@
 	    (SELECT a.id,
 		    a.blogid,
 		    s.ctime,
-		    s.text || ' ' || m.filenames content
+		    s.text /* || ' ' || m.filenames */ content
 	     FROM article a
 	       JOIN
 	          (SELECT id,  /* Create [id, ctime, text] from article_s */
 		          max(CASE key WHEN 'ctime' THEN val END) ctime,
 		     	  max(CASE key WHEN 'text' THEN val END) text
 	      	   FROM article_s GROUP BY id) s
+	       /*
 	       JOIN
 	          (SELECT id, group_concat(val) filenames
 		   FROM article_m
 		   WHERE type LIKE 'file:%'
-	      	   GROUP BY id) m
-	       ON a.id=s.id AND a.id=m.id WHERE $kc$kwdgrp) x
+	      	   GROUP BY id) m */
+	       ON a.id=s.id /* AND a.id=m.id */ WHERE $kc$kwdgrp) x
 	   ON b.id=x.blogid
        WHERE b.id IN (SELECT id FROM blog_s $cond)
        ORDER by DATE DESC, TITLE, x.ctime;"

yatex.org