[Maria-discuss] doubt about merge table (10000+) with same structure

2015-09-22 Thread Roberto Spadim
Hi again guys :) i'm with a new problem i have MANY (1+) tables with same struct, and i want to execute a select from "some" (100+) tables i was thinking about creating a view with all tables, something like: CREATE VIEW view_name AS SELECT * FROM table1 WHERE primary_key= UNION ALL SELECT

Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-22 Thread Alexander Barkov
Hi Dan, On 09/20/2015 12:53 AM, Dan Ragle wrote: We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone can help clarify for me what's going on in the following scenario. In brief, we're getting milliseconds displayed in a particular date_sub calculation (and possibly other

Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-22 Thread Alexander Barkov
On 09/23/2015 01:00 AM, Alexander Barkov wrote: Hi Dan, On 09/20/2015 12:53 AM, Dan Ragle wrote: We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone can help clarify for me what's going on in the following scenario. In brief, we're getting milliseconds displayed in a

Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-22 Thread Dan Ragle
Thanks Justin, but I'm not sure I'm following this. Is there some way that I can see the differences in what's being returned from each phase of the operation within the client itself? Each of these statements: select substr(datetime,1,13) from test limit 1; select substr('2015-09-18