118 reputation
138
bio website blog.denniswilliamson.us
location United States
age
visits member for 2 years, 11 months
seen 4 hours ago

                I am the first user
            to earn at least 30,000
            reputation points each

                 
                    on all three of
                  Stack Overflow,
                 Server Fault and
                     Super User.


         I was also the first user to
surpass 10,000 and 20,000 points each
          on all three of those sites.


Are you a Stackathlete?

Check the standings on


Profile:
I'm a Unix/Linux sysadmin/programmer

Devotion to Duty
Devotion to Duty
Try my unofficial Printifier for xkcd.


Nov
4
awarded  Notable Question
Oct
7
awarded  Notable Question
Sep
24
awarded  Autobiographer
May
27
awarded  Citizen Patrol
May
20
accepted pg_basebackup: could not set compression level -1
May
16
asked pg_basebackup: could not set compression level -1
May
16
answered pg_basebackup: could not set compression level -1
Aug
14
awarded  Fanatic
Jun
5
awarded  Enthusiast
May
22
awarded  Popular Question
Mar
1
awarded  Popular Question
Apr
18
accepted “on duplicate key update” all the non-key fields mentioned in the insert
Apr
18
comment “on duplicate key update” all the non-key fields mentioned in the insert
It's definitely no less verbose. However, it benefits from being much more maintainable since the literals only have to be specified once each. +1 and accepted.
Apr
18
comment How can I select the latest record having one state where no later records exist with any other state?
I had to use @ts = MAX(`timestamp`) AS ts and AND tt.`timestamp` > @ts in order to avoid an error message "ERROR 1247 (42S22): Reference 'ts' not supported (reference to group function)". I'm still getting some false returns where later non-down records exist. Do you have any suggestions for diagnosing this? So far I've tried splitting the queries and the subquery compared to a literal (from MAX(`timestamp`) substituted for ts returns a record which should cause the HAVING NOT EXISTS to fail but doesn't.
Apr
15
revised How can I select the latest record having one state where no later records exist with any other state?
additional information
Apr
15
revised How can I select the latest record having one state where no later records exist with any other state?
additional information
Apr
15
awarded  Editor
Apr
15
revised How can I select the latest record having one state where no later records exist with any other state?
correct a typo
Apr
15
asked How can I select the latest record having one state where no later records exist with any other state?
Jan
11
awarded  Supporter