Method isValidWithOrSubQuery

query/sql/sql_parser.go:1736–1780

(s2aCtx *SQL2AqlContext)

}

func (v *ASTBuilder) isValidWithOrSubQuery(s2aCtx *SQL2AqlContext) (bool, error) {
	var isTrue, exist bool
	var err error
	var mapKey int

	// check if from clause in main query(ie. qLevel = 0) mix table with subquery/withQuery
	if isTrue, err = v.isQueryFromMixed(s2aCtx); isTrue {
		return false, err
	}

	// check if all subquery/withQuery from clauses are same
	for i, value := range s2aCtx.MapJoinTables[0] {
		// exit if no subquery/withQuery
		if len(value.Table) > 0 {
			break
		}

		if len(value.Alias) == 0 { // subquery has no identifier
			mapKey = v.generateKey(1, typeSubQuery, i)
		} else {
			mapKey, exist = s2aCtx.queryIdentifierSet[value.Alias]
			if !exist {
				err = fmt.Errorf("cannot find withQuery identifier: %s", value.Alias)
				return false, err
			}
		}

		isTrue, err = v.isSameFromTables(s2aCtx, mapKey)
		if !isTrue {
			return false, err
		}

		isTrue, err = v.isSameGroupBy(s2aCtx, mapKey)
		if !isTrue {
			return false, err
		}

		isTrue, err = v.isSameOrderBy(s2aCtx, mapKey)
		if !isTrue {
			return false, err
		}
	}

	return true, nil
}

// AQL requires that the first level query is either from tables or from subqueries/withQuery
func (v *ASTBuilder) isQueryFromMixed(s2aCtx *SQL2AqlContext) (bool, error) {