Re: [Maria-discuss] Strange timestamp index behaviour / bug

Hi! Am 03.04.19 um 17:36 schrieb Reinis Rozitis: Hi, I was playing more with the issue of Mariadb not using a timestamp index for a particular time range - can someone explain why the following happens (or how the timestamps actually work?): you better say server version and show create table

Re: [Maria-discuss] GSOC 2015 :UDFs returning arrays

Hi! On 10.03.15 21:41, Justin Swanhart wrote: No, You SAY the UDF can support them, but you neglect to point to a technical way how. If you want to return a row as an array, well, how do you add an item to a row outside of the UDF, remove one? How do you count the items in the row? How d

Re: [Maria-discuss] GSOC 2015 :UDFs returning arrays

Hi! On 10.03.15 21:01, Justin Swanhart wrote: [accidentally replied only to sender, pasting reply here to all] Hi, So how exactly would you go about returning a row type? You get four choices with UDF: STRING_RESULT INT_RESULT REAL_RESULT DECIMAL_RESULT (which is handled just like strings,

Re: [Maria-discuss] GSOC 2015 :UDFs returning arrays

Hi! On 10.03.15 19:38, Justin Swanhart wrote: Hi, MySQL has no ARRAY data type. In array is basicaly a nested table data type and MySQL doesn't support nested tables either, except through dynamic columns. So, a UDF that returned an array could only be used by other UDF that understand arr

Re: [Maria-discuss] Restated: JSON cannot represent binary data

On 03.02.15 13:13, Sergei Golubchik wrote: [skip] A dynamic column cannot be NULL, so using a JSON null (a different kind of null) to express "dynamic column exists but cannot be represented as requested" should work. The ORM would then have the names and positions in the structure of all the B

[Maria-discuss] Data type conversion (Was: The future of Dynamic Columns)

Hi! On 30.01.15 00:03, Roberto Spadim wrote: Hi Oleksandr!! :) Hi, Roberto! at "value" parameter, COLUMN_CREATE know that we are using a STRING, but should be any other data type The *|as type|* part allows one to specify the value type. In most cases, thi

Re: [Maria-discuss] The future of Dynamic Columns

Hi, Roberto! On 29.01.15 15:55, Roberto Spadim wrote: 2015-01-29 12:34 GMT-02:00 Tom Worster >: I have one final technical question. It is for my understanding and does not reflect a problem I have as a user. The manual says: > The answer is: SQL is

Re: [Maria-discuss] The future of Dynamic Columns

Hi, Tom! On 29.01.15 01:12, Tom Worster wrote: [skip] And Maria promises us that we could use that expression to write the value back and the result will be the exact same thing. A sort of idempotency promise (kinda). This doesn't make the interface any less clunky (on the contrary) but I hav

[Maria-discuss] Fwd: Re: The future of Dynamic Columns

Hi! Sorry I forgot to put in in the list. Forwarded Message Тема: Re: [Maria-discuss] The future of Dynamic Columns Дата: Wed, 28 Jan 2015 23:44:39 +0100 Від:Oleksandr Byelkin Кому: Roberto Spadim Hi, Roberto! On 28.01.15 23:13, Roberto Spadim wrote: Hi Peter

Re: [Maria-discuss] The future of Dynamic Columns

Hi, Tom! On 28.01.15 23:01, Tom Worster wrote: While functions for getting and setting via json might be useful, I think they are peripheral to the core datatype problem here. The interface to dynamic columns in Maria is SQL. The internal datatypes are SQLish. We can be completely sure of wh

Re: [Maria-discuss] The future of Dynamic Columns

Hi, Tom! On 28.01.15 18:04, Tom Worster wrote: Hi Oleksandr, Thank you for the response. It helps me make my decision by narrowing the options. I cannot help with money. My company doesn't have any (really! our market is non-commercial radio stations) but if the ORM extension turns out well th

Re: [Maria-discuss] The future of Dynamic Columns

Hi! On 27.01.15 16:39, Tom Worster wrote: [skip] 2. In at least two places (one was here ) I've read text with the implied meaning, "we may improve such-and-such about MDC if and when people start actually using it."

Re: [Maria-discuss] (no subject)

Hi! On 21.11.14 06:30, Pierre GOUPIL wrote: Good morning, Is there a way to have MariaDB run in-memory? I mean, without changing the table engines. I have my production code which needs to be persisted to disk, but for my unit tests, it would be great to have an in-memory DB. I'm in the J

Re: [Maria-discuss] OQGRAPH and query cache

Hi! On 23.09.14 17:25, Roberto Spadim wrote: Hi guys, i was reading docs, and found this: * The query cache needs to be disabled in order to use OQGRAPH and, in older versions, Galera . Why query cache needs to b

Re: [Maria-discuss] Spider and query cache

Hi! On 21.09.14 05:06, Roberto Spadim wrote: [skip] sounds crazy? :) ok i know that query cache have some problems with mutex, but it's another history we could have a better hit rate with this feature (at least when correctly used) check that query cache become inconsistent if we change data

Re: [Maria-discuss] Aria engine: log initialization failed

Hi! 02.08.2014 21:12, Reindl Harald пишет: what is in "aria_log.0001" and "aria_log_control" and can i skip them from backups? as far as i see they don't contain any really needed informations It is transaction log files, as well as some parameters (block size). Transaction log used in re

Re: [Maria-discuss] dynamic columns interface

Hi! 19 апр. 2011, в 02:07, MARK CALLAGHAN написал(а): > The current interface requires a name and a number Actually, currently only numbers are required and possible, but there is plan (actually first item in the our TODO list about dynamic columns) to add ability to use names instead of or wi

Re: [Maria-discuss] Dynamic columns Library

Hi! Sorry for delay, but I found that the answer could not be postponed. 28 марта 2011, в 16:19, Michael Widenius написал(а): > > Hi! > > I am cc:ing maria-discuss as you accidently forgot to also email the > patch there. > >>>>>> "Oleksandr" ==

Re: [Maria-discuss] [All] askmonty.org moving to a new server this Thursday (25 Feb)

Hi! 22 февр. 2010, в 21:50, Daniel Bartholomew написал(а): [skip] askmonty.org is the only domain/website that will be impacted by this move, websites on any other domain (such as buildbot.askmonty.org) are not part of this move and will continue to function normally. I think mail will be lef

Re: [Maria-discuss] virtual columns

5 февр. 2010, в 10:02, Oleksandr Byelkin написал(а): [skip] Our syntax is [GENERATED ALWAYS] AS ( ) [VIRTUAL | PERSISENT] default is persistent. Syntax changed to be more compatible with MS SQL and Oracle Sorry I forgot something: [GENERATED ALWAYS] AS ( ) [VIRTUAL

Re: [Maria-discuss] virtual columns

Hi! 5 февр. 2010, в 04:42, Federico Razzoli написал(а): I've read that MariaDB 5.2 will support virtual columns and I've read the virtual columns' specifications: http://forge.mysql.com/wiki/MySQL_virtual_columns_ref_manual I think there is a problem in that document. In CREATE TABLE and in

Re: [Maria-discuss] Default Database Engine

Hi! Jim Grill wrote: > Same here (Solaris 10x86-64). This also had me a bit confused at > first. I guess this documentation is still relevant: > http://dev.mysql.com/doc/refman/5.1-maria/en/se-maria.html > > "To create a Maria table you must specify the engine when using the > CREATE TABLE state

Re: [Maria-discuss] Additional promise to the MCA

Hi! 15 сент. 2009, в 17:11, Henrik Ingo написал(а): [skip] As a special note, it is observed that the Monty Program Ab Contributor Agreement itself fulfills these requirements. Also note that this promise does not not extend as a requirement to 3rd parties so as to restrict their rights to l