Function TestSqlParser

lex/dialect_sql_parse_test.go:34–73

(t *testing.T)

}

func TestSqlParser(t *testing.T) {

	parseSqlTest(t, `## this is a comment
		SELECT a FROM x;`)

	parseSqlError(t, `SELECT a FROM x LIMIT 1 NOTAWORD;`)

	parseSqlError(t, `SELECT a, tolower(b) AS b INTO newtable FROM FROM WHERE a != "hello";`)
	parseSqlTest(t, `
		SELECT a.language, a.template, Count(*) AS count
		FROM 
			(Select Distinct language, template FROM content WHERE language != "en" OFFSET 1) AS a
			Left Join users AS b
				On b.language = a.language AND b.template = b.template
		GROUP BY a.language, a.template`)
	parseSqlTest(t, `
			SELECT a FROM x WHERE a IN (select ax FROM z);
		`)

	// CREATE
	parseSqlTest(t, `CREATE CONTINUOUSVIEW viewx AS SELECT a FROM tbl;`)
	parseSqlError(t, `CREATE FAKEITEM viewx;`)
	parseSqlTest(t, `CREATE OR REPLACE VIEW viewx 
		AS SELECT a, b FROM mydb.tbl 
		WITH stuff = "hello";`)
	parseSqlTest(t, `CREATE TABLE articles 
			--comment-here
			(
			 ID int(11) NOT NULL AUTO_INCREMENT,
			 Email char(150) NOT NULL DEFAULT '' UNIQUE COMMENT 'this-is-comment',
			 stuff varchar(150),
			 profile text,
			 PRIMARY KEY (ID),
			 visitct BIGINT,
			 CONSTRAINT emails_fk FOREIGN KEY (Email) REFERENCES Emails (Email)
		   ) ENGINE=InnoDB AUTO_INCREMENT=4080 DEFAULT CHARSET=utf8;`)

	// DROP
	parseSqlTest(t, `DROP CONTINUOUSVIEW viewx WITH stuff = "hello";`)
}