use crate::util::*;
testcase!(test);
fn test(mut glue: multisql::Glue) {
	assert_select!(
		glue,
		r#"
				VALUES (
					'Test',
					1
				), (
					'Test2',
					2
				)
				UNION
				VALUES (
					'Test3',
					3
				)
			"# =>
			unnamed_0 = Str, unnamed_1 = I64:
			("Test", 1), ("Test2", 2), ("Test3", 3)
	);
	assert_select!(
		glue,
		r#"
				VALUES (
					'Test',
					1
				), (
					'Test2',
					2
				), (
					'Test3',
					3
				)
				UNION
				VALUES (
					'Test3',
					3
				)
			"# =>
		unnamed_0 = Str, unnamed_1= I64:
		("Test", 1), ("Test2", 2), ("Test3", 3)
	);
	assert_select!(
		glue,
		r#"
				VALUES (
					'Test',
					1
				), (
					'Test2',
					2
				), (
					'Test3',
					3
				)
				UNION ALL
				VALUES (
					'Test3',
					3
				)
			"# =>
		unnamed_0 = Str, unnamed_1 = I64:
		("Test", 1), ("Test2", 2), ("Test3", 3), ("Test3", 3)
	);
}