…: mysql> EXPLAIN SELECT * FROM cast_info WHERE role_id = 1 and note like ‘%Jaime%’\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: cast…: mysql> EXPLAIN SELECT role_id FROM cast_info WHERE role_id = 1 and note like ‘%Jaime%’\G *************************** 1. row *************************** id: 1 select_type…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
…from an objective viewpoint. I performed two different types of testing. The first focused on core … data. This is an example of implicit casting that probably wouldn’t happen in a real…the queries. ICE supports almost all of the MySQL aggregation functions. Notably, GROUP_CONCAT is not supported…
Post: Be careful when joining on CONCAT
October 16, 2007 By 16 Comments
… that, you can use an explicit type cast… OK, let’s check if that really helps: mysql> EXPLAIN -> SELECT -> tb1.* -> FROM tb2 -> STRAIGHT_JOIN tb1 -> WHERE -> ( -> tb1.vid LIKE ‘prefix-%’ AND -> tb1.vid = CONCAT(‘prefix-’, CAST(tb2…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
…_time)) …. does give a result of zero, whereas doing a CAST() or a CONVERT() on the update_time field first (so…-22 result. The documentation for MySQL 5.5 states that the supported range for the DATETIME type is 1000-01-01 00…:00:00 | +———————+ Very bizarre. On one hand, it seems like MySQL is using date windowing for two-digit dates (this would…
Comment: MySQL Query Cache
November 2, 2011 By 70 Comments
… by MySQL. So is there any other option to cache it “force cache” ? ************************************************************************************************************ select ea.string_value , cast((… ea.id join db_two.table4 on table4.TYPE = ‘DATA_SOURCE_TYPE‘ join db_two.table5 e on e….
