Changes for version 1.00000 - 2011-02-09
- PL/SQL PACKAGE limitation removed: now a PACKAGE with an initialization block is correctly recognized even if it lacks both the package name and the slash terminator.
- PL/SQL parser fully rewritten again.
- Added terminator: semicolon followed by a period on its own line followed by a forward slash on its own line.
- Extended dollar-quoted strings handling, that is, strings like "$TAG$", are now handled correctly (whereas before only "$$" was permitted as a dollar-quote).
- Two new types of placeholders added: /dollar sign numbers/ ($1, $2, ..., $n) and /named parameters/ (:foo, :bar).
- PL/SQL "DECLARE CURSOR" handling;
- Fixed missing PL/SQL "END CASE" check;
- Fixed a bug with DELIMITER-defined terminators when their scope persisted over multiple statements.
- Fixed a bug which caused certain DELIMITER-defined terminators not to be removed in the returned statements (when "keep_terminators" was set to false).
- Many further improvements and fixes.
- Added the new "slash_terminates" option (NOT a change in the default behavior, but please read the docs).
- Massive test additions (the two popular Sakila and Pagila sample db now included).
- Docs updates.
- Markdown README added (via Dist::Zilla::Plugin::ReadmeMarkdownFromPod).
Documentation
SQL splitting command line utility
Modules
Split any SQL code into atomic statements