If you’re getting an error that reads something like “nextval: reached minimum value of sequence “sequence1” (-3)” in PostgreSQL, it’s probably because you’re trying to generate a new value from a descending sequence, but the sequence has already reached its minimum value.
We have a number options when it comes to dealing with this issue.
Continue readingIn MySQL, we can use the sys.ps_is_instrument_default_timed() function to check whether a given Performance Schema instrument is timed by default.
The function returns YES or NO, depending on whether the instrument is timed by default.
In MySQL, we can use the sys.ps_is_thread_instrumented() function to check whether Performance Schema instrumentation for a given connection ID is enabled.
The function returns YES or NO, depending on whether the instrumentation is enabled for the given connection. It can also return UNKNOWN if the connection ID is unknown, and NULL if the connection ID is NULL.
In MySQL, we can use the sys.version_patch() function to return the patch release version of the MySQL server.
For example, if we’re using MySQL 8.0.33, sys.version_patch() returns 33.
In MySQL, we can use the sys.version_minor() function to return the minor release version of the MySQL server.
In MySQL, we can use the sys.version_major() function to return the major release version of the MySQL server.
In MySQL, we can use the PS_CURRENT_THREAD_ID() function to get the Performance Schema thread ID assigned to the current connection.
The PS_CURRENT_THREAD_ID() function was added in MySQL 8.0.16, and it does the same thing as PS_THREAD_ID(CONNECTION_ID()).
In MySQL, format_pico_time() is a Performance Schema function that converts a numeric Performance Schema latency or wait time in picoseconds into a human-readable format. It returns a string consisting of a value and a units indicator.
When learning SQL, a common mistake when checking for NULL values is to use an equality operator. In SQL, a NULL value is treated a bit differently to other values.
In SQL we use IS NULL instead of = NULL. Likewise, we use IS NOT NULL instead of <> NULL or != NULL to select those columns that don’t have a NULL value.
In MySQL, the DEFAULT() function returns the default value for a given column in the database.
If the column doesn’t have a default value, an error is returned.
Continue reading