Lines Matching refs:zSep
455 const char *zSep; /* Separator string */ in dump_table() local
472 zSep = "SELECT"; in dump_table()
474 strPrintf(&sql, "%s %s", zSep, az[i]); in dump_table()
475 zSep = ","; in dump_table()
478 zSep = " ORDER BY"; in dump_table()
480 strPrintf(&sql, "%s %d", zSep, i); in dump_table()
481 zSep = ","; in dump_table()
486 zSep = "("; in dump_table()
488 strPrintf(&ins, "%s%s", zSep, az[i]); in dump_table()
489 zSep = ","; in dump_table()
497 zSep = "("; in dump_table()
499 fprintf(out, "%s",zSep); in dump_table()
501 zSep = ","; in dump_table()
533 const char *zSep; /* Separator string */ in diff_one_table() local
603 zSep = "SELECT "; in diff_one_table()
605 strPrintf(&sql, "%sB.%s", zSep, az[i]); in diff_one_table()
606 zSep = ", "; in diff_one_table()
620 zSep = " WHERE"; in diff_one_table()
622 strPrintf(&sql, "%s A.%s=B.%s", zSep, az[i], az[i]); in diff_one_table()
623 zSep = " AND"; in diff_one_table()
625 zSep = "\n AND ("; in diff_one_table()
628 zSep, az[i], az2[i], az2[i+1]==0 ? ")" : ""); in diff_one_table()
629 zSep = " OR "; in diff_one_table()
634 zSep, az2[i], az2[i+1]==0 ? ")" : ""); in diff_one_table()
635 zSep = " OR "; in diff_one_table()
640 zSep = "SELECT "; in diff_one_table()
642 strPrintf(&sql, "%sA.%s", zSep, az[i]); in diff_one_table()
643 zSep = ", "; in diff_one_table()
652 zSep = " WHERE"; in diff_one_table()
654 strPrintf(&sql, "%s A.%s=B.%s", zSep, az[i], az[i]); in diff_one_table()
655 zSep = " AND"; in diff_one_table()
658 zSep = " UNION ALL\nSELECT "; in diff_one_table()
660 strPrintf(&sql, "%sB.%s", zSep, az[i]); in diff_one_table()
661 zSep = ", "; in diff_one_table()
670 zSep = " WHERE"; in diff_one_table()
672 strPrintf(&sql, "%s A.%s=B.%s", zSep, az[i], az[i]); in diff_one_table()
673 zSep = " AND"; in diff_one_table()
676 zSep = " "; in diff_one_table()
678 strPrintf(&sql, "%s%d", zSep, i); in diff_one_table()
679 zSep = ", "; in diff_one_table()
712 zSep = " SET"; in diff_one_table()
715 fprintf(out, "%s %s=", zSep, az2[(i+nPk-1)/2]); in diff_one_table()
716 zSep = ","; in diff_one_table()
722 zSep = " WHERE"; in diff_one_table()
724 fprintf(out, "%s %s=", zSep, az2[i]); in diff_one_table()
726 zSep = " AND"; in diff_one_table()
733 zSep = "("; in diff_one_table()
735 fprintf(out, "%s", zSep); in diff_one_table()
736 zSep = ","; in diff_one_table()
1173 const char *zSep, /* Separator string */ in strPrintfArray() argument
1179 if( i!=0 ) strPrintf(pStr, "%s", zSep); in strPrintfArray()
1399 const char *zSep; /* Separator string */ in summarize_one_table() local
1445 zSep = ", sum("; in summarize_one_table()
1447 strPrintf(&sql, "%sA.%s IS NOT B.%s", zSep, az[i], az[i]); in summarize_one_table()
1448 zSep = " OR "; in summarize_one_table()
1453 zSep = " WHERE"; in summarize_one_table()
1455 strPrintf(&sql, "%s A.%s=B.%s", zSep, az[i], az[i]); in summarize_one_table()
1456 zSep = " AND"; in summarize_one_table()
1462 zSep = "WHERE"; in summarize_one_table()
1464 strPrintf(&sql, "%s A.%s=B.%s", zSep, az[i], az[i]); in summarize_one_table()
1465 zSep = " AND"; in summarize_one_table()
1472 zSep = "WHERE"; in summarize_one_table()
1474 strPrintf(&sql, "%s A.%s=B.%s", zSep, az[i], az[i]); in summarize_one_table()
1475 zSep = " AND"; in summarize_one_table()
1591 const char *zSep; /* List separator */ in changeset_one_table() local
1628 zSep = " WHERE"; in changeset_one_table()
1630 strPrintf(&sql, "%s A.%s=B.%s", zSep, azCol[aiPk[i]], azCol[aiPk[i]]); in changeset_one_table()
1631 zSep = " AND"; in changeset_one_table()
1633 zSep = "\n AND ("; in changeset_one_table()
1636 strPrintf(&sql, "%sA.%s IS NOT B.%s", zSep, azCol[i], azCol[i]); in changeset_one_table()
1637 zSep = " OR\n "; in changeset_one_table()
1651 zSep = " WHERE"; in changeset_one_table()
1653 strPrintf(&sql, "%s A.%s=B.%s", zSep, azCol[aiPk[i]], azCol[aiPk[i]]); in changeset_one_table()
1654 zSep = " AND"; in changeset_one_table()
1667 zSep = " WHERE"; in changeset_one_table()
1669 strPrintf(&sql, "%s A.%s=B.%s", zSep, azCol[aiPk[i]], azCol[aiPk[i]]); in changeset_one_table()
1670 zSep = " AND"; in changeset_one_table()
1674 zSep = " "; in changeset_one_table()
1676 strPrintf(&sql, "%s %d", zSep, aiPk[i]+2); in changeset_one_table()
1677 zSep = ","; in changeset_one_table()