Of course, The postings on this site are my own and don’t necessarily …[Read more...]
I got this idea from a Valerii Kravchuk’s MySQL bug report:
In theory, I completely agree that MySQL and forks should not
allow us to set a default storage engine which cannot be used to
create a table. You can see the same with MariaDB’s
SEQUENCE. The MySQL & forks philosophy seems to
be: ignore your mistakes, so you can repeat them
forever. Which can turn a mistype into a major data loss.
Unless you only use InnoDB and your magic powers tell you that this will never change, …[Read more...]
The Oracle Database 12c documentation says you can set
the maximum size of a
VARCHAR2 to 32,767 bytes.
That’s true except when you’re trying to map a large Java string
VARCHAR2. It fails when the physical size of
the Java string is greater than 4,000 bytes with an
ORA-01002 or fetch out of sequence error.
SELECT read_text_file('C:\Data\loader\Hobbit1.txt') * ERROR at line 1: ORA-24345: A Truncation or null fetch error occurred ERROR: ORA-01002: fetch out of sequence
You need to grant privileges before you can test this code. You can …[Read more...]
Since the dawn of time, MySQL indexes have a limit: they cannot
be descending. Yes,
ALTER TABLE and
INDEX can contain the
DESC keywords. It is perfectly legal in MySQL. But
this does not mean that descending indexes are created. This is a
well-known MySQL feature: when it cannot do something, it just
pretends to. Well… someone thinks it is a feature. I think it is
a bug (a bug is an unexpected behaviour), but what can we do.
The lack of support for descending indexes is only an issue when we need to create an index in which at least one column is ascending and at least one …[Read more...]
The MySQL Utilities Team is pleased to announce the latest
release candidate (RC) release of MySQL Utilities. This release
includes a number of improvements for useabilty, stability, and a
few enhancements. A complete list of all improvements can be
found in our release_notes.
We have also included two new utilities.
I've completed a new release of the Connector/Arduino! The new
release contains some major improvements with memory
Memory, What …
I want to teach you the difference between an inner and an outer join. We first need to think about what a join is. Simply, it’s when you combine two tables to make a new one. You’re not physically creating a new table when you join them together, but for the purposes of the query, you are creating a new virtual table. Every row now has the columns from both tables. So if TableA has columns Col1 and Col2 and TableB has columns Col3 and Col4, when you join these two tables, you’ll get Col1, Col2, Col3, and Col4. Just as with any query, you have the option of including all columns or excluding some, as well as filtering out rows.
Inner join. A …[Read more...]
Over the past few years, we’ve seen MySQL technology advance in leaps and bounds, especially when it comes to scalability. But by focusing on the internals of the storage engine for so long, MySQL has fallen behind regarding support for advanced SQL features.
Why is this significant? It means that MySQL is now the …[Read more...]