{"id":1527,"date":"2012-07-18T22:07:43","date_gmt":"2012-07-19T03:07:43","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1527"},"modified":"2012-07-18T22:07:43","modified_gmt":"2012-07-19T03:07:43","slug":"new-release-sql-pretty-printer-version-3-3-2","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2012\/07\/new-release-sql-pretty-printer-version-3-3-2\/","title":{"rendered":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2"},"content":{"rendered":"

SQL Pretty Printer V3.3.2 desktop version is available on July 19, 2012.<\/p>\n

You can download the latest version here:
\nDesktop version: http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_3_3_2.zip<\/a><\/p>\n

We have added one new format option gFmtOpt.TrueLeft, left align all keywords including AND\/OR and ON keyword in join clause. Here is the sql formatted when gFmtOpt.TrueLeft set to true.<\/p>\n

\n<\/p>\n

In order to make this format option works correctly, following options must be set correspondingly.<\/p>\n

\n<\/p>\n

\n

\n<\/p>\n

Some other improvements in this release:<\/p>\n

\n
- [plsql] support label before function call statement<\/li>\n
- [plsql] support create package body with empty statements inside.<\/li>\n
- [MySQL] select statement in group_concat function was parsed<\/li>\n
- [MySQL] able to format create view statement of MySQL<\/li>\n
- [MySQL] add support for [DEFINER = { user | CURRENT_USER }] and [SQL SECURITY { DEFINER | INVOKER }] in create view statement.<\/li>\n
- [MySQL] support multi-list of characteristic such as READS SQL DATA in create procedure statement<\/li>\n
- [MySQL] add support for [DEFINER = { user | CURRENT_USER }] in create procedure statement<\/li>\n
- [MySQL] support into clause like: SELECT COUNT(*) FROM tmpT INTO variablename;<\/li>\n
- [DB2] fix a bug can’t process if statement correctly inside block.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

  SQL Pretty Printer V3.3.2 desktop version is available on July 19, 2012. You can download the latest version here: Desktop version: http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_3_3_2.zip We have added one new format option gFmtOpt.TrueLeft, left align all keywords including AND\/OR and ON keyword in join clause. Here is the sql formatted when gFmtOpt.TrueLeft set to true. In order to make this format option works correctly, following options must be set correspondingly. Some other improvements in this release: [plsql] support label before function call statement [plsql] support create package body with empty statements inside. [MySQL] select statement in group_concat function was parsed [MySQL] able to\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[13,24],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nNEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n