Not sure how many CEOs get coverage on Slashdot, but a few days ago, Marten Mickos did an online interview there.  Sometimes online discussions degenerate into a technological pissing match (such as the venerable "vi vs. emacs" arguments) and I'm glad this one didn't.  Marten talks about issues around software quality, building a business, walking the line between enterprise and community needs and other interesting topics.

• Slashdot: MySQL CEO Marten Mickos Answers Your Questions

Following up on what Stewart and Colin reported: this definitely is the first time PBXT has been mentioned on SlashDot: MySQL CEO Mårten Mickos Answers Your Questions.

Mårten, speaking of the the innovative power of MySQL AB, says: "But more massive is the innovation that happens in the MySQL ecosystem", and lists PBXT amongst a lot of other great work.

So I am very proud that PBXT was mentioned in this context!

I found a bug on the view implementation.

According to the manual some view is updatable if the view satisfies the "one-to-one relationship" between the rows in the view definition and the rows in the underlying tables. To be more specific a view is not updatable if it contains any of the following:

• 
  
• aggregate functions (AVG(), SUM(), MIN(), ...)
  
• DISTINCT
  
• GROUP BY
  
• HAVING
  
• UNION (ALL)
  
• subquery in select list
  
• JOIN (with some exception)
  
• non-updatable view in the FROM clause
  
• algorithm=temptable
  
• refers only to literal values
  

So, let's try this simple example:


mysql> create table t1 (a int);
Query OK, 0 rows affected (0.21 sec)



mysql> create …

I found a bug on the view implementation.

According to the manual some view is updatable if the view satisfies the “one-to-one relationship” between the rows in the view definition and the rows in the underlying tables. To be more specific a view is not updatable if it contains any of the following:

• aggregate functions (AVG(), SUM(), MIN(), …)
• DISTINCT
• GROUP BY
• HAVING
• UNION (ALL)
• subquery in select list
• JOIN (with some exception)
• non-updatable view in the FROM clause
• algorithm=temptable
• refers only to literal values

So, let’s try this simple example:


mysql> create table t1 (a int);
Query OK, 0 rows affected (0.21 sec)



mysql> create view v1 as select a from t1;
Query OK, 0 rows affected (0.00 sec) …

Last week while visiting Lars I had a moment of embarrassment. While going over my system of "Getting Things Done" with Lars, I revealed that my inboxes were huge.

On the flight back home I took what was once thousands of pieces of email divided into two email account (one my MySQL account, and the other Tangent) and got my inboxes down to under 150 total. I did this through a combination of "delete this entire mailing list" and "read it all".

So how did I have such a large email inbox? A few things I noticed while deleting the email:

1) There were emails in my inbox I should have replied too. Most email I can answer in minutes, anything else gets deleted and added to my to-do list. It looks like I will occasionally make an assumption of "this will take just a couple of minutes" get interrupted by a phone call, and never return to it. Not answering or deleting just two pieces of email a day, will leave …

A common problem MySQL users have with Crystal Reports 9 is the inability to browse tables and fields. While you can define a MySQL DSN, when you open it in Crystal Reports 9 you have no tables or fields in the field browser. This of course makes it very difficult to create a report.

Up until recently, the only two workarounds have been to either create the report in an older version of Crystal Reports and then open it in Crystal Reports 9, or use custom commands to return field data. Neither of these are particularly effective for creating reports.

This has been a known issue with Crystal Decisions and has now been solved. The full article is available in a knowledgebase article located at http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp”

The short version is that you need to download …

If you like compiling from source then a collection of scripts may save you a considerable amount of effort, especially when it come to repeating the process when you upgrade.

OK, so I'm starting to get really excited about MySQL Camp in a couple weeks. Things are shaping up to be a fantastic event. Later today, I'll be cleaning up the SessionSchedule wiki page with more information on exact times and rooms for everything.

I will be arriving in San Jose airport on Thursday (November the 9th) evening at 7:30pm and will be getting a rental car at the airport (thanks Blue Chip program at Thrifty!). I'll be hanging out at the airport at the Internet cafe until 10pm so that I can give Baron Schwartz and Sheeri Kritzer a ride to the hotels in Palo Alto (we're staying at Motel 6, which AFAIK, still has available rooms). That leaves an extra seat in the car for another camper, so shoot me an email to …

I wish I could say that Europe is free from software patents, but it is not. In contravention of the existing statutory law, the European Patent Office (EPO) continues to bend and break the law every day by issuing European software patents. And if the EPLA were to be ratified in its current form or any form near the present proposal, tens of thousands of existing European software patents would become strongly enforceable overnight.

Earlier this year, the NoSoftwarePatents Award campaign started in order to draw attention to the EPO’s unacceptable granting practice. That award is not linked to the original NoSoftwarePatents.com campaign I founded in 2004 and handed to the FFII …

Saturn’s autoweb

I’ve hacked my scripts that generate doxygen docs to also build MySQL 4.1, 5.0 and 5.1 for AMD64 (the box that it’s running on) with Cluster. This is to help my idea of running Gallery at home with NDB disk data tables in very recent MySQL builds.

How’s it going so far? Well… I’ve found some bugs and some seemingly strange behaviour here and there. However, bug reports will come, and I’m currently running a bit of an older build.

I’ll make the URL of the Gallery public at some point too