Nation Overview now mentions if the nation can build underwater fortsĬommunion Masters with conservative gem usage didn't try to use spells of higher levels
Yomi also got a boost as their Oni now have full item slots in their spirit form as well. Most importantly it fixes a bug that removed excess gems from rituals if you changed the caster's magic items while he was casting it. This is mainly a bug fix update, but there are a few new improvements as well. Ichtycentaurs now also have a hoof attackĮvent commands req_targaff & req_targnoaff now accept high bitmask values properly statusdump could get a turn nbr -1 after network host, fixedįix for corrupted text with newer versions of the sdl2-ttf lib Oath Stone site now also grants a commander for PD PD could sometimes be raised past limit if shift was pressedįix for deselecting commander from commander group Wish soul slay effect didn't slay the soul properly blindlog province connections also mention status of rivers and mountain passesĬarrion Reanimation removed too many corpses New -blindlog features (ctrl-p in army setup and main map) Heal didn't work properly for units with altered max HP Utterdark Fiends of Darkness can no longer spawn underwaterīlood Slaves could not be used to boost caster's level properly in combatįix for AI spell choice vs nearby enemies Unleash Imprisoned Ones didn't change the site properly Kindly Ones behavior changed to correspond better with description Ghost Ship Armada reported wrong number of kills & gold when multiple armadas were active Increased maximum number of combat reports per turn file
One notable bug fixed in this patch is that blood slaves could not be used to boost the caster's level in combat properly.įix for monkeys not becoming the right type of soulless
This update consists of mostly bug fixes and minor stat fixes. More information about using SQL in Athena, see SQL reference for Amazon Athena.With about half a year since the last update it is time for another one. Now that you have the cloudfront_logs table created in Athena based on theĭata in Amazon S3, you can run SQL queries on the table and see the results in Athena. The table cloudfront_logs is created and appears under the list Myregion with the AWS Region that you areĬurrently using (for example, us-west-1). ) LOCATION 's3://athena-examples- myregion/cloudfront/plaintext/' Returning to the sample data, here is a full example of the final field If you have your own tab or comma-separated data, you can use a LOCATION clause specifies the path in Amazon S3 where the actual data to be Newline character ( LINES TERMINATED BY '\n). ( FIELDS TERMINATED BY '\t') and that each record in the file ends in a The example also specifies that the fields are tab separated ROW FORMAT DELIMITED means that Athena will use aĭefault library called LazySimpleSerDe to do the actual work of Becauseĭate is a reserved word, it is escaped withīacktick (`) characters.
These fields become the columns in the table. The example creates a table called cloudfront_logs and specifies a nameĪnd data type for each field. LOCATION 's3://athena-examples- my-region/cloudfront/plaintext/' CREATE EXTERNAL TABLE IF NOT EXISTS cloudfront_logs (