Showing entries 1 to 3
Displaying posts with tag: value (reset)
Does Consona-Compiere mean community doesn’t matter?

There was another acquisition involving open source software recently when Consona bought Compiere, but what is perhaps most striking about the deal from an open source software perspective is how little it and the Compiere community mattered in the deal.

By most accounts, including that of fellow open source ERP player xTuple CEO Ned Lilly, who offers an interesting and accurate depiction of Compiere’s changes, acknowledge the movement away from community that occurred over the last few years at Compiere. As discussed in our own recent report on the deal, we are also somewhat skeptical over the fate of what is left of Compiere’s open source community, even though Consona plans to …

[Read more]
451 CAOS Links 2009.07.31

When open source goes bad. Is open source a success or failure? And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

When open source goes bad

The H reported on the apparent turmoil at the CentOS project, while Jay Lyman offered the CAOS perspective. Meanwhile Slashdot reported that Alan Cox has quit as Linux TTY subsystem maintainer.

Success or failure?
Danny Windham, Digium CEO, …

[Read more]
Swapping Column Values in MySQL

Today I had to swap 2 columns in one of my MySQL tables. The task, which seems easily accomplishable by a temp variable, proved to be a bit harder to complete. But only just a bit.

Here are my findings:

  1. The

    UPDATE swap_test SET x=y, y=x;

    approach doesn't work, as it'll just set both values to y.

    PostgreSQL seems to handle this query differently, as it apparently uses the old values throughout the whole query. [Reference]
  2. Here's a method that uses a temporary variable. Thanks to Antony from the comments for the "IS NOT NULL" tweak. Without it, the query works unpredictably. See the table schema at the end of the post. This method doesn't swap the values if one of them is NULL. Use method #3 that doesn't have this limitation. …

[Read more]
Showing entries 1 to 3