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)
);
}