Function TestLexSqlSubQuery

lex/lexer_test.go:668–683

(t *testing.T)

}

func TestLexSqlSubQuery(t *testing.T) {

	verifyTokenTypes(t, `select
	         user_id, email
	     FROM users
	     WHERE user_id in
	     	(select user_id from orders where qty > 5)`,
		[]TokenType{TokenSelect,
			TokenIdentity, TokenComma, TokenIdentity,
			TokenFrom, TokenIdentity, TokenWhere, TokenIdentity,
			TokenIN, TokenLeftParenthesis, TokenSelect, TokenIdentity,
			TokenFrom, TokenIdentity, TokenWhere, TokenIdentity,
			TokenGT, TokenInteger,
			TokenRightParenthesis,
		})
}

func TestLexSqlPreparedStmt(t *testing.T) {
	verifyTokens(t, `