SQLPage/tests/sql_test_files/data/run_sql_variable_isolation.sql at da7cf0d6f7a4aeaea2ecf37b9f13f38190c8d04b · sqlpage/SQLPage · GitHub

1
2
3
4
5
6
7
8
set scope = 'parent';
set child_rows = sqlpage.run_sql('tests/sql_test_files/variable_scope_child.sql');
select '"inherited":"parent"' as expected_contains, $child_rows as actual;
select '"changed":"child"' as expected_contains, $child_rows as actual;
select 'parent' as expected, $scope as actual;
set child_rows = sqlpage.run_sql('tests/sql_test_files/variable_scope_child.sql', '{"scope":null}');
select '"inherited":null' as expected_contains, $child_rows as actual;
select 'parent' as expected, $scope as actual;