Hi all, Baron, > Here's one: any three of group by, order by, limit, and offset.
Maybe its me but I don't think I understand. Example? > Here's another: queries to show results in some ranked order. (OK, > I'm just sneaking in a double vote for the one above). There is a part of the SQL standard for this (or a draft at least): OLAP functions. What you describe here is an ORDER BY on the RANK() or DENSE_RANK() analytical function (aka OLAP function) > How can we make these easier to write and faster to perform? Most of The function syntax takes care of the easier to write part. Faster to perform: heh, good question. It would mean that deep inside query execution, something keeps track. (running total). Probably not hard to do, but how to do it in a way that it can be called 'pluggable'? (Assuming that this feature is not a core feature) > What other things are hard for MySQL now, and are just kinda hard to > do purely because relational-ism makes it so? Some places where MySQL > has broken relational-ism, like ON DUPLICATE KEY UPDATE, have really > been beneficial -- more? Agree with Roy on this one. Nothing in relation theory says you can't have this functionality. In fact, it uses a relational feature in a declarative way to offer a particular conflict resolution - seems like a fair use of the relational model. > How about inserting and getting the result back at the same time? > (Postgres does this already) Or inserting into two tables at once? > Or deleting from one table and inserting into another at the same > time? Or deleting while getting back the deleted rows? (That would > be a "queue", but it would be useful for a lot more than that -- think > data archiving -- DELECT FROM foo INTO foo_archive WHERE ....") Agree with Stewart. Batched client protocol. Would be nice too because it may be easier for the receiving end to shell out the statements to multiple nodes and execute the batch in parallel. kind regards, Roland. > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Roland Bouman http://rpbouman.blogspot.com/ _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
