function getAxisBounds(minVal, maxVal) { var result = { range = maxVal - minVal, lower = 0 }; var powerOfTen = 0; if (result.range EQ 0) { result.interval = 0; result.upper = 0; } else { powerOfTen = fix(log(result.range) / log(10)); result.interval = 10 ^ powerOfTen; if (result.range / result.interval LT 4) { result.interval = result.interval * 2 / 10; } if (round(maxVal / result.interval) * result.interval EQ maxVal) { result.upper = maxVal; } else { result.upper = (fix(maxVal / result.interval) + 1) * result.interval; } result.range = result.upper - result.lower; } return result; } select id from process where name = insert into process (name ) values ( ) select last_insert_id() as id select id, name_regex from alias where name_regex is not null update process set aliasId = where id =