A compilation of today's news of interest:

Talent6, a San Francisco based entertainment company has been selected as a winner in the WebAward Competition for Entertainment Standard of Excellence and Online Community Standard of Excellence. The Web Marketing Association is the producer of the WebAward Competition. Now in its 12th year, the WebAwards is the premier annual website award competition that names the best Web sites in 96 industries while setting the standard of excellence for all website development. The goal for our new web site is to provide our talents with maximum exposure to casting directors searching for new talent and thousands of casting call opportunities nationwide. We hit our goals perfectly with the new site and this award from WebAwards, confirms it America’s Next Top Model

Talent6 Entertainment Standard of Excellence Award is in good company with fellow award winners, such as, Disney, USA Networks, American Idol Live, 50th Annual Grammy Awards and Rogers & Hammerstein Organization.

Talent6 provides casting calls nationwide for just about everyone and anyone wanting to get their start in the entertainment industry working as an extra in Movies, TV Shows, Modeling and Music Videos. Talent6 works with some of the biggest network shows and movies in Hollywood, as well as, short independent films, dance, music and theatrical productions. John T. Williams, Marketing Director at Talent6, says, “The goal for our new web site is to provide our talents with maximum exposure to casting directors searching for new talent and thousands of casting call opportunities nationwide.”

On Windows® - but I guess it’s the same on another O.S. that does not support cluster - I noticed the following behavior when trying to execute a CREATE LOGFILE GROUP syntax like this:

CREATE
 LOGFILE GROUP `test`
 ADD UNDOFILE ‘test’
 INITIAL_SIZE = 33M
 UNDO_BUFFER_SIZE = 8M
 ENGINE = NDBCLUSTER;

In v.5.1.25-rc, v.5.1.24-rc and v.5.1.23-rc, only SQL warnings are shown:

mysql> CREATE
    ->  LOGFILE GROUP `test`
    ->  ADD UNDOFILE ‘test’
    ->  INITIAL_SIZE = 33M
    ->  UNDO_BUFFER_SIZE = 8M
    ->  ENGINE = NDBCLUSTER;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

mysql> SHOW WARNINGS;
+———+——+————————————————————————————————+
| Level   | Code | Message
                                  |
+———+——+————————————————————————————————+
| Warning | 1286 | Unknown table engine ‘NDBCLUSTER’
                                  |
| Error   | 1478 | Table storage engine ‘MyISAM’ does not support the create option ‘TABLESPACE or LOGFILE GROUP’ |
+———+——+————————————————————————————————+
2 rows in set (0.00 sec)
 
In v.6.0.5-alpha a SQL error occurs:

mysql> CREATE
    ->  LOGFILE GROUP `test`
    ->  ADD UNDOFILE ‘test’
    ->  INITIAL_SIZE = 33M
    ->  UNDO_BUFFER_SIZE = 8M
    ->  ENGINE = NDBCLUSTER;
ERROR 1478 (HY000): Table storage engine ‘MyISAM’ does not support the create option ‘TABLESPACE or LOGFILE GROUP’

This difference can generate a bug in your applications if you were using code like this:

IF mysql.error = 0 THEN
 ok, post-creation operations
ELSE
 error, do nothing

In fact, the code above is correct if used on v.6.0.5 but it is wrong if used on v.5.1.25 (the application executes the post-creation operations even if the logfile group hasn’t been created).

I don’t remember exactly which version, but an old 5.1.x version had the same behavior of v.6.0.5 - i.e. SQL error - and that was the reason why I coded in that way.

Well.. one more application-bug discovered while testing the version 6.0.5-alpha of the server.

This afternoon I changed the code in this way:

IF (mysql.error = 0 AND mysql.warnings=0) THEN
 ok, post-creation operations
ELSE
 error, do nothing

uhmm, I would like to read such changes (errors -> warnings) in the internal mailing list or in the release notes file of the server (indeed, I’m not sure if it’s included in the chapter “Changes in release 5.1.x”).

Moral:

• always read the release notes carefully;
• never eat chocolate biscuits when coding: they could make you lose your concentration!

The WBS Blues Ball held each Winter at the Cotillion Ballroom offers local musicians an opportunity to play together for their admiring fans in a historical …