Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
1 3 8
Impact
~7k people reached

  • 0 posts edited
  • 1 helpful flag
  • 2 votes cast
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