SQL-Statement

Changes for version 1.407 - 2015-05-26

Release 1.406_002 without further changes as 1.407

Changes for version 1.406_002 - 2015-05-22

Bug fixes
- Fix RT#104579: Redundant argument in sprintf submitted by Slaven Rezić
- Fix RT#104589: t/14parse.t fails if Test::Deep is not installed submitted by Slaven Rezić

Changes for version 1.406_001 - 2015-05-20

Misc
- clean up Makefile.PL, meta-data and requirements
Bug fixes
- Fix SQL function CONV to use limited number of sane character sets for conversion and rely on Math::Base::Convert instead of own code (suggested by Tom Wyant in RT#100551, thanks Tom)
- fix handling of literal identifiers and for every IMPORT rely on literal identifiers to avoid parser errors for column names starting with numbers or similar
- fix capability cache: "$class->can(...)" might return undef and therefore inexistent capabilities are queried to often
- Fix COUNT(DISTINCT col) without GROUP BY clause (patch submitted by Grant Mathews, thanks Grant)
- Fix "parse insert with functions" submitted via GitHub PR#6 by fecundf and RT#96628
- Fix RT#93320: SQL-style comment can not begin inside quotes by Tom Wyant - thanks Tom
Improvements
- reduce blocks and rewrite some inner statements to increase speed of sql command processing

Documentation

SQL::Statement::Embed

embed a SQL engine in a DBD or module

SQL::Statement::Roadmap

Planned Enhancements for SQL::Statement and SQL::Parser

SQL::Statement::Structure

parse and examine structure of SQL queries

SQL::Statement::Syntax

documentation of SQL::Statement's SQL Syntax

Modules

SQL::Dialects::ANSI

SQL::Dialects::AnyData

SQL::Dialects::CSV

SQL::Dialects::Role

The role of being a SQL::Dialect

SQL::Eval

Base for deriving evaluation objects for SQL::Statement

SQL::Parser

validate and parse SQL strings

SQL::Statement

SQL parsing and processing engine

SQL::Statement::Function

abstract base class for all function executing terms

SQL::Statement::Functions

built-in & user-defined SQL functions

SQL::Statement::GetInfo

SQL::Statement::Operation

base class for all operation terms

SQL::Statement::Placeholder

implements getting the next placeholder value

SQL::Statement::RAM

SQL::Statement::Term

base class for all terms

SQL::Statement::TermFactory

Factory for SQL::Statement::Term instances

SQL::Statement::Util

Provides

SQL::Eval::Table

in lib/SQL/Eval.pm

SQL::Statement::Aggregate

in lib/SQL/Statement.pm

SQL::Statement::ColumnValue

in lib/SQL/Statement/Term.pm

SQL::Statement::ConstantTerm

in lib/SQL/Statement/Term.pm

SQL::Statement::Function::NumericEval

in lib/SQL/Statement/Function.pm

SQL::Statement::Function::StrConcat

in lib/SQL/Statement/Function.pm

SQL::Statement::Function::SubString

in lib/SQL/Statement/Function.pm

SQL::Statement::Function::Trim

in lib/SQL/Statement/Function.pm

SQL::Statement::Function::UserFunc

in lib/SQL/Statement/Function.pm

SQL::Statement::Group

in lib/SQL/Statement.pm

SQL::Statement::Limit

in lib/SQL/Statement.pm

SQL::Statement::Operation::ANSI::Is