The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
SQL-SplitStatement-1.00000
River stage two • 6 direct dependents • 31 total dependents
1 ++

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-split
SQL splitting command line utility

Modules

SQL::SplitStatement
Split any SQL code into atomic statements

Other files