summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sysschema/r/fn_format_statement.result
blob: b07e4b0249ee185fb41586a6507bd5f09caea70f (plain)
1
2
3
4
5
6
7
8
9
10
SELECT sys.format_statement(NULL);
sys.format_statement(NULL)
NULL
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;
statement
SELECT foo, bar, baz, foobar,  ... RE foo = 'foo' AND bar = 'bar'
SET @sys.statement_truncate_len = 80;
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;
statement
SELECT foo, bar, baz, foobar, foobaz F ... bar) WHERE foo = 'foo' AND bar = 'bar'