qa

restore_window_func

1.在tidb/planner/core/planbuilder.go 文件
  func (b *PlanBuilder) Build(ctx context.Context, node ast.Node) (Plan, error) 函数中加入日志
    case *ast.SelectStmt:
      p,err:= b.buildSelect(ctx, x)
      var sb2 strings.Builder
      node.Restore(format.NewRestoreCtx(format.DefaultRestoreFlags, &sb2))
      logutil.Logger(context.Background()).Info("restore", zap.String("stmt",sb2.String()))
      return p,err
    
2.编译运行tidb，连接数据库，执行
use test;
create table t(a int);
SELECT ROW_NUMBER() OVER `w` FROM `test`.`t` WINDOW `w` AS (ORDER BY `a`);
3.观察tidb的日志，如果输出的restore和原始select一样，则通过
复现的是 SELECT ROW_NUMBER() OVER `w` AS (ORDER BY `a`) FROM `test`.`t` WINDOW `w` AS (ORDER BY `a`)