changeset 784:f9702e2c6591 feature-world

Ensure to roder by rowid
author HIROSE Yuuji <yuuji@gentei.org>
date Sat, 13 Jun 2020 07:49:52 +0900
parents 5adf7e5a5fcc
children 1f310d682c07
files s4-migrate.sh
diffstat 1 files changed, 5 insertions(+), 5 deletions(-) [+]
line wrap: on
line diff
--- a/s4-migrate.sh	Fri Jun 12 21:27:53 2020 +0900
+++ b/s4-migrate.sh	Sat Jun 13 07:49:52 2020 +0900
@@ -53,14 +53,13 @@
 	  WHERE id IN ($blogs);
 	EOF
   done
-  for blogid in $blogs; do
-    for tbl in article article_s article_m; do
-      query <<-EOF
+  for tbl in article article_s article_m; do
+    query <<-EOF
 	REPLACE INTO dst.$tbl
 	  SELECT * FROM main.$tbl
-	  WHERE id IN (SELECT id FROM main.article WHERE blogid IN ($blogs));
+	  WHERE id IN (SELECT id FROM main.article WHERE blogid IN ($blogs))
+	  ORDER BY rowid;
 	EOF
-    done
   done
   ## Check the equality of two DBs
   echo "grid=$grid grp=$grp qgrp=$qgrp" | htmlescape
@@ -121,6 +120,7 @@
 	EOF
     # Create blog-rowid conversion table
     sedfile=$tmpd/arttrans.sed
+    sedfile=tmp/arttrans.sed
     query <<-EOF > $sedfile
 	WITH arttrans AS (
 	  SELECT s.rowid srcrid, d.rowid dstrid

yatex.org