Repository: vitessio/vitess
Pull request #8385 (2021-06-25 17:52:19)

VReplication Reverse Workflows: add keyspace scope to vindex while creating reverse vreplication streams


## Description

For sharded streams we add filters like `select * from customer where in_keyrange(customer_id, 'keyspace1.hash', '-7f')` where the vindex is scoped by the source keyspace. This is needed since other keyspaces might also contain vindexes of the same name and using just the vindex name would create an ambiguity. 

This logic was missing while creating reverse streams which this PR adds.

Signed-off-by: Rohit Nayak <rohit@planetscale.com>

## Related Issue(s)
https://github.com/vitessio/vitess/issues/8259

## Checklist
- [X] Tests were added or are not required



Patch:
diff --git a/go.mod b/go.mod
index 1286be7195..89782e04f8 100644
--- a/go.mod
+++ b/go.mod
@@ -72,7 +72,6 @@ require (
 	github.com/pires/go-proxyproto v0.0.0-20191211124218-517ecdf5bb2b
 	github.com/pkg/errors v0.9.1
 	github.com/planetscale/pargzip v0.0.0-20201116224723-90c7fc03ea8a
-	github.com/planetscale/tengo v0.9.6-ps.v4
 	github.com/planetscale/vtprotobuf v0.0.0-20210521163914-5a02622d1e2a
 	github.com/prometheus/client_golang v1.11.0
 	github.com/prometheus/common v0.26.0
@@ -80,6 +79,7 @@ require (
 	github.com/samuel/go-zookeeper v0.0.0-20200724154423-2164a8ac840e
 	github.com/satori/go.uuid v1.2.0 // indirect
 	github.com/sjmudd/stopwatch v0.0.0-20170613150411-f380bf8a9be1
+	github.com/skeema/tengo v0.0.0-00010101000000-000000000000
 	github.com/soheilhy/cmux v0.1.4
 	github.com/spf13/cobra v1.1.1
 	github.com/spf13/pflag v1.0.5
@@ -123,4 +123,6 @@ require (
 	sigs.k8s.io/yaml v1.2.0
 )
 
+replace github.com/skeema/tengo => github.com/planetscale/tengo v0.9.6-ps.v3
+
 replace google.golang.org/grpc => google.golang.org/grpc v1.37.0
diff --git a/go.sum b/go.sum
index c9ac0cc202..f1b8fbd157 100644
--- a/go.sum
+++ b/go.sum
@@ -704,8 +704,8 @@ github.com/pkg/errors v0.9.1 h1:FEBLx1zS214owpjy7qsBeixbURkuhQAwrK5UwLGTwt4=
 github.com/pkg/errors v0.9.1/go.mod h1:bwawxfHBFNV+L2hUp1rHADufV3IMtnDRdf1r5NINEl0=
 github.com/planetscale/pargzip v0.0.0-20201116224723-90c7fc03ea8a h1:y0OpQ4+5tKxeh9+H+2cVgASl9yMZYV9CILinKOiKafA=
 github.com/planetscale/pargzip v0.0.0-20201116224723-90c7fc03ea8a/go.mod h1:GJFUzQuXIoB2Kjn1ZfDhJr/42D5nWOqRcIQVgCxTuIE=
-github.com/planetscale/tengo v0.9.6-ps.v4 h1:nLGFobPtYEZDmuRww38RJiP7gVWVLBMzpTUysLIUF7Q=
-github.com/planetscale/tengo v0.9.6-ps.v4/go.mod h1:Xwj7BHMQW30k479dZvWIl/WOCy33skXRjYZLsKgAINM=
+github.com/planetscale/tengo v0.9.6-ps.v3 h1:cWMH1CovRAUyQnnvhAyYJqaNvzcoHOpEwN2VBmWjwV8=
+github.com/planetscale/tengo v0.9.6-ps.v3/go.mod h1:nbQ0n1EK3lP00xvBmEPO05bPDCPZiDFnU1YlAN8JoC8=
 github.com/planetscale/vtprotobuf v0.0.0-20210521163914-5a02622d1e2a h1:qr27Mt+/BoONcc6hogjN5PPCykCxXvJMpXCtYMMgkws=
 github.com/planetscale/vtprotobuf v0.0.0-20210521163914-5a02622d1e2a/go.mod h1:8abDv+/TBY4d10QUVQgKYCy6+xk9SQPorWPZDqTkPHM=
 github.com/pmezard/go-difflib v0.0.0-20151028094244-d8ed2627bdf0/go.mod h1:iKH77koFhYxTK1pcRnkKkqfTogsbg7gZNVY4sRDYZ/4=
diff --git a/go/vt/schema/online_ddl.go b/go/vt/schema/online_ddl.go
index 81f0d506f2..894fe6c300 100644
--- a/go/vt/schema/online_ddl.go
+++ b/go/vt/schema/online_ddl.go
@@ -172,7 +172,7 @@ func onlineDDLStatementSanity(sql string, ddlStmt sqlparser.DDLStatement) error
 	if err := sqlparser.Walk(validateWalk, ddlStmt); err != nil {
 		switch err {
 		case ErrForeignKeyFound:
-			return vterrors.Errorf(vtrpcpb.Code_ABORTED, "foreign key constraints are not supported in online DDL, see https://vitess.io/blog/2021-06-15-online-ddl-why-no-fk/")
+			return vterrors.Errorf(vtrpcpb.Code_ABORTED, "foreign key constraints are not supported in online DDL, see https://code.openark.org/blog/mysql/the-problem-with-mysql-foreign-key-constraints-in-online-schema-changes")
 		case ErrRenameTableFound:
 			return vterrors.Errorf(vtrpcpb.Code_ABORTED, "ALTER TABLE ... RENAME is not supported in online DDL")
 		}
diff --git a/go/vt/sqlparser/ast.go b/go/vt/sqlparser/ast.go
index 35160dbd3c..db3d010d4a 100644
--- a/go/vt/sqlparser/ast.go
+++ b/go/vt/sqlparser/ast.go
@@ -201,9 +201,9 @@ type (
 		Distinct         bool
 		StraightJoinHint bool
 		SQLCalcFoundRows bool
-		From             []TableExpr
 		Comments         Comments
 		SelectExprs      SelectExprs
+		From             TableExprs
 		Where            *Where
 		GroupBy          GroupBy
 		Having           *Where
diff --git a/go/vt/sqlparser/ast_clone.go b/go/vt/sqlparser/ast_clone.go
index 901029c6aa..16f9e2ed2c 100644
--- a/go/vt/sqlparser/ast_clone.go
+++ b/go/vt/sqlparser/ast_clone.go
@@ -1342,9 +1342,9 @@ func CloneRefOfSelect(n *Select) *Select {
 	}
 	out := *n
 	out.Cache = CloneRefOfBool(n.Cache)
-	out.From = CloneSliceOfTableExpr(n.From)
 	out.Comments = CloneComments(n.Comments)
 	out.SelectExprs = CloneSelectExprs(n.SelectExprs)
+	out.From = CloneTableExprs(n.From)
 	out.Where = CloneRefOfWhere(n.Where)
 	out.GroupBy = CloneGroupBy(n.GroupBy)
 	out.Having = CloneRefOfWhere(n.Having)
@@ -2366,15 +2366,6 @@ func CloneRefOfBool(n *bool) *bool {
 	return &out
 }
 
-// CloneSliceOfTableExpr creates a deep clone of the input.
-func CloneSliceOfTableExpr(n []TableExpr) []TableExpr {
-	res := make([]TableExpr, 0, len(n))
-	for _, x := range n {
-		res = append(res, CloneTableExpr(x))
-	}
-	return res
-}
-
 // CloneSliceOfCharacteristic creates a deep clone of the input.
 func CloneSliceOfCharacteristic(n []Characteristic) []Characteristic {
 	res := make([]Characteristic, 0, len(n))
diff --git a/go/vt/sqlparser/ast_equals.go b/go/vt/sqlparser/ast_equals.go
index 7f3ccf22cb..1107a2489c 100644
--- a/go/vt/sqlparser/ast_equals.go
+++ b/go/vt/sqlparser/ast_equals.go
@@ -2149,9 +2149,9 @@ func EqualsRefOfSelect(a, b *Select) bool {
 		a.StraightJoinHint == b.StraightJoinHint &&
 		a.SQLCalcFoundRows == b.SQLCalcFoundRows &&
 		EqualsRefOfBool(a.Cache, b.Cache) &&
-		EqualsSliceOfTableExpr(a.From, b.From) &&
 		EqualsComments(a.Comments, b.Comments) &&
 		EqualsSelectExprs(a.SelectExprs, b.SelectExprs) &&
+		EqualsTableExprs(a.From, b.From) &&
 		EqualsRefOfWhere(a.Where, b.Where) &&
 		EqualsGroupBy(a.GroupBy, b.GroupBy) &&
 		EqualsRefOfWhere(a.Having, b.Having) &&
@@ -3890,19 +3890,6 @@ func EqualsRefOfBool(a, b *bool) bool {
 	return *a == *b
 }
 
-// EqualsSliceOfTableExpr does deep equals between the two objects.
-func EqualsSliceOfTableExpr(a, b []TableExpr) bool {
-	if len(a) != len(b) {
-		return false
-	}
-	for i := 0; i < len(a); i++ {
-		if !EqualsTableExpr(a[i], b[i]) {
-			return false
-		}
-	}
-	return true
-}
-
 // EqualsSliceOfCharacteristic does deep equals between the two objects.
 func EqualsSliceOfCharacteristic(a, b []Characteristic) bool {
 	if len(a) != len(b) {
diff --git a/go/vt/sqlparser/ast_format.go b/go/vt/sqlparser/ast_format.go
index 43e1f7f716..1ce0e24c30 100644
--- a/go/vt/sqlparser/ast_format.go
+++ b/go/vt/sqlparser/ast_format.go
@@ -43,16 +43,9 @@ func (node *Select) Format(buf *TrackedBuffer) {
 		buf.WriteString(SQLCalcFoundRowsStr)
 	}
 
-	buf.astPrintf(node, "%v from ", node.SelectExprs)
-
-	prefix := ""
-	for _, expr := range node.From {
-		buf.astPrintf(node, "%s%v", prefix, expr)
-		prefix = ", "
-	}
-
-	buf.astPrintf(node, "%v%v%v%v%v%s%v",
-		node.Where,
+	buf.astPrintf(node, "%v from %v%v%v%v%v%v%s%v",
+		node.SelectExprs,
+		node.From, node.Where,
 		node.GroupBy, node.Having, node.OrderBy,
 		node.Limit, node.Lock.ToString(), node.Into)
 }
diff --git a/go/vt/sqlparser/ast_format_fast.go b/go/vt/sqlparser/ast_format_fast.go
index 4dd76509ab..4302c556de 100644
--- a/go/vt/sqlparser/ast_format_fast.go
+++ b/go/vt/sqlparser/ast_format_fast.go
@@ -48,12 +48,7 @@ func (node *Select) formatFast(buf *TrackedBuffer) {
 	node.SelectExprs.formatFast(buf)
 	buf.WriteString(" from ")
 
-	prefix := ""
-	for _, expr := range node.From {
-		buf.WriteString(prefix)
-		expr.formatFast(buf)
-		prefix = ", "
-	}
+	node.From.formatFast(buf)
 
 	node.Where.formatFast(buf)
 
diff --git a/go/vt/sqlparser/ast_funcs.go b/go/vt/sqlparser/ast_funcs.go
index 5029e6d569..84b3218093 100644
--- a/go/vt/sqlparser/ast_funcs.go
+++ b/go/vt/sqlparser/ast_funcs.go
@@ -1339,15 +1339,3 @@ func handleUnaryMinus(expr Expr) Expr {
 func encodeSQLString(val string) string {
 	return sqltypes.EncodeStringSQL(val)
 }
-
-// ToString prints the list of table expressions as a string
-// To be used as an alternate for String for []TableExpr
-func ToString(exprs []TableExpr) string {
-	buf := NewTrackedBuffer(nil)
-	prefix := ""
-	for _, expr := range exprs {
-		buf.astPrintf(nil, "%s%v", prefix, expr)
-		prefix = ", "
-	}
-	return buf.String()
-}
diff --git a/go/vt/sqlparser/ast_rewrite.go b/go/vt/sqlparser/ast_rewrite.go
index c54f1feff3..0ca9fbf25a 100644
--- a/go/vt/sqlparser/ast_rewrite.go
+++ b/go/vt/sqlparser/ast_rewrite.go
@@ -3320,15 +3320,6 @@ func (a *application) rewriteRefOfSelect(parent SQLNode, node *Select, replacer
 			return true
 		}
 	}
-	for x, el := range node.From {
-		if !a.rewriteTableExpr(node, el, func(idx int) replacerFunc {
-			return func(newNode, parent SQLNode) {
-				parent.(*Select).From[idx] = newNode.(TableExpr)
-			}
-		}(x)) {
-			return false
-		}
-	}
 	if !a.rewriteComments(node, node.Comments, func(newNode, parent SQLNode) {
 		parent.(*Select).Comments = newNode.(Comments)
 	}) {
@@ -3339,6 +3330,11 @@ func (a *application) rewriteRefOfSelect(parent SQLNode, node *Select, replacer
 	}) {
 		return false
 	}
+	if !a.rewriteTableExprs(node, node.From, func(newNode, parent SQLNode) {
+		parent.(*Select).From = newNode.(TableExprs)
+	}) {
+		return false
+	}
 	if !a.rewriteRefOfWhere(node, node.Where, func(newNode, parent SQLNode) {
 		parent.(*Select).Where = newNode.(*Where)
 	}) {
diff --git a/go/vt/sqlparser/ast_visit.go b/go/vt/sqlparser/ast_visit.go
index 9acffb6323..d2d1aafa99 100644
--- a/go/vt/sqlparser/ast_visit.go
+++ b/go/vt/sqlparser/ast_visit.go
@@ -1679,17 +1679,15 @@ func VisitRefOfSelect(in *Select, f Visit) error {
 	if cont, err := f(in); err != nil || !cont {
 		return err
 	}
-	for _, el := range in.From {
-		if err := VisitTableExpr(el, f); err != nil {
-			return err
-		}
-	}
 	if err := VisitComments(in.Comments, f); err != nil {
 		return err
 	}
 	if err := VisitSelectExprs(in.SelectExprs, f); err != nil {
 		return err
 	}
+	if err := VisitTableExprs(in.From, f); err != nil {
+		return err
+	}
 	if err := VisitRefOfWhere(in.Where, f); err != nil {
 		return err
 	}
diff --git a/go/vt/sqlparser/cached_size.go b/go/vt/sqlparser/cached_size.go
index 1aa0a172e9..c34d52e057 100644
--- a/go/vt/sqlparser/cached_size.go
+++ b/go/vt/sqlparser/cached_size.go
@@ -1676,15 +1676,6 @@ func (cached *Select) CachedSize(alloc bool) int64 {
 	}
 	// field Cache *bool
 	size += int64(1)
-	// field From []vitess.io/vitess/go/vt/sqlparser.TableExpr
-	{
-		size += int64(cap(cached.From)) * int64(16)
-		for _, elem := range cached.From {
-			if cc, ok := elem.(cachedObject); ok {
-				size += cc.CachedSize(true)
-			}
-		}
-	}
 	// field Comments vitess.io/vitess/go/vt/sqlparser.Comments
 	{
 		size += int64(cap(cached.Comments)) * int64(16)
@@ -1701,6 +1692,15 @@ func (cached *Select) CachedSize(alloc bool) int64 {
 			}
 		}
 	}
+	// field From vitess.io/vitess/go/vt/sqlparser.TableExprs
+	{
+		size += int64(cap(cached.From)) * int64(16)
+		for _, elem := range cached.From {
+			if cc, ok := elem.(cachedObject); ok {
+				size += cc.CachedSize(true)
+			}
+		}
+	}
 	// field Where *vitess.io/vitess/go/vt/sqlparser.Where
 	size += cached.Where.CachedSize(true)
 	// field GroupBy vitess.io/vitess/go/vt/sqlparser.GroupBy
diff --git a/go/vt/sqlparser/impossible_query.go b/go/vt/sqlparser/impossible_query.go
index dc8a2a931a..2437b55158 100644
--- a/go/vt/sqlparser/impossible_query.go
+++ b/go/vt/sqlparser/impossible_query.go
@@ -27,13 +27,7 @@ package sqlparser
 func FormatImpossibleQuery(buf *TrackedBuffer, node SQLNode) {
 	switch node := node.(type) {
 	case *Select:
-		buf.Myprintf("select %v from ", node.SelectExprs)
-		var prefix string
-		for _, n := range node.From {
-			buf.Myprintf("%s%v", prefix, n)
-			prefix = ", "
-		}
-		buf.Myprintf(" where 1 != 1")
+		buf.Myprintf("select %v from %v where 1 != 1", node.SelectExprs, node.From)
 		if node.GroupBy != nil {
 			node.GroupBy.Format(buf)
 		}
diff --git a/go/vt/vtctl/grpcvtctldserver/topo.go b/go/vt/vtctl/grpcvtctldserver/topo.go
index 90b6ea4e0a..a8d501d152 100644
--- a/go/vt/vtctl/grpcvtctldserver/topo.go
+++ b/go/vt/vtctl/grpcvtctldserver/topo.go
@@ -19,7 +19,6 @@ package grpcvtctldserver
 import (
 	"context"
 	"fmt"
-	"time"
 
 	"vitess.io/vitess/go/trace"
 	"vitess.io/vitess/go/vt/log"
@@ -216,8 +215,9 @@ func deleteTablet(ctx context.Context, ts *topo.Server, alias *topodatapb.Tablet
 
 				return topo.NewError(topo.NoUpdateNeeded, si.Keyspace()+"/"+si.ShardName())
 			}
+
 			si.MasterAlias = nil
-			si.SetMasterTermStartTime(time.Now())
+
 			return nil
 		}); err != nil {
 			return err
diff --git a/go/vt/vtctl/workflow/vexec/vexec.go b/go/vt/vtctl/workflow/vexec/vexec.go
index 5f9f284171..93c5359d06 100644
--- a/go/vt/vtctl/workflow/vexec/vexec.go
+++ b/go/vt/vtctl/workflow/vexec/vexec.go
@@ -265,7 +265,7 @@ func extractTableName(stmt sqlparser.Statement) (string, error) {
 	case *sqlparser.Insert:
 		return sqlparser.String(stmt.Table), nil
 	case *sqlparser.Select:
-		return sqlparser.ToString(stmt.From), nil
+		return sqlparser.String(stmt.From), nil
 	}
 
 	return "", fmt.Errorf("%w: %+v", ErrUnsupportedQuery, sqlparser.String(stmt))
diff --git a/go/vt/vtgate/planbuilder/ddl.go b/go/vt/vtgate/planbuilder/ddl.go
index 43af38f061..8a25be2b9d 100644
--- a/go/vt/vtgate/planbuilder/ddl.go
+++ b/go/vt/vtgate/planbuilder/ddl.go
@@ -163,7 +163,7 @@ func checkFKError(vschema ContextVSchema, ddlStatement sqlparser.DDLStatement) e
 		fk := &fkContraint{}
 		_ = sqlparser.Walk(fk.FkWalk, ddlStatement)
 		if fk.found {
-			return vterrors.Errorf(vtrpcpb.Code_ABORTED, "foreign key constraints are not allowed, see https://vitess.io/blog/2021-06-15-online-ddl-why-no-fk/")
+			return vterrors.Errorf(vtrpcpb.Code_ABORTED, "foreign key constraints are not allowed, see https://code.openark.org/blog/mysql/the-problem-with-mysql-foreign-key-constraints-in-online-schema-changes")
 		}
 	}
 	return nil
diff --git a/go/vt/vtgate/planbuilder/joinGen4.go b/go/vt/vtgate/planbuilder/joinGen4.go
index 4339f1f245..67f26ff341 100644
--- a/go/vt/vtgate/planbuilder/joinGen4.go
+++ b/go/vt/vtgate/planbuilder/joinGen4.go
@@ -17,9 +17,7 @@ limitations under the License.
 package planbuilder
 
 import (
-	vtrpcpb "vitess.io/vitess/go/vt/proto/vtrpc"
 	"vitess.io/vitess/go/vt/sqlparser"
-	"vitess.io/vitess/go/vt/vterrors"
 	"vitess.io/vitess/go/vt/vtgate/engine"
 	"vitess.io/vitess/go/vt/vtgate/semantics"
 )
@@ -93,17 +91,12 @@ func (j *joinGen4) Primitive() engine.Primitive {
 
 // Inputs implements the logicalPlan interface
 func (j *joinGen4) Inputs() []logicalPlan {
-	return []logicalPlan{j.Left, j.Right}
+	panic("implement me")
 }
 
 // Rewrite implements the logicalPlan interface
 func (j *joinGen4) Rewrite(inputs ...logicalPlan) error {
-	if len(inputs) != 2 {
-		return vterrors.New(vtrpcpb.Code_INTERNAL, "wrong number of children")
-	}
-	j.Left = inputs[0]
-	j.Right = inputs[1]
-	return nil
+	panic("implement me")
 }
 
 // ContainsTables implements the logicalPlan interface
diff --git a/go/vt/vtgate/planbuilder/route_planning.go b/go/vt/vtgate/planbuilder/route_planning.go
index be4e7feebe..a955caf09d 100644
--- a/go/vt/vtgate/planbuilder/route_planning.go
+++ b/go/vt/vtgate/planbuilder/route_planning.go
@@ -261,10 +261,13 @@ func planHorizon(sel *sqlparser.Select, plan logicalPlan, semTable *semantics.Se
 		return plan, nil
 	}
 
-	if err := checkUnsupportedConstructs(sel); err != nil {
-		return nil, err
+	// TODO real horizon planning to be done
+	if sel.Distinct {
+		return nil, semantics.Gen4NotSupportedF("DISTINCT")
+	}
+	if sel.GroupBy != nil {
+		return nil, semantics.Gen4NotSupportedF("GROUP BY")
 	}
-
 	qp, err := createQPFromSelect(sel)
 	if err != nil {
 		return nil, err
@@ -275,16 +278,6 @@ func planHorizon(sel *sqlparser.Select, plan logicalPlan, semTable *semantics.Se
 		}
 	}
 
-	for _, expr := range qp.aggrExprs {
-		funcExpr, ok := expr.Expr.(*sqlparser.FuncExpr)
-		if !ok {
-			return nil, vterrors.New(vtrpcpb.Code_INTERNAL, "expected an aggregation here")
-		}
-		if funcExpr.Distinct {
-			return nil, semantics.Gen4NotSupportedF("distinct aggregation")
-		}
-	}
-
 	if len(qp.aggrExprs) > 0 {
 		plan, err = planAggregations(qp, plan, semTable)
 		if err != nil {
@@ -315,19 +308,6 @@ func createSingleShardRoutePlan(sel *sqlparser.Select, rb *route) {
 	}
 }
 
-func checkUnsupportedConstructs(sel *sqlparser.Select) error {
-	if sel.Distinct {
-		return semantics.Gen4NotSupportedF("DISTINCT")
-	}
-	if sel.GroupBy != nil {
-		return semantics.Gen4NotSupportedF("GROUP BY")
-	}
-	if sel.Having != nil {
-		return semantics.Gen4NotSupportedF("HAVING")
-	}
-	return nil
-}
-
 func pushJoinPredicate(exprs []sqlparser.Expr, tree joinTree, semTable *semantics.SemTable) (joinTree, error) {
 	switch node := tree.(type) {
 	case *routePlan:
diff --git a/go/vt/vtgate/planbuilder/symtab.go b/go/vt/vtgate/planbuilder/symtab.go
index 658f52d5c9..afaffea1f9 100644
--- a/go/vt/vtgate/planbuilder/symtab.go
+++ b/go/vt/vtgate/planbuilder/symtab.go
@@ -172,7 +172,7 @@ func (st *symtab) AddTable(t *table) error {
 		st.singleRoute = nil
 	}
 	if _, ok := st.tables[t.alias]; ok {
-		return vterrors.NewErrorf(vtrpcpb.Code_INVALID_ARGUMENT, vterrors.NonUniqTable, "Not unique table/alias: '%s'", t.alias.Name.String())
+		return fmt.Errorf("duplicate symbol: %s", sqlparser.String(t.alias))
 	}
 	st.tables[t.alias] = t
 	st.tableNames = append(st.tableNames, t.alias)
diff --git a/go/vt/vtgate/semantics/analyzer.go b/go/vt/vtgate/semantics/analyzer.go
index 8b4993dc1e..3bb8d2bcd0 100644
--- a/go/vt/vtgate/semantics/analyzer.go
+++ b/go/vt/vtgate/semantics/analyzer.go
@@ -67,22 +67,17 @@ func (a *analyzer) analyzeDown(cursor *sqlparser.Cursor) bool {
 	n := cursor.Node()
 	switch node := n.(type) {
 	case *sqlparser.Select:
-		if node.Having != nil {
-			a.err = Gen4NotSupportedF("HAVING")
-		}
 		a.push(newScope(current))
 		a.selectScope[node] = a.currentScope()
+		if err := a.analyzeTableExprs(node.From); err != nil {
+			a.err = err
+			return false
+		}
 	case *sqlparser.DerivedTable:
 		a.err = Gen4NotSupportedF("derived tables")
-	case sqlparser.TableExpr:
-		_, isSelect := cursor.Parent().(*sqlparser.Select)
-		if isSelect {
-			a.push(newScope(nil))
-		}
-		switch node := node.(type) {
-		case *sqlparser.AliasedTableExpr:
-			a.err = a.bindTable(node, node.Expr)
-		}
+	case *sqlparser.TableExprs:
+		// this has already been visited when we encountered the SELECT struct
+		return false
 
 	// we don't need to push new scope for sub queries since we do that for SELECT and UNION
 
@@ -95,18 +90,6 @@ func (a *analyzer) analyzeDown(cursor *sqlparser.Cursor) bool {
 		} else {
 			a.exprDeps[node] = t
 		}
-	case *sqlparser.FuncExpr:
-		if node.Distinct {
-			err := vterrors.Errorf(vtrpcpb.Code_INVALID_ARGUMENT, "syntax error: %s", sqlparser.String(node))
-			if len(node.Exprs) != 1 {
-				a.err = err
-			} else if _, ok := node.Exprs[0].(*sqlparser.AliasedExpr); !ok {
-				a.err = err
-			}
-		}
-		if sqlparser.IsLockingFunc(node) {
-			a.err = Gen4NotSupportedF("locking functions")
-		}
 	}
 
 	// this is the visitor going down the tree. Returning false here would just not visit the children
@@ -129,6 +112,42 @@ func (a *analyzer) resolveColumn(colName *sqlparser.ColName, current *scope) (Ta
 	return a.tableSetFor(t.ASTNode), nil
 }
 
+func (a *analyzer) analyzeTableExprs(tablExprs sqlparser.TableExprs) error {
+	for _, tableExpr := range tablExprs {
+		if err := a.analyzeTableExpr(tableExpr); err != nil {
+			return err
+		}
+	}
+	return nil
+}
+
+func (a *analyzer) analyzeTableExpr(tableExpr sqlparser.TableExpr) error {
+	switch table := tableExpr.(type) {
+	case *sqlparser.AliasedTableExpr:
+		return a.bindTable(table, table.Expr)
+	case *sqlparser.JoinTableExpr:
+		return a.analyzeJoinTableExpr(table)
+	case *sqlparser.ParenTableExpr:
+		return a.analyzeTableExprs(table.Exprs)
+	}
+	return nil
+}
+
+func (a *analyzer) analyzeJoinTableExpr(table *sqlparser.JoinTableExpr) error {
+	switch table.Join {
+	case sqlparser.NormalJoinType, sqlparser.LeftJoinType, sqlparser.RightJoinType:
+		if err := a.analyzeTableExpr(table.LeftExpr); err != nil {
+			return err
+		}
+		if err := a.analyzeTableExpr(table.RightExpr); err != nil {
+			return err
+		}
+	default:
+		return Gen4NotSupportedF("join type %s", table.Join.ToString())
+	}
+	return nil
+}
+
 // resolveQualifiedColumn handles `tabl.col` expressions
 func (a *analyzer) resolveQualifiedColumn(current *scope, expr *sqlparser.ColName) (*TableInfo, error) {
 	// search up the scope stack until we find a match
@@ -143,7 +162,7 @@ func (a *analyzer) resolveQualifiedColumn(current *scope, expr *sqlparser.ColNam
 		}
 		current = current.parent
 	}
-	return nil, vterrors.NewErrorf(vtrpcpb.Code_INVALID_ARGUMENT, vterrors.BadFieldError, "symbol %s not found", sqlparser.String(expr))
+	return nil, vterrors.NewErrorf(vtrpcpb.Code_INVALID_ARGUMENT, vterrors.BadFieldError, "Unknown table referenced by '%s'", sqlparser.String(expr))
 }
 
 // resolveUnQualifiedColumn
@@ -227,21 +246,6 @@ func (a *analyzer) analyzeUp(cursor *sqlparser.Cursor) bool {
 	switch cursor.Node().(type) {
 	case *sqlparser.Union, *sqlparser.Select:
 		a.popScope()
-	case sqlparser.TableExpr:
-		_, isSelect := cursor.Parent().(*sqlparser.Select)
-		if isSelect {
-			curScope := a.currentScope()
-			a.popScope()
-			earlierScope := a.currentScope()
-			// copy curScope into the earlierScope
-			for _, table := range curScope.tables {
-				err := earlierScope.addTable(table)
-				if err != nil {
-					a.err = err
-					break
-				}
-			}
-		}
 	}
 	return a.shouldContinue()
 }
diff --git a/go/vt/vttablet/onlineddl/executor.go b/go/vt/vttablet/onlineddl/executor.go
index 105471789a..ca9b277b03 100644
--- a/go/vt/vttablet/onlineddl/executor.go
+++ b/go/vt/vttablet/onlineddl/executor.go
@@ -64,7 +64,7 @@ import (
 
 	mysqldriver "github.com/go-sql-driver/mysql"
 	"github.com/jmoiron/sqlx"
-	"github.com/planetscale/tengo"
+	"github.com/skeema/tengo"
 )
 
 var (
diff --git a/go/vt/vttablet/tabletmanager/shard_sync.go b/go/vt/vttablet/tabletmanager/shard_sync.go
index 0b376cdaab..155009898a 100644
--- a/go/vt/vttablet/tabletmanager/shard_sync.go
+++ b/go/vt/vttablet/tabletmanager/shard_sync.go
@@ -105,17 +105,15 @@ func (tm *TabletManager) shardSyncLoop(ctx context.Context, notifyChan <-chan st
 			}
 			// If we think we're master, check if we need to update the shard record.
 			// Fetch the start time from the record we just got, because the tm's tablet can change.
-			masterAlias, shouldDemote, err := syncShardMaster(ctx, tm.TopoServer, tablet, logutil.ProtoToTime(tablet.MasterTermStartTime))
+			masterAlias, err := syncShardMaster(ctx, tm.TopoServer, tablet, logutil.ProtoToTime(tablet.MasterTermStartTime))
 			if err != nil {
 				log.Errorf("Failed to sync shard record: %v", err)
 				// Start retry timer and go back to sleep.
 				retryChan = time.After(*shardSyncRetryDelay)
 				continue
 			}
-			if shouldDemote {
-				// Someone updated the masterTermStartTime while we still think we're master.
-				// This means that we should abort our term, since someone else must have claimed mastership
-				// and wrote to the shard record
+			if !topoproto.TabletAliasEqual(masterAlias, tablet.Alias) {
+				// Another master has taken over while we still think we're master.
 				if err := tm.abortMasterTerm(ctx, masterAlias); err != nil {
 					log.Errorf("Failed to abort master term: %v", err)
 					// Start retry timer and go back to sleep.
@@ -156,12 +154,11 @@ func (tm *TabletManager) shardSyncLoop(ctx context.Context, notifyChan <-chan st
 // If the shard record indicates a new master has taken over, this returns
 // success (we successfully synchronized), but the returned masterAlias will be
 // different from the input tablet.Alias.
-func syncShardMaster(ctx context.Context, ts *topo.Server, tablet *topodatapb.Tablet, masterTermStartTime time.Time) (masterAlias *topodatapb.TabletAlias, shouldDemote bool, err error) {
+func syncShardMaster(ctx context.Context, ts *topo.Server, tablet *topodatapb.Tablet, masterTermStartTime time.Time) (masterAlias *topodatapb.TabletAlias, err error) {
 	ctx, cancel := context.WithTimeout(ctx, *topo.RemoteOperationTimeout)
 	defer cancel()
 
 	var shardInfo *topo.ShardInfo
-	shouldDemote = false
 	_, err = ts.UpdateShardFields(ctx, tablet.Keyspace, tablet.Shard, func(si *topo.ShardInfo) error {
 		lastTerm := si.GetMasterTermStartTime()
 
@@ -169,11 +166,6 @@ func syncShardMaster(ctx context.Context, ts *topo.Server, tablet *topodatapb.Ta
 		// We can't use the return value of UpdateShardFields because it might be nil.
 		shardInfo = si
 
-		if masterTermStartTime.Before(lastTerm) {
-			// In this case, we have outdated information, we will demote ourself
-			shouldDemote = true
-		}
-
 		// Only attempt an update if our term is more recent.
 		if !masterTermStartTime.After(lastTerm) {
 			return topo.NewError(topo.NoUpdateNeeded, si.ShardName())
@@ -186,10 +178,10 @@ func syncShardMaster(ctx context.Context, ts *topo.Server, tablet *topodatapb.Ta
 		return nil
 	})
 	if err != nil {
-		return nil, shouldDemote, err
+		return nil, err
 	}
 
-	return shardInfo.MasterAlias, shouldDemote, nil
+	return shardInfo.MasterAlias, nil
 }
 
 // abortMasterTerm is called when we unexpectedly lost mastership.
@@ -233,14 +225,8 @@ func (tm *TabletManager) abortMasterTerm(ctx context.Context, masterAlias *topod
 	setMasterCtx, cancelSetMaster := context.WithTimeout(ctx, *topo.RemoteOperationTimeout)
 	defer cancelSetMaster()
 	log.Infof("Attempting to reparent self to new master %v.", masterAliasStr)
-	if masterAlias == nil {
-		if err := tm.tmState.ChangeTabletType(ctx, topodatapb.TabletType_REPLICA, DBActionNone); err != nil {
-			return err
-		}
-	} else {
-		if err := tm.SetMaster(setMasterCtx, masterAlias, 0, "", true); err != nil {
-			return vterrors.Wrap(err, "failed to reparent self to new master")
-		}
+	if err := tm.SetMaster(setMasterCtx, masterAlias, 0, "", true); err != nil {
+		return vterrors.Wrap(err, "failed to reparent self to new master")
 	}
 	return nil
 }
diff --git a/go/vt/vttablet/tabletmanager/vreplication/controller_plan.go b/go/vt/vttablet/tabletmanager/vreplication/controller_plan.go
index f55c9c715d..2f0da8e9c4 100644
--- a/go/vt/vttablet/tabletmanager/vreplication/controller_plan.go
+++ b/go/vt/vttablet/tabletmanager/vreplication/controller_plan.go
@@ -221,12 +221,12 @@ func buildDeletePlan(del *sqlparser.Delete) (*controllerPlan, error) {
 }
 
 func buildSelectPlan(sel *sqlparser.Select) (*controllerPlan, error) {
-	switch sqlparser.ToString(sel.From) {
+	switch sqlparser.String(sel.From) {
 	case vreplicationTableName, reshardingJournalTableName, copyStateTableName, vreplicationLogTableName:
 		return &controllerPlan{
 			opcode: selectQuery,
 		}, nil
 	default:
-		return nil, fmt.Errorf("invalid table name: %v", sqlparser.ToString(sel.From))
+		return nil, fmt.Errorf("invalid table name: %v", sqlparser.String(sel.From))
 	}
 }
diff --git a/go/vt/vttablet/tabletserver/planbuilder/builder.go b/go/vt/vttablet/tabletserver/planbuilder/builder.go
index 528825ef3d..51b72d3e62 100644
--- a/go/vt/vttablet/tabletserver/planbuilder/builder.go
+++ b/go/vt/vttablet/tabletserver/planbuilder/builder.go
@@ -45,7 +45,7 @@ func analyzeSelect(sel *sqlparser.Select, tables map[string]*schema.Table) (plan
 	// Check if it's a NEXT VALUE statement.
 	if nextVal, ok := sel.SelectExprs[0].(*sqlparser.Nextval); ok {
 		if plan.Table == nil || plan.Table.Type != schema.Sequence {
-			return nil, vterrors.Errorf(vtrpcpb.Code_INVALID_ARGUMENT, "%s is not a sequence", sqlparser.ToString(sel.From))
+			return nil, vterrors.Errorf(vtrpcpb.Code_INVALID_ARGUMENT, "%s is not a sequence", sqlparser.String(sel.From))
 		}
 		plan.PlanID = PlanNextval
 		v, err := sqlparser.NewPlanValue(nextVal.Expr)
diff --git a/go/vt/vttablet/vexec/vexec.go b/go/vt/vttablet/vexec/vexec.go
index dd7b92e4f5..50b84ceb43 100644
--- a/go/vt/vttablet/vexec/vexec.go
+++ b/go/vt/vttablet/vexec/vexec.go
@@ -195,7 +195,7 @@ func (e *TabletVExec) analyzeStatement() error {
 		e.TableName = sqlparser.String(stmt.Table)
 		e.InsertCols = e.analyzeInsertColumns(stmt)
 	case *sqlparser.Select:
-		e.TableName = sqlparser.ToString(stmt.From)
+		e.TableName = sqlparser.String(stmt.From)
 		e.WhereCols = e.analyzeWhereEqualsColumns(stmt.Where)
 	default:
 		return fmt.Errorf("query not supported by vexec: %+v", sqlparser.String(stmt))
diff --git a/go/vt/wrangler/tablet.go b/go/vt/wrangler/tablet.go
index 9f7c49b679..077db77b51 100644
--- a/go/vt/wrangler/tablet.go
+++ b/go/vt/wrangler/tablet.go
@@ -139,7 +139,6 @@ func (wr *Wrangler) DeleteTablet(ctx context.Context, tabletAlias *topodatapb.Ta
 				return topo.NewError(topo.NoUpdateNeeded, si.Keyspace()+"/"+si.ShardName())
 			}
 			si.MasterAlias = nil
-			si.SetMasterTermStartTime(time.Now())
 			return nil
 		}); err != nil {
 			return err
diff --git a/go/vt/wrangler/traffic_switcher.go b/go/vt/wrangler/traffic_switcher.go
index e07a86b175..1052ccfc40 100644
--- a/go/vt/wrangler/traffic_switcher.go
+++ b/go/vt/wrangler/traffic_switcher.go
@@ -1128,7 +1128,7 @@ func (ts *trafficSwitcher) createReverseVReplication(ctx context.Context) error
 					}
 					// TODO(sougou): handle degenerate cases like sequence, etc.
 					// We currently assume the primary vindex is the best way to filter, which may not be true.
-					inKeyrange = fmt.Sprintf(" where in_keyrange(%s, '%s', '%s')", sqlparser.String(vtable.ColumnVindexes[0].Columns[0]), vtable.ColumnVindexes[0].Type, key.KeyRangeString(source.GetShard().KeyRange))
+					inKeyrange = fmt.Sprintf(" where in_keyrange(%s, '%s.%s', '%s')", sqlparser.String(vtable.ColumnVindexes[0].Columns[0]), ts.sourceKeyspace, vtable.ColumnVindexes[0].Name, key.KeyRangeString(source.GetShard().KeyRange))
 				}
 				filter = fmt.Sprintf("select * from %s%s", rule.Match, inKeyrange)
 			}
diff --git a/go/vt/wrangler/vdiff.go b/go/vt/wrangler/vdiff.go
index 61cdc09c13..c03d4da471 100644
--- a/go/vt/wrangler/vdiff.go
+++ b/go/vt/wrangler/vdiff.go
@@ -1108,7 +1108,7 @@ func (td *tableDiffer) genDebugQueryDiff(sel *sqlparser.Select, row []sqltypes.V
 		sel.SelectExprs.Format(buf)
 	}
 	buf.Myprintf(" from ")
-	buf.Myprintf(sqlparser.ToString(sel.From))
+	sel.From.Format(buf)
 	buf.Myprintf(" where ")
 	for i, pkI := range td.selectPks {
 		sel.SelectExprs[pkI].Format(buf)
diff --git a/go/vt/wrangler/vexec_plan.go b/go/vt/wrangler/vexec_plan.go
index 8ced8dc9be..a279a4145e 100644
--- a/go/vt/wrangler/vexec_plan.go
+++ b/go/vt/wrangler/vexec_plan.go
@@ -178,7 +178,7 @@ func extractTableName(stmt sqlparser.Statement) (string, error) {
 	case *sqlparser.Insert:
 		return sqlparser.String(stmt.Table), nil
 	case *sqlparser.Select:
-		return sqlparser.ToString(stmt.From), nil
+		return sqlparser.String(stmt.From), nil
 	}
 	return "", fmt.Errorf("query not supported by vexec: %+v", sqlparser.String(stmt))
 }


Test patch:
diff --git a/go/test/endtoend/vreplication/config.go b/go/test/endtoend/vreplication/config.go
index 937d27bf90..8ffe0724ae 100644
--- a/go/test/endtoend/vreplication/config.go
+++ b/go/test/endtoend/vreplication/config.go
@@ -42,7 +42,7 @@ create table tenant(tenant_id binary(16), name varbinary(16), primary key (tenan
 	    "reverse_bits": {
 	      "type": "reverse_bits"
 	    },
-		"binary_md5": {
+		"bmd5": {
           "type": "binary_md5"
 		}
 	  },
@@ -75,7 +75,7 @@ create table tenant(tenant_id binary(16), name varbinary(16), primary key (tenan
           "column_vindexes": [
 	        {
 	          "column": "tenant_id",
-	          "name": "binary_md5"
+	          "name": "bmd5"
 	        }
 	      ]
 		}
diff --git a/go/test/endtoend/vreplication/vreplication_test.go b/go/test/endtoend/vreplication/vreplication_test.go
index 3fa3976e38..6d460a6251 100644
--- a/go/test/endtoend/vreplication/vreplication_test.go
+++ b/go/test/endtoend/vreplication/vreplication_test.go
@@ -25,9 +25,8 @@ import (
 	"testing"
 	"time"
 
-	"github.com/stretchr/testify/require"
-
 	"github.com/stretchr/testify/assert"
+	"github.com/stretchr/testify/require"
 
 	"vitess.io/vitess/go/mysql"
 	"vitess.io/vitess/go/test/endtoend/cluster"
@@ -299,6 +298,11 @@ func shardCustomer(t *testing.T, testReverse bool, cells []*Cell, sourceCellOrAl
 			printShardPositions(vc, ksShards)
 			switchWrites(t, reverseKsWorkflow, false)
 
+			output, err := vc.VtctlClient.ExecuteCommandWithOutput("Workflow", ksWorkflow, "show")
+			require.NoError(t, err)
+			require.Contains(t, output, "'customer.reverse_bits'")
+			require.Contains(t, output, "'customer.bmd5'")
+
 			insertQuery1 = "insert into customer(cid, name) values(1002, 'tempCustomer5')"
 			require.True(t, validateThatQueryExecutesOnTablet(t, vtgateConn, productTab, "product", insertQuery1, matchInsertQuery1))
 			// both inserts go into 80-, this tests the edge-case where a stream (-80) has no relevant new events after the previous switch
@@ -314,7 +318,7 @@ func shardCustomer(t *testing.T, testReverse bool, cells []*Cell, sourceCellOrAl
 			dropSourcesDryRun(t, ksWorkflow, true, dryRunResultsDropSourcesRenameCustomerShard)
 
 			var exists bool
-			exists, err := checkIfBlacklistExists(t, vc, "product:0", "customer")
+			exists, err = checkIfBlacklistExists(t, vc, "product:0", "customer")
 			require.NoError(t, err, "Error getting blacklist for customer:0")
 			require.True(t, exists)
 			dropSources(t, ksWorkflow)
diff --git a/go/vt/vtgate/planbuilder/testdata/aggr_cases.txt b/go/vt/vtgate/planbuilder/testdata/aggr_cases.txt
index b109137932..e4a697bb9c 100644
--- a/go/vt/vtgate/planbuilder/testdata/aggr_cases.txt
+++ b/go/vt/vtgate/planbuilder/testdata/aggr_cases.txt
@@ -1342,4 +1342,3 @@ Gen4 plan same as above
 # syntax error detected by planbuilder
 "select count(distinct *) from user"
 "syntax error: count(distinct *)"
-Gen4 plan same as above
diff --git a/go/vt/vtgate/planbuilder/testdata/ddl_cases_no_default_keyspace.txt b/go/vt/vtgate/planbuilder/testdata/ddl_cases_no_default_keyspace.txt
index 50afcc55b8..190ed35ad1 100644
--- a/go/vt/vtgate/planbuilder/testdata/ddl_cases_no_default_keyspace.txt
+++ b/go/vt/vtgate/planbuilder/testdata/ddl_cases_no_default_keyspace.txt
@@ -42,7 +42,6 @@
     "Query": "create view view_a as select 1 from `user`"
   }
 }
-Gen4 plan same as above
 
 # create view with '*' expression for simple route
 "create view user.view_a as select user.* from user"
@@ -103,18 +102,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select * from authoritative"
   }
 }
-{
-  "QueryType": "DDL",
-  "Original": "create view user.view_a as select * from authoritative",
-  "Instructions": {
-    "OperatorType": "DDL",
-    "Keyspace": {
-      "Name": "user",
-      "Sharded": true
-    },
-    "Query": "create view view_a as select authoritative.user_id as user_id, authoritative.col1 as col1, authoritative.col2 as col2 from authoritative"
-  }
-}
 
 # create view with select * from join of authoritative tables
 "create view user.view_a as select * from authoritative a join authoritative b on a.user_id=b.user_id"
@@ -130,18 +117,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select * from authoritative as a join authoritative as b on a.user_id = b.user_id"
   }
 }
-{
-  "QueryType": "DDL",
-  "Original": "create view user.view_a as select * from authoritative a join authoritative b on a.user_id=b.user_id",
-  "Instructions": {
-    "OperatorType": "DDL",
-    "Keyspace": {
-      "Name": "user",
-      "Sharded": true
-    },
-    "Query": "create view view_a as select a.user_id as user_id, a.col1 as col1, a.col2 as col2, b.user_id as user_id, b.col1 as col1, b.col2 as col2 from authoritative as a join authoritative as b on a.user_id = b.user_id"
-  }
-}
 
 # create view with select * from qualified authoritative table
 "create view user.view_a as select a.* from authoritative a"
@@ -157,18 +132,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select a.* from authoritative as a"
   }
 }
-{
-  "QueryType": "DDL",
-  "Original": "create view user.view_a as select a.* from authoritative a",
-  "Instructions": {
-    "OperatorType": "DDL",
-    "Keyspace": {
-      "Name": "user",
-      "Sharded": true
-    },
-    "Query": "create view view_a as select a.user_id as user_id, a.col1 as col1, a.col2 as col2 from authoritative as a"
-  }
-}
 
 # create view with select * from intermixing of authoritative table with non-authoritative results in no expansion
 "create view user.view_a as select * from authoritative join user on authoritative.user_id=user.id"
@@ -184,6 +147,7 @@ Gen4 plan same as above
     "Query": "create view view_a as select * from authoritative join `user` on authoritative.user_id = `user`.id"
   }
 }
+
 # create view with select authoritative.* with intermixing still expands
 "create view user.view_a as select user.id, a.*, user.col1 from authoritative a join user on a.user_id=user.id"
 {
@@ -198,18 +162,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select `user`.id, a.*, `user`.col1 from authoritative as a join `user` on a.user_id = `user`.id"
   }
 }
-{
-  "QueryType": "DDL",
-  "Original": "create view user.view_a as select user.id, a.*, user.col1 from authoritative a join user on a.user_id=user.id",
-  "Instructions": {
-    "OperatorType": "DDL",
-    "Keyspace": {
-      "Name": "user",
-      "Sharded": true
-    },
-    "Query": "create view view_a as select `user`.id, a.user_id as user_id, a.col1 as col1, a.col2 as col2, `user`.col1 from authoritative as a join `user` on a.user_id = `user`.id"
-  }
-}
 
 # create view with auto-resolve anonymous columns for simple route
 "create view user.view_a as select col from user join user_extra on user.id = user_extra.user_id"
@@ -240,7 +192,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select `user`.id from `user` join user_extra on `user`.id = user_extra.user_id"
   }
 }
-Gen4 plan same as above
 
 # create view with last_insert_id for unsharded route
 "create view main.view_a as select last_insert_id() as x from main.unsharded"
@@ -256,7 +207,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select :__lastInsertId as x from unsharded"
   }
 }
-Gen4 plan same as above
 
 # create view with select from pinned table
 "create view user.view_a as select * from pin_test"
@@ -272,7 +222,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select * from pin_test"
   }
 }
-Gen4 plan same as above
 
 # create view with Expression with single-route reference
 "create view user.view_a as select user.col, user_extra.id + user_extra.col from user join user_extra on user.id = user_extra.user_id"
@@ -288,7 +237,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select `user`.col, user_extra.id + user_extra.col from `user` join user_extra on `user`.id = user_extra.user_id"
   }
 }
-Gen4 plan same as above
 
 # create view with Comments
 "create view user.view_a as select /* comment */ user.col from user join user_extra on user.id = user_extra.user_id"
@@ -304,7 +252,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select /* comment */ `user`.col from `user` join user_extra on `user`.id = user_extra.user_id"
   }
 }
-Gen4 plan same as above
 
 # create view with for update
 "create view user.view_a as select user.col from user join user_extra on user.id = user_extra.user_id for update"
@@ -320,7 +267,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select `user`.col from `user` join user_extra on `user`.id = user_extra.user_id for update"
   }
 }
-Gen4 plan same as above
 
 # create view with Case preservation
 "create view user.view_a as select user.Col, user_extra.Id from user join user_extra on user.id = user_extra.user_id"
@@ -336,12 +282,10 @@ Gen4 plan same as above
     "Query": "create view view_a as select `user`.Col, user_extra.Id from `user` join user_extra on `user`.id = user_extra.user_id"
   }
 }
-Gen4 plan same as above
 
 # create view with syntax error
 "create view user.view_a as the quick brown fox"
 "syntax error at position 31 near 'the'"
-Gen4 plan same as above
 
 # create view with Hex number is not treated as a simple value
 "create view user.view_a as select * from user where id = 0x04"
@@ -372,7 +316,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select * from `user` where `name` = 'abc' and id = 4 limit 5"
   }
 }
-Gen4 plan same as above
 
 # create view with Multiple parenthesized expressions
 "create view user.view_a as select * from user where (id = 4) AND (name ='abc') limit 5"
@@ -388,7 +331,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select * from `user` where id = 4 and `name` = 'abc' limit 5"
   }
 }
-Gen4 plan same as above
 
 # create view with Multiple parenthesized expressions
 "create view user.view_a as select * from user where (id = 4 and name ='abc') limit 5"
@@ -404,7 +346,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select * from `user` where id = 4 and `name` = 'abc' limit 5"
   }
 }
-Gen4 plan same as above
 
 # create view with Column Aliasing with Table.Column
 "create view user.view_a as select user0_.col as col0_ from user user0_ where id = 1 order by user0_.col"
@@ -420,7 +361,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select user0_.col as col0_ from `user` as user0_ where id = 1 order by user0_.col asc"
   }
 }
-Gen4 plan same as above
 
 # create view with Column Aliasing with Column
 "create view user.view_a as select user0_.col as col0_ from user user0_ where id = 1 order by col0_ desc"
@@ -436,7 +376,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select user0_.col as col0_ from `user` as user0_ where id = 1 order by col0_ desc"
   }
 }
-Gen4 plan same as above
 
 # create view with Booleans and parenthesis
 "create view user.view_a as select * from user where (id = 1) AND name = true"
@@ -452,7 +391,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select * from `user` where id = 1 and `name` = true"
   }
 }
-Gen4 plan same as above
 
 # create view with union with the same target shard
 "create view user.view_a as select * from music where user_id = 1 union select * from user where id = 1"
@@ -468,7 +406,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select * from music where user_id = 1 union select * from `user` where id = 1"
   }
 }
-Gen4 plan same as above
 
 # create view with testing SingleRow Projection
 "create view user.view_a as select 42 from user"
@@ -484,7 +421,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select 42 from `user`"
   }
 }
-Gen4 plan same as above
 
 # create view with sql_calc_found_rows without limit
 "create view user.view_a as select sql_calc_found_rows * from music where user_id = 1"
@@ -500,18 +436,6 @@ Gen4 plan same as above
     "Query": "create view view_a as select * from music where user_id = 1"
   }
 }
-{
-  "QueryType": "DDL",
-  "Original": "create view user.view_a as select sql_calc_found_rows * from music where user_id = 1",
-  "Instructions": {
-    "OperatorType": "DDL",
-    "Keyspace": {
-      "Name": "user",
-      "Sharded": true
-    },
-    "Query": "create view view_a as select sql_calc_found_rows * from music where user_id = 1"
-  }
-}
 
 # DDL
 "create index a on user(id)"
@@ -527,7 +451,6 @@ Gen4 plan same as above
     "Query": "alter table `user` add index a (id)"
   }
 }
-Gen4 plan same as above
 
 #Alter table with qualifier
 "alter table user ADD id int"
@@ -543,7 +466,6 @@ Gen4 plan same as above
     "Query": "alter table `user` add column id int"
   }
 }
-Gen4 plan same as above
 
 # Alter View
 "alter view user_extra as select* from user"
@@ -563,7 +485,6 @@ Gen4 plan same as above
 # Alter View with unknown view
 "alter view unknown as select* from user"
 "keyspace not specified"
-Gen4 plan same as above
 
 # drop table with qualifier in one
 "drop table user.user, user_extra"
@@ -579,17 +500,14 @@ Gen4 plan same as above
     "Query": "drop table `user`, user_extra"
   }
 }
-Gen4 plan same as above
 
 # drop table with incompatible tables
 "drop table user, unsharded_a"
 "Tables or Views specified in the query do not belong to the same destination"
-Gen4 plan same as above
 
 # drop table with unknown table
 "drop table unknown"
 "keyspace not specified"
-Gen4 plan same as above
 
 # drop view with 1 view without qualifier
 "drop view user.user, user_extra"
@@ -605,17 +523,14 @@ Gen4 plan same as above
     "Query": "drop view `user`, user_extra"
   }
 }
-Gen4 plan same as above
 
 # drop view with incompatible views
 "drop view user, unsharded_a"
 "Tables or Views specified in the query do not belong to the same destination"
-Gen4 plan same as above
 
 # drop view with unknown view
 "drop view unknown"
 "keyspace not specified"
-Gen4 plan same as above
 
 # Truncate table without qualifier
 "truncate user_extra"
@@ -631,7 +546,6 @@ Gen4 plan same as above
     "Query": "truncate table user_extra"
   }
 }
-Gen4 plan same as above
 
 # Rename table
 "rename table user_extra to b"
@@ -647,14 +561,11 @@ Gen4 plan same as above
     "Query": "rename table user_extra to b"
   }
 }
-Gen4 plan same as above
 
 # Rename table with different keyspace tables
 "rename table user_extra to b, main.a to b"
 "Tables or Views specified in the query do not belong to the same destination"
-Gen4 plan same as above
 
 # Rename table with change in keyspace name
 "rename table user_extra to main.b"
 "Changing schema from 'user' to 'main' is not allowed"
-Gen4 plan same as above
diff --git a/go/vt/vtgate/planbuilder/testdata/filter_cases.txt b/go/vt/vtgate/planbuilder/testdata/filter_cases.txt
index 4be2688c68..c8370b7562 100644
--- a/go/vt/vtgate/planbuilder/testdata/filter_cases.txt
+++ b/go/vt/vtgate/planbuilder/testdata/filter_cases.txt
@@ -1280,7 +1280,6 @@ Gen4 plan same as above
 # unresolved symbol in inner subquery.
 "select id from user where id = :a and user.col in (select user_extra.col from user_extra where user_extra.user_id = :a and foo.id = 1)"
 "symbol foo.id not found"
-Gen4 plan same as above
 
 # outer and inner subquery route by same outermost column value
 "select id2 from user uu where id in (select id from user where id = uu.id and user.col in (select user_extra.col from user_extra where user_extra.user_id = uu.id))"
@@ -2000,44 +1999,3 @@ Gen4 plan same as above
   }
 }
 Gen4 plan same as above
-
-
-"select * from samecolvin where col = :col"
-{
-  "QueryType": "SELECT",
-  "Original": "select * from samecolvin where col = :col",
-  "Instructions": {
-    "OperatorType": "Route",
-    "Variant": "SelectEqualUnique",
-    "Keyspace": {
-      "Name": "user",
-      "Sharded": true
-    },
-    "FieldQuery": "select col from samecolvin where 1 != 1",
-    "Query": "select col from samecolvin where col = :col",
-    "Table": "samecolvin",
-    "Values": [
-      ":col"
-    ],
-    "Vindex": "vindex1"
-  }
-}
-{
-  "QueryType": "SELECT",
-  "Original": "select * from samecolvin where col = :col",
-  "Instructions": {
-    "OperatorType": "Route",
-    "Variant": "SelectEqualUnique",
-    "Keyspace": {
-      "Name": "user",
-      "Sharded": true
-    },
-    "FieldQuery": "select samecolvin.col as col from samecolvin where 1 != 1",
-    "Query": "select samecolvin.col as col from samecolvin where col = :col",
-    "Table": "samecolvin",
-    "Values": [
-      ":col"
-    ],
-    "Vindex": "vindex1"
-  }
-}
diff --git a/go/vt/vtgate/planbuilder/testdata/flush_cases_no_default_keyspace.txt b/go/vt/vtgate/planbuilder/testdata/flush_cases_no_default_keyspace.txt
index e0e4d3a10f..19e25ca060 100644
--- a/go/vt/vtgate/planbuilder/testdata/flush_cases_no_default_keyspace.txt
+++ b/go/vt/vtgate/planbuilder/testdata/flush_cases_no_default_keyspace.txt
@@ -27,12 +27,10 @@
     ]
   }
 }
-Gen4 plan same as above
 
 # Flush statement with flush options
 "flush no_write_to_binlog hosts, logs"
 "keyspace not specified"
-Gen4 plan same as above
 
 # Flush statement with routing rules
 "flush local tables route1, route2"
@@ -63,12 +61,10 @@ Gen4 plan same as above
     ]
   }
 }
-Gen4 plan same as above
 
 # Incorrect tables in flush
 "flush tables user.a with read lock"
 "table a not found"
-Gen4 plan same as above
 
 # Unknown tables in unsharded keyspaces are allowed
 "flush tables main.a with read lock"
@@ -85,7 +81,6 @@ Gen4 plan same as above
     "Query": "flush tables a with read lock"
   }
 }
-Gen4 plan same as above
 
 # Flush statement with 3 keyspaces
 "flush local tables user, unsharded_a, user_extra, unsharded_tab with read lock"
@@ -125,4 +120,3 @@ Gen4 plan same as above
     ]
   }
 }
-Gen4 plan same as above
diff --git a/go/vt/vtgate/planbuilder/testdata/from_cases.txt b/go/vt/vtgate/planbuilder/testdata/from_cases.txt
index 3a0e1b308d..a90000dcea 100644
--- a/go/vt/vtgate/planbuilder/testdata/from_cases.txt
+++ b/go/vt/vtgate/planbuilder/testdata/from_cases.txt
@@ -2685,7 +2685,6 @@ Gen4 plan same as above
 # verify ',' vs JOIN precedence
 "select u1.a from unsharded u1, unsharded u2 join unsharded u3 on u1.a = u2.a"
 "symbol u1.a not found"
-Gen4 plan same as above
 
 # first expression fails for ',' join (code coverage: ensure error is returned)
 "select user.foo.col from user.foo, user"
@@ -2695,7 +2694,6 @@ Gen4 plan same as above
 # table names should be case-sensitive
 "select unsharded.id from unsharded where Unsharded.val = 1"
 "symbol Unsharded.val not found"
-Gen4 plan same as above
 
 # implicit table reference for sharded keyspace
 "select user.foo.col from user.foo"
@@ -2704,13 +2702,11 @@ Gen4 plan same as above
 
 # duplicate symbols
 "select user.id from user join user"
-"Not unique table/alias: 'user'"
-Gen4 plan same as above
+"duplicate symbol: `user`"
 
 # duplicate symbols for merging routes
 "select user.id from user join user_extra user on user.id = user.user_id"
-"Not unique table/alias: 'user'"
-Gen4 plan same as above
+"duplicate symbol: `user`"
 
 # non-existent table
 "select c from t"
diff --git a/go/vt/vtgate/planbuilder/testdata/postprocess_cases.txt b/go/vt/vtgate/planbuilder/testdata/postprocess_cases.txt
index e204b6fea3..55fe2c9ff4 100644
--- a/go/vt/vtgate/planbuilder/testdata/postprocess_cases.txt
+++ b/go/vt/vtgate/planbuilder/testdata/postprocess_cases.txt
@@ -822,7 +822,6 @@ Gen4 plan same as above
 # Order by, qualified '*' expression, name mismatched.
 "select user.* from user where id = 5 order by e.col"
 "symbol e.col not found"
-Gen4 plan same as above
 
 # Order by, invalid column number
 "select col from user order by 18446744073709551616"
diff --git a/go/vt/vtgate/planbuilder/testdata/vindex_func_cases.txt b/go/vt/vtgate/planbuilder/testdata/vindex_func_cases.txt
index c81faa8c7c..d2ae819cd3 100644
--- a/go/vt/vtgate/planbuilder/testdata/vindex_func_cases.txt
+++ b/go/vt/vtgate/planbuilder/testdata/vindex_func_cases.txt
@@ -303,3 +303,24 @@ Gen4 plan same as above
 
 "select none from user_index where id = :id"
 "symbol `none` not found in table or subquery"
+
+"select * from samecolvin where col = :col"
+{
+  "QueryType": "SELECT",
+  "Original": "select * from samecolvin where col = :col",
+  "Instructions": {
+    "OperatorType": "Route",
+    "Variant": "SelectEqualUnique",
+    "Keyspace": {
+      "Name": "user",
+      "Sharded": true
+    },
+    "FieldQuery": "select col from samecolvin where 1 != 1",
+    "Query": "select col from samecolvin where col = :col",
+    "Table": "samecolvin",
+    "Values": [
+      ":col"
+    ],
+    "Vindex": "vindex1"
+  }
+}
diff --git a/go/vt/vtgate/planbuilder/testdata/wireup_cases.txt b/go/vt/vtgate/planbuilder/testdata/wireup_cases.txt
index 80ca3f3367..190692c0d0 100644
--- a/go/vt/vtgate/planbuilder/testdata/wireup_cases.txt
+++ b/go/vt/vtgate/planbuilder/testdata/wireup_cases.txt
@@ -127,59 +127,6 @@
     ]
   }
 }
-{
-  "QueryType": "SELECT",
-  "Original": "select u1.id from user u1 join user u2 join user u3 where u3.col = u1.col",
-  "Instructions": {
-    "OperatorType": "Join",
-    "Variant": "Join",
-    "JoinColumnIndexes": "1",
-    "TableName": "`user`_`user`_`user`",
-    "Inputs": [
-      {
-        "OperatorType": "Route",
-        "Variant": "SelectScatter",
-        "Keyspace": {
-          "Name": "user",
-          "Sharded": true
-        },
-        "FieldQuery": "select 1 from `user` as u2 where 1 != 1",
-        "Query": "select 1 from `user` as u2",
-        "Table": "`user`"
-      },
-      {
-        "OperatorType": "Join",
-        "Variant": "Join",
-        "JoinColumnIndexes": "-2",
-        "TableName": "`user`_`user`",
-        "Inputs": [
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectScatter",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select u1.col, u1.id from `user` as u1 where 1 != 1",
-            "Query": "select u1.col, u1.id from `user` as u1",
-            "Table": "`user`"
-          },
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectScatter",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select 1 from `user` as u3 where 1 != 1",
-            "Query": "select 1 from `user` as u3 where u3.col = :u1_col",
-            "Table": "`user`"
-          }
-        ]
-      }
-    ]
-  }
-}
 
 # wire-up join with join, going left, then right
 "select u1.id from user u1 join user u2 join user u3 where u3.col = u2.col"
@@ -236,58 +183,6 @@
     ]
   }
 }
-{
-  "QueryType": "SELECT",
-  "Original": "select u1.id from user u1 join user u2 join user u3 where u3.col = u2.col",
-  "Instructions": {
-    "OperatorType": "Join",
-    "Variant": "Join",
-    "JoinColumnIndexes": "-1",
-    "TableName": "`user`_`user`_`user`",
-    "Inputs": [
-      {
-        "OperatorType": "Route",
-        "Variant": "SelectScatter",
-        "Keyspace": {
-          "Name": "user",
-          "Sharded": true
-        },
-        "FieldQuery": "select u1.id from `user` as u1 where 1 != 1",
-        "Query": "select u1.id from `user` as u1",
-        "Table": "`user`"
-      },
-      {
-        "OperatorType": "Join",
-        "Variant": "Join",
-        "TableName": "`user`_`user`",
-        "Inputs": [
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectScatter",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select u2.col from `user` as u2 where 1 != 1",
-            "Query": "select u2.col from `user` as u2",
-            "Table": "`user`"
-          },
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectScatter",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select 1 from `user` as u3 where 1 != 1",
-            "Query": "select 1 from `user` as u3 where u3.col = :u2_col",
-            "Table": "`user`"
-          }
-        ]
-      }
-    ]
-  }
-}
 
 # wire-up join with join, reuse existing result from a lower join
 "select u1.id from user u1 join user u2 on u2.col = u1.col join user u3 where u3.col = u1.col"
@@ -344,59 +239,6 @@
     ]
   }
 }
-{
-  "QueryType": "SELECT",
-  "Original": "select u1.id from user u1 join user u2 on u2.col = u1.col join user u3 where u3.col = u1.col",
-  "Instructions": {
-    "OperatorType": "Join",
-    "Variant": "Join",
-    "JoinColumnIndexes": "1",
-    "TableName": "`user`_`user`_`user`",
-    "Inputs": [
-      {
-        "OperatorType": "Route",
-        "Variant": "SelectScatter",
-        "Keyspace": {
-          "Name": "user",
-          "Sharded": true
-        },
-        "FieldQuery": "select u3.col from `user` as u3 where 1 != 1",
-        "Query": "select u3.col from `user` as u3",
-        "Table": "`user`"
-      },
-      {
-        "OperatorType": "Join",
-        "Variant": "Join",
-        "JoinColumnIndexes": "-2",
-        "TableName": "`user`_`user`",
-        "Inputs": [
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectScatter",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select u1.col, u1.id from `user` as u1 where 1 != 1",
-            "Query": "select u1.col, u1.id from `user` as u1",
-            "Table": "`user`"
-          },
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectScatter",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select 1 from `user` as u2 where 1 != 1",
-            "Query": "select 1 from `user` as u2 where u2.col = :u1_col and :u3_col = :u1_col",
-            "Table": "`user`"
-          }
-        ]
-      }
-    ]
-  }
-}
 
 # wire-up join with join, reuse existing result from a lower join.
 # You need two levels of join nesting to test this: when u3 requests
@@ -479,82 +321,6 @@
     ]
   }
 }
-{
-  "QueryType": "SELECT",
-  "Original": "select u1.id from user u1 join user u2 join user u3 on u3.id = u1.col join user u4 where u4.col = u1.col",
-  "Instructions": {
-    "OperatorType": "Join",
-    "Variant": "Join",
-    "JoinColumnIndexes": "1",
-    "TableName": "`user`_`user`_`user`_`user`",
-    "Inputs": [
-      {
-        "OperatorType": "Route",
-        "Variant": "SelectScatter",
-        "Keyspace": {
-          "Name": "user",
-          "Sharded": true
-        },
-        "FieldQuery": "select 1 from `user` as u2 where 1 != 1",
-        "Query": "select 1 from `user` as u2",
-        "Table": "`user`"
-      },
-      {
-        "OperatorType": "Join",
-        "Variant": "Join",
-        "JoinColumnIndexes": "1",
-        "TableName": "`user`_`user`_`user`",
-        "Inputs": [
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectScatter",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select u4.col from `user` as u4 where 1 != 1",
-            "Query": "select u4.col from `user` as u4",
-            "Table": "`user`"
-          },
-          {
-            "OperatorType": "Join",
-            "Variant": "Join",
-            "JoinColumnIndexes": "-2",
-            "TableName": "`user`_`user`",
-            "Inputs": [
-              {
-                "OperatorType": "Route",
-                "Variant": "SelectScatter",
-                "Keyspace": {
-                  "Name": "user",
-                  "Sharded": true
-                },
-                "FieldQuery": "select u1.col, u1.id from `user` as u1 where 1 != 1",
-                "Query": "select u1.col, u1.id from `user` as u1",
-                "Table": "`user`"
-              },
-              {
-                "OperatorType": "Route",
-                "Variant": "SelectEqualUnique",
-                "Keyspace": {
-                  "Name": "user",
-                  "Sharded": true
-                },
-                "FieldQuery": "select 1 from `user` as u3 where 1 != 1",
-                "Query": "select 1 from `user` as u3 where u3.id = :u1_col and :u4_col = :u1_col",
-                "Table": "`user`",
-                "Values": [
-                  ":u1_col"
-                ],
-                "Vindex": "user_index"
-              }
-            ]
-          }
-        ]
-      }
-    ]
-  }
-}
 
 # Test reuse of join var already being supplied to the right of a node.
 "select u1.id from user u1 join (user u2 join user u3) where u2.id = u1.col and u3.id = u1.col"
@@ -618,67 +384,6 @@
     ]
   }
 }
-{
-  "QueryType": "SELECT",
-  "Original": "select u1.id from user u1 join (user u2 join user u3) where u2.id = u1.col and u3.id = u1.col",
-  "Instructions": {
-    "OperatorType": "Join",
-    "Variant": "Join",
-    "JoinColumnIndexes": "-2",
-    "TableName": "`user`_`user`_`user`",
-    "Inputs": [
-      {
-        "OperatorType": "Join",
-        "Variant": "Join",
-        "JoinColumnIndexes": "-1,-2",
-        "TableName": "`user`_`user`",
-        "Inputs": [
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectScatter",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select u1.col, u1.id from `user` as u1 where 1 != 1",
-            "Query": "select u1.col, u1.id from `user` as u1",
-            "Table": "`user`"
-          },
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectEqualUnique",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select 1 from `user` as u2 where 1 != 1",
-            "Query": "select 1 from `user` as u2 where u2.id = :u1_col",
-            "Table": "`user`",
-            "Values": [
-              ":u1_col"
-            ],
-            "Vindex": "user_index"
-          }
-        ]
-      },
-      {
-        "OperatorType": "Route",
-        "Variant": "SelectEqualUnique",
-        "Keyspace": {
-          "Name": "user",
-          "Sharded": true
-        },
-        "FieldQuery": "select 1 from `user` as u3 where 1 != 1",
-        "Query": "select 1 from `user` as u3 where u3.id = :u1_col",
-        "Table": "`user`",
-        "Values": [
-          ":u1_col"
-        ],
-        "Vindex": "user_index"
-      }
-    ]
-  }
-}
 
 # Join on weird columns.
 "select `weird``name`.a, unsharded.b from `weird``name` join unsharded on `weird``name`.`a``b*c` = unsharded.id"
@@ -716,44 +421,6 @@
     ]
   }
 }
-{
-  "QueryType": "SELECT",
-  "Original": "select `weird``name`.a, unsharded.b from `weird``name` join unsharded on `weird``name`.`a``b*c` = unsharded.id",
-  "Instructions": {
-    "OperatorType": "Join",
-    "Variant": "Join",
-    "JoinColumnIndexes": "1,-2",
-    "TableName": "unsharded_`weird``name`",
-    "Inputs": [
-      {
-        "OperatorType": "Route",
-        "Variant": "SelectUnsharded",
-        "Keyspace": {
-          "Name": "main",
-          "Sharded": false
-        },
-        "FieldQuery": "select unsharded.id, unsharded.b from unsharded where 1 != 1",
-        "Query": "select unsharded.id, unsharded.b from unsharded",
-        "Table": "unsharded"
-      },
-      {
-        "OperatorType": "Route",
-        "Variant": "SelectEqualUnique",
-        "Keyspace": {
-          "Name": "user",
-          "Sharded": true
-        },
-        "FieldQuery": "select `weird``name`.a from `weird``name` where 1 != 1",
-        "Query": "select `weird``name`.a from `weird``name` where `weird``name`.`a``b*c` = :unsharded_id",
-        "Table": "`weird``name`",
-        "Values": [
-          ":unsharded_id"
-        ],
-        "Vindex": "user_index"
-      }
-    ]
-  }
-}
 
 # Join on weird column (col is not in select)
 "select unsharded.b from `weird``name` join unsharded on `weird``name`.`a``b*c` = unsharded.id"
@@ -791,44 +458,6 @@
     ]
   }
 }
-{
-  "QueryType": "SELECT",
-  "Original": "select unsharded.b from `weird``name` join unsharded on `weird``name`.`a``b*c` = unsharded.id",
-  "Instructions": {
-    "OperatorType": "Join",
-    "Variant": "Join",
-    "JoinColumnIndexes": "-2",
-    "TableName": "unsharded_`weird``name`",
-    "Inputs": [
-      {
-        "OperatorType": "Route",
-        "Variant": "SelectUnsharded",
-        "Keyspace": {
-          "Name": "main",
-          "Sharded": false
-        },
-        "FieldQuery": "select unsharded.id, unsharded.b from unsharded where 1 != 1",
-        "Query": "select unsharded.id, unsharded.b from unsharded",
-        "Table": "unsharded"
-      },
-      {
-        "OperatorType": "Route",
-        "Variant": "SelectEqualUnique",
-        "Keyspace": {
-          "Name": "user",
-          "Sharded": true
-        },
-        "FieldQuery": "select 1 from `weird``name` where 1 != 1",
-        "Query": "select 1 from `weird``name` where `weird``name`.`a``b*c` = :unsharded_id",
-        "Table": "`weird``name`",
-        "Values": [
-          ":unsharded_id"
-        ],
-        "Vindex": "user_index"
-      }
-    ]
-  }
-}
 
 # wire-up with limit primitive
 "select u.id, e.id from user u join user_extra e where e.id = u.col limit 10"
@@ -872,46 +501,6 @@
     ]
   }
 }
-{
-  "QueryType": "SELECT",
-  "Original": "select u.id, e.id from user u join user_extra e where e.id = u.col limit 10",
-  "Instructions": {
-    "OperatorType": "Limit",
-    "Count": 10,
-    "Inputs": [
-      {
-        "OperatorType": "Join",
-        "Variant": "Join",
-        "JoinColumnIndexes": "-2,1",
-        "TableName": "`user`_user_extra",
-        "Inputs": [
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectScatter",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select u.col, u.id from `user` as u where 1 != 1",
-            "Query": "select u.col, u.id from `user` as u limit :__upper_limit",
-            "Table": "`user`"
-          },
-          {
-            "OperatorType": "Route",
-            "Variant": "SelectScatter",
-            "Keyspace": {
-              "Name": "user",
-              "Sharded": true
-            },
-            "FieldQuery": "select e.id from user_extra as e where 1 != 1",
-            "Query": "select e.id from user_extra as e where e.id = :u_col limit :__upper_limit",
-            "Table": "user_extra"
-          }
-        ]
-      }
-    ]
-  }
-}
 
 # Wire-up in subquery
 "select 1 from user where id in (select u.id, e.id from user u join user_extra e where e.id = u.col limit 10)"
diff --git a/go/vt/vtgate/semantics/analyzer_test.go b/go/vt/vtgate/semantics/analyzer_test.go
index afc2d74d99..418f9e273e 100644
--- a/go/vt/vtgate/semantics/analyzer_test.go
+++ b/go/vt/vtgate/semantics/analyzer_test.go
@@ -213,9 +213,6 @@ func TestBindingMultiTable(t *testing.T) {
 		}, {
 			query: "select b.t.col from b.t, t",
 			deps:  T0,
-		}, {
-			query: "select u1.a + u2.a from u1, u2",
-			deps:  T0 | T1,
 		}}
 		for _, query := range queries {
 			t.Run(query.query, func(t *testing.T) {
@@ -231,7 +228,6 @@ func TestBindingMultiTable(t *testing.T) {
 			"select 1 from d.tabl, d.foo as tabl",
 			"select 1 from d.tabl, d.tabl",
 			"select 1 from d.tabl, tabl",
-			"select 1 from user join user_extra user",
 		}
 		for _, query := range queries {
 			t.Run(query, func(t *testing.T) {
@@ -290,7 +286,7 @@ func TestMissingTable(t *testing.T) {
 			parse, _ := sqlparser.Parse(query)
 			_, err := Analyze(parse, "", &FakeSI{})
 			require.Error(t, err)
-			require.Contains(t, err.Error(), "symbol t.col not found")
+			require.Contains(t, err.Error(), "Unknown table")
 		})
 	}
 }
@@ -377,34 +373,6 @@ func TestUnknownColumnMap2(t *testing.T) {
 	}
 }
 
-func TestScoping(t *testing.T) {
-	queries := []struct {
-		query        string
-		errorMessage string
-	}{
-		{
-			query:        "select 1 from u1, u2 left join u3 on u1.a = u2.a",
-			errorMessage: "symbol u1.a not found",
-		},
-	}
-	for _, query := range queries {
-		t.Run(query.query, func(t *testing.T) {
-			parse, err := sqlparser.Parse(query.query)
-			require.NoError(t, err)
-			_, err = Analyze(parse, "user", &FakeSI{
-				Tables: map[string]*vindexes.Table{
-					"t": {Name: sqlparser.NewTableIdent("t")},
-				},
-			})
-			if query.errorMessage == "" {
-				require.NoError(t, err)
-			} else {
-				require.EqualError(t, err, query.errorMessage)
-			}
-		})
-	}
-}
-
 func parseAndAnalyze(t *testing.T, query, dbName string) (sqlparser.Statement, *SemTable) {
 	t.Helper()
 	parse, err := sqlparser.Parse(query)
diff --git a/go/vt/vttablet/tabletmanager/shard_sync_test.go b/go/vt/vttablet/tabletmanager/shard_sync_test.go
deleted file mode 100644
index a988a2612d..0000000000
--- a/go/vt/vttablet/tabletmanager/shard_sync_test.go
+++ /dev/null
@@ -1,133 +0,0 @@
-/*
-Copyright 2021 The Vitess Authors.
-
-Licensed under the Apache License, Version 2.0 (the "License");
-you may not use this file except in compliance with the License.
-You may obtain a copy of the License at
-
-    http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing, software
-distributed under the License is distributed on an "AS IS" BASIS,
-WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-See the License for the specific language governing permissions and
-limitations under the License.
-*/
-
-package tabletmanager
-
-import (
-	"context"
-	"fmt"
-	"reflect"
-	"testing"
-	"time"
-
-	"vitess.io/vitess/go/protoutil"
-	"vitess.io/vitess/go/vt/proto/vttime"
-
-	"github.com/stretchr/testify/assert"
-
-	"vitess.io/vitess/go/vt/proto/topodata"
-	"vitess.io/vitess/go/vt/topo"
-
-	"github.com/stretchr/testify/require"
-
-	"vitess.io/vitess/go/vt/topo/topoproto"
-
-	"vitess.io/vitess/go/vt/topo/memorytopo"
-)
-
-const (
-	keyspace = "ks"
-	shard    = "0"
-)
-
-func TestShardSync(t *testing.T) {
-	ctx := context.Background()
-	ts := memorytopo.NewServer("cell1")
-	statsTabletTypeCount.ResetAll()
-	tm := newTestTM(t, ts, 100, keyspace, shard)
-	defer tm.Stop()
-
-	// update the master info in the shard record and set it to nil
-	originalTime := time.Now()
-	updateMasterInfoInShardRecord(ctx, t, tm, nil, originalTime)
-
-	// now try to promote the tablet to primary
-	err := tm.tmState.ChangeTabletType(ctx, topodata.TabletType_MASTER, DBActionSetReadWrite)
-	require.NoError(t, err)
-	// verify that the tablet record has been updated
-	ti, err := ts.GetTablet(ctx, tm.tabletAlias)
-	require.NoError(t, err)
-	assert.Equal(t, topodata.TabletType_MASTER, ti.Type)
-	assert.NotNil(t, ti.MasterTermStartTime)
-
-	// wait for syncing to work correctly
-	// this should also have updated the shard record since it is a more recent operation
-	// We check here that the shard record and the tablet record are in sync
-	checkShardRecordWithTimeout(ctx, t, ts, ti.Alias, ti.MasterTermStartTime, 1*time.Second)
-
-	// even if try to update the shard record with the old timestamp, it should be reverted again
-	updateMasterInfoInShardRecord(ctx, t, tm, nil, originalTime)
-
-	// this should have also updated the shard record because of the timestamp.
-	checkShardRecordWithTimeout(ctx, t, ts, ti.Alias, ti.MasterTermStartTime, 1*time.Second)
-
-	// updating the shard record with the latest time should trigger an update in the tablet
-	newTime := time.Now()
-	updateMasterInfoInShardRecord(ctx, t, tm, nil, newTime)
-
-	// this should not have updated.
-	checkShardRecordWithTimeout(ctx, t, ts, nil, protoutil.TimeToProto(newTime), 1*time.Second)
-
-	// verify that the tablet record has been updated
-	checkTabletRecordWithTimeout(ctx, t, ts, tm.tabletAlias, topodata.TabletType_REPLICA, nil, 1*time.Second)
-}
-
-func checkShardRecordWithTimeout(ctx context.Context, t *testing.T, ts *topo.Server, tabletAlias *topodata.TabletAlias, masterStartTime *vttime.Time, timeToWait time.Duration) {
-	timeOut := time.After(timeToWait)
-	for {
-		select {
-		case <-timeOut:
-			t.Fatalf("timed out: waiting for shard record to update")
-		default:
-			si, err := ts.GetShard(ctx, keyspace, shard)
-			require.NoError(t, err)
-			if reflect.DeepEqual(tabletAlias, si.MasterAlias) && reflect.DeepEqual(masterStartTime, si.MasterTermStartTime) {
-				return
-			}
-			time.Sleep(100 * time.Millisecond)
-		}
-	}
-}
-
-func checkTabletRecordWithTimeout(ctx context.Context, t *testing.T, ts *topo.Server, tabletAlias *topodata.TabletAlias, tabletType topodata.TabletType, masterStartTime *vttime.Time, timeToWait time.Duration) {
-	timeOut := time.After(timeToWait)
-	for {
-		select {
-		case <-timeOut:
-			t.Fatalf("timed out: waiting for tablet record to update")
-		default:
-			ti, err := ts.GetTablet(ctx, tabletAlias)
-			require.NoError(t, err)
-			if reflect.DeepEqual(tabletType, ti.Type) && reflect.DeepEqual(masterStartTime, ti.MasterTermStartTime) {
-				return
-			}
-			time.Sleep(100 * time.Millisecond)
-		}
-	}
-}
-
-func updateMasterInfoInShardRecord(ctx context.Context, t *testing.T, tm *TabletManager, masterAlias *topodata.TabletAlias, time time.Time) {
-	ctx, unlock, lockErr := tm.TopoServer.LockShard(ctx, keyspace, shard, fmt.Sprintf("updateMasterInfoInShardRecord(%v)", topoproto.TabletAliasString(tm.tabletAlias)))
-	require.NoError(t, lockErr)
-	defer unlock(&lockErr)
-
-	_, err := tm.TopoServer.UpdateShardFields(ctx, keyspace, shard, func(si *topo.ShardInfo) error {
-		si.MasterAlias = masterAlias
-		si.SetMasterTermStartTime(time)
-		return nil
-	})
-	require.NoError(t, err)
-}
diff --git a/go/vt/vttablet/tabletmanager/tm_init_test.go b/go/vt/vttablet/tabletmanager/tm_init_test.go
index b9834a30b8..6ed6cf99fe 100644
--- a/go/vt/vttablet/tabletmanager/tm_init_test.go
+++ b/go/vt/vttablet/tabletmanager/tm_init_test.go
@@ -125,7 +125,6 @@ func TestStartCreateKeyspaceShard(t *testing.T) {
 	rebuildKeyspaceRetryInterval = 10 * time.Millisecond
 
 	ctx := context.Background()
-	statsTabletTypeCount.ResetAll()
 	cell := "cell1"
 	ts := memorytopo.NewServer(cell)
 	tm := newTestTM(t, ts, 1, "ks", "0")
diff --git a/go/vt/vttablet/tabletmanager/vreplication/vplayer_flaky_test.go b/go/vt/vttablet/tabletmanager/vreplication/vplayer_flaky_test.go
index a6959c8222..8a49f8e44b 100644
--- a/go/vt/vttablet/tabletmanager/vreplication/vplayer_flaky_test.go
+++ b/go/vt/vttablet/tabletmanager/vreplication/vplayer_flaky_test.go
@@ -2737,7 +2737,6 @@ func expectJSON(t *testing.T, table string, values [][]string, id int, exec func
 		want, err := ajson.Unmarshal([]byte(row[1]))
 		require.NoError(t, err)
 		match, err := got.Eq(want)
-		//log.Infof(">>>>>>>> got \n-----\n%s\n------\n, want \n-----\n%s\n------\n", got, want)
 		require.NoError(t, err)
 		require.True(t, match)
 	}