This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"Ansi 1 Color" : { | |
"Green Component" : 0, | |
"Blue Component" : 0, | |
"Red Component" : 0.73333334922790527 | |
}, | |
"Tags" : [ | |
], | |
"Ansi 12 Color" : { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DROP FUNCTION IF EXISTS fconsider_null_as_max; | |
DELIMITER // | |
CREATE FUNCTION fconsider_null_as_max (originalYear INT) | |
RETURNS INT | |
BEGIN | |
RETURN CASE | |
WHEN MAX(originalYear IS NULL) = 0 THEN MAX(originalYear) | |
ELSE originalYear | |
END; | |
END; // |
OlderNewer