mariadb-cli 0.1.1

One-shot agent-native command line client for MariaDB servers
Documentation
# Prose of the failures analysis raises before a statement is ever sent.
#
# The naming rule and the { $detail } rule are the ones stated in
# errors-usage.en.ftl.

err-sql-too-large = the statement went past the size ceiling ({ $detail })
hint-sql-too-large = split the statement or raise the statement size ceiling

err-sql-parser-unavailable = the parser could not be started

err-sql-too-deep = the statement is nested too deeply to be read
hint-sql-too-deep = flatten the statement or raise the parser stack ceiling

err-sql-unparsable = the statement could not be read
hint-sql-unparsable = check the statement against the server manual

err-sql-empty = the statement is empty
hint-sql-empty = send one statement

err-sql-unclassified = the statement has a shape this tool does not recognise
hint-sql-unclassified = a statement that cannot be classified is refused rather than assumed to be a read

err-sql-multiple-statements = the text carries more than one statement
hint-sql-multiple-statements = send one statement per call

err-sql-server-file-read = the statement makes the server read a file of its own ({ $detail })
hint-sql-server-file-read = read the file where it lives instead of through the server

err-sql-server-file-write = the statement writes a file on the server ({ $detail })
hint-sql-server-file-write = take the result on the primary channel and write it yourself

err-sql-client-file-read = the statement asks the server to read a file from this machine
hint-sql-client-file-read = load the file with `data import`, which reads it here and never asks the server to

err-sql-unterminated-region = the statement ends inside a region that was never closed ({ $detail })
hint-sql-unterminated-region = close the quote or the comment before sending the statement

err-sql-not-a-read = this command only reads, and the statement is not a read ({ $detail })
hint-sql-not-a-read = use `query run` for a statement that changes the server

err-sql-already-a-plan = the statement already asks for a plan or a measurement
hint-sql-already-a-plan = pass the statement itself, without a leading plan or measurement word

err-sql-not-plannable = the server plans statements that read or change rows, and this is not one of them ({ $detail })
hint-sql-not-plannable = ask for the plan of a statement that reads or changes rows

err-rewrite-zero-limit = the row ceiling is zero
hint-rewrite-zero-limit = ask for at least one row

err-rewrite-not-a-single-query = a row ceiling can only be imposed on a single query
hint-rewrite-not-a-single-query = send one statement that returns rows

err-rewrite-tail-clause-present = the query ends in a clause that prevents appending the row ceiling ({ $detail })
hint-rewrite-tail-clause-present = remove that clause, or ask for the rows without a ceiling

err-rewrite-limit-already-present = the query already carries a row clause of its own
hint-rewrite-limit-already-present = remove the row clause from the query, or ask for a ceiling no smaller than it

err-ident-empty-path = the object name has no parts
hint-ident-empty-path = give at least one name part

err-ident-empty = the object name is empty
hint-ident-empty = give a name with at least one character

err-ident-control-character = the object name carries a control character ({ $detail })
hint-ident-control-character = remove the control character from the name

err-ident-too-long = the object name is longer than this server accepts ({ $detail })
hint-ident-too-long = shorten the name

err-script-delimiter-not-restored = the separator was redefined and never restored ({ $detail })
hint-script-delimiter-not-restored = add a line restoring the separator before the file ends

err-safety-read-only = this invocation refuses every change, and the statement is one ({ $detail })
hint-safety-read-only = drop --read-only, or set sql.read_only to false

err-safety-cannot-simulate = `{ $detail }` has no simulation, because running it is the only way to learn what it does
hint-safety-cannot-simulate = drop --dry-run; for a statement, `query explain` reads the plan without running it
err-safety-unconfirmed = the statement changes the server and was not confirmed ({ $detail })
hint-safety-unconfirmed = add --yes to confirm, or --dry-run to see the effect first

err-safety-server-read-only = the destination is a read-only server and accepts no change
hint-safety-server-read-only = point at a destination that accepts writes

err-safety-no-restriction = this change would reach every row of the table ({ $detail })
hint-safety-no-restriction = add a restriction, or set sql.require_where to false to allow the whole table

err-safety-no-unique-key = the table has no primary or unique key, so this change cannot be repeated safely ({ $detail })
hint-safety-no-unique-key = set sql.require_unique_key to false to proceed with a warning instead

err-safety-policy-covers-discovery = this destination refuses every operation, and this reading is one ({ $detail })
hint-safety-policy-covers-discovery = set sql.policy_scope to change to keep discovery open, or drop the refusal of change altogether

err-query-name-missing = this action needs the name of a kept statement
hint-query-name-missing = give one as the first word, as in `query named run pedidos`; `query named list` shows the kept names

err-query-statement-missing = keeping a statement under a name needs the statement itself
hint-query-statement-missing = give it as the second word, as in `query named save pedidos 'SELECT * FROM pedidos'`

err-query-path-missing = running a file of statements needs the file to run
hint-query-path-missing = name one as the first word, as in `query file carga.sql`

err-query-routine-missing = calling a routine needs the routine to call
hint-query-routine-missing = name one as the first word, as in `query call recalcular_saldo`

err-query-table-missing = sampling needs a table to read from
hint-query-table-missing = name one with --table, as in `query sample --table clientes`

err-query-connection-missing = asking for a running plan needs the connection running it
hint-query-connection-missing = name one with --connection, as in `query plan --connection 42`; `server processes` lists them

err-lineage-not-a-single-query = origins can only be resolved for a single statement that returns rows
hint-lineage-not-a-single-query = send one statement that returns rows

err-lineage-compound-query = the query combines several selections, so a column has no single origin
hint-lineage-compound-query = resolve each selection of the combination on its own

err-lineage-not-a-stored-table = the query reads from something that is not a stored table
hint-lineage-not-a-stored-table = resolve the origins of the inner query on its own

err-lineage-wildcard = the query asks for every column, and which those are is not written in it
hint-lineage-wildcard = name the columns the result should carry

err-lineage-unrecognised-item = the item has a shape whose origin this tool does not resolve ({ $detail })
hint-lineage-unrecognised-item = name the columns the result should carry, one by one

err-lineage-unknown-qualifier = the qualifier is not a table this query reads from ({ $detail })
hint-lineage-unknown-qualifier = check the name the column is qualified with

err-lineage-no-table = the column is read from no table this query names ({ $detail })
hint-lineage-no-table = name the table the column comes from

err-lineage-ambiguous-column = the column is unqualified and the query reads from more than one table ({ $detail })
hint-lineage-ambiguous-column = qualify the column with the table it comes from

err-sql-unknown-out-parameter = the routine declares no output parameter under that name ({ $detail })
hint-sql-unknown-out-parameter = read the signature with `schema routines` and mark a parameter the routine declares as OUT or INOUT