MariaDB Jupyter Kernel Restrictions and Limitations
Restrictions and Limitations
Here's a list of the current restrictions and limitations of the MariaDB Jupyter kernel. Trying to stretch what we listed here is at your own risk, the results and the behavior of the kernel might be at the mercy of the universe :-)
- One cell should only contain a single SQL statement. It can be multi-line, a one liner, it doesn't matter, but it needs to only be a single statement.
- A notebook cell can only contain one line magic command (line magics start with
%). Everything else within the same cell below the line magic command will be ignored.
- Magic commands and SQL statements cannot be mixed within the same notebook cell.
- The kernel does not officially support the DELIMITER (MariaDB specific) client command. It might work, but it shouldn't be used. Rather use the
%%delimitercell magic command (see
%lsmagicfor usage information).
- Each SQL statement within a notebook cell should end with the
;MariaDB default delimiter, except in cells using the
%%delimitercell magic command where it should end with the user-specified delimiter.