Dennis Williamson

less info
118 reputation
117
bio website blog.denniswilliamson.us
location United States
age
visits member for 2 years, 7 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.


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
Jan
11
awarded  Scholar
Jan
11
comment “on duplicate key update” all the non-key fields mentioned in the insert
Option 1 had no effect. Option 2 (my original version) works, but is unpleasantly verbose. Thanks for your assistance.
Jan
7
awarded  Student