Debian Codegraph @

mysql-test/suite/sysschema/t/fn_format_statement.test

raw
1 -- source include/not_embedded.inc
2 # Tests for sys schema
3 # Verify the sys.format_statement() function perfoms as expected
4
5 # Passing NULL should return NULL
6 SELECT sys.format_statement(NULL);
7
8 # Ensure long statements are truncated correctly
9 SELECT sys.format_statement('SELECT foo, bar, baz, foobar, foobaz FROM foo JOIN bar USING (foobar) JOIN baz USING (foobar) WHERE foo = \'foo\' AND bar = \'bar\'') AS statement;
10
11 # Increase truncation limit and test that it takes effect
12 SET @sys.statement_truncate_len = 80;
13 SELECT sys.format_statement('SELECT foo, bar, baz, foobar, foobaz FROM foo JOIN bar USING (foobar) JOIN baz USING (foobar) WHERE foo = \'foo\' AND bar = \'bar\'') AS statement;