Ran into an issue where shared locks were being applied (for InnoDB) on a statement with this format:
insert into a select * from b;
While that statement is running, not only does a have some locks applied, but so does b! problem is… my statement was not exactly that simple. Instead, the select statement [...]
Entries Tagged as ‘SQL’
March 2, 2007
Avoiding Insert Locking With Insert Into
July 18, 2006
The Future, Conan?
Why aren’t my fixtures properly loading their ‘registered’ timestamps correctly?
Ah, the dreaded Year 2038 issue
loads fine: user_registered: ‘2038-01-18 21:14:07′
not happy: user_registered: ‘2038-01-18 21:14:08′
So, that fixture that I just wanted to have ‘a date way out in the future’ will need to be knocked back a few years I guess.
April 19, 2006
Rubicizing
So far so good. In a fairly short amount of time I have an application with some basic functionality + user management (register, signin, email confirmations, etc). Very simple = very nice.
So far I’ve been leaning pretty heavily on:
Pick Axe – Especially Chapters 27 (Built-in Classes and Modules) & Chapter 28 [...]
March 31, 2006
What Time(stamp) is it?
The app I am currently developing (in Java, not the Ruby tutorial I’ve been talking about) relies on a timestamp to report only the most recent activity to it’s clients. So, why was it not properly reporting our test data?
After some deliberation I ran the simple statement:
select distinct trim(current_timestamp) from xxx.yyy
Why the [...]
