Stack Overflow
Stack Overflow

Questions tagged [mariadb-10.4]

MariaDB 10.4 is an open source database server that offers drop-in replacement functionality for MySQL. Use this tag only when using MariaDB version 10.4.*

MariaDB 10.4 version was released in June 2019. It implements notable features such as instant DROP COLUMN and ordering change in InnoDB tables; Account Locking; User Password Expiry etc.

Complete list of changes and improvements can be seen here: https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-104/

156 questions
1
vote
1 answer

Unable to DELETE WHERE IN subquery

Using MariaDB 10.4.12, I am trying to execute a DELETE statement that predicates on a subquery: DELETE FROM `mydb1`.`mytable1` WHERE `my_id` IN ( SELECT `TABLE_ID` FROM `TABLES_CT` WHERE `TABLE_NAME` = 'tableName'AND `TABLE_ACTION` IN…
user8723089
  • 23
  • 3
1
vote
2 answers

Problems with java @GeneratedValue (strategy = GenerationType.IDENTITY) using MariaDB 10.4 and eclipselink

I am developing a REST web service in Java EE I am using: Glassfish 5.0 (build 25), MariaDB 10.4 and eclipselink (JPA 2.1) here is my code: commande_line table CREATE TABLE IF NOT EXISTS `cooldb`.`commande_line` ( `id` INT NOT NULL…
yacdidi
  • 13
  • 6
1
vote
1 answer

How to differentiate between incorrect login credentials and server unavailable using JDBC

I'm writing a program to connect to a MariaDB database via JDBC. With the correct credentials (username/password) it connects fine. But I'm trying to produce the appropriate error messages when it doesn't connect and that's where I have an issue. …
Nexmo16
  • 137
  • 1
  • 11
1
vote
2 answers

GROUP BY with multiple colums and LIMIT 2?

I ve got the following data structure in my mysql Database: +-------+----------+-------+------------+-------------+-------------+ | Color | brand | size | otherstuff | otherstuff2 | otherstuff3…
Ben
  • 73
  • 7
1
vote
3 answers

ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use

MySQL.Async.fetchAll('INSERT INTO position (id, x, y, z) VALUES (@id, @x, @y, @z)', {['@id'] = identifier, ['@x'] = coords.x, ['@y'] = coords.z, ['@z'] = coords.z}) Hi. I'm learning to programm and I've written the simple command above for my…
user11786059
1
vote
0 answers

MariaDb / Mysql Rank function- One partition ranked before the other

I have two rank functions and one works as expected. However, the other one ranks one partition before the other partitions. Here's the code: if(count1>=3 and count2>=2 and count3>=2, rank() over (partition by examdateID, sClass Order By…
Bonifes Maina
  • 33
  • 1
  • 6
1
vote
2 answers

Analytical Function Of Oracle vs MariaDB

Currently migrating my Oracle queries to MariaDB 10.4 I have a hard time in analytical function. MARIADB Code: select cgi, timestamp, hour, rat_type, dl_tput, ntile(24) over (partition by timestamp,rat_type order by dl_tput) as…
Ace
  • 27
  • 7
1
vote
1 answer

Specified Twice Table for 'DELETE' in MariaDB

I created a query to delete some record in MariaDB Query : DELETE FROM HrAttLogsFormatted WHERE DateIn = '2019-04-10' AND Late != '' AND ( FingerId, CreatedDate ) IN ( SELECT FingerId, MAX( CreatedDate ) …
Aldan
  • 674
  • 9
  • 23
0
votes
0 answers

string value was not compared correctly

database charset : latin1 database collation: latin1_swedish_ci table charset : latin1 table collation: latin1_swedish_ci connection charset : UTF8 connection collation : utf8_general_ci query was working fine for years. But on a day I had a…
Padmaraj S
  • 1
0
votes
1 answer

MySQL slow query becomes slower over time until completely timing out

Database server: Server: 127.0.0.1 via TCP/IP Server type: MariaDB Server version: 10.4.27-MariaDB Web server: Apache/2.4.54 (Win64) PHP version: 8.1.12 phpMyAdmin version: 5.2.0 CPU usage at 10-15% and Memory usage at 30-40% I am hoping to…
user3436467
  • 1,763
  • 1
  • 22
  • 35
0
votes
1 answer

return all regex match from each row of a table in mysql

I have a table named 'Articles' that has some rows, inside each row has some image tag that I want to return all of those. I used this query but it only returns one of those tags per row. And other lines are returned empty. SELECT…
ali
  • 109
  • 9
0
votes
0 answers

Why is this cursor throwing #2014 - Commands out of sync; you can't run this command now

I am trying a simple trigger to print id of a table but it's throwing #2014 - Commands out of sync; you can't run this command now CREATE TABLE `cursor_test` ( `id` bigint(21), `name` varchar(10) DEFAULT NULL ) DELIMITER // CREATE PROCEDURE…
Gan3i
  • 95
  • 11
0
votes
0 answers

Enable MariaDB Error Logging into file without service restart / without downtime?

Is it possible to enable / configure the mariaDB error logging at runtime and make changes affect without a service restart / downtime? I'm using mariadDB 10.4.28 and the error logging into a log file is not configured at the moment. I know how i…
Opa114
  • 518
  • 4
  • 12
  • 28
0
votes
1 answer

Unable to set global variable 'innodb_ft_server_stopword_table' in MariaDB

I am unable to set the global variable 'innodb_ft_server_stopword_table' in MariaDB. MariaDB version 10.4.13 Windows 10 operating system. I have created a table called 'mystopwordtable' with one column called VALUE, defined as a varchar(30)…
gecko
  • 23
  • 6
0
votes
1 answer

MariaDB update performance with LIMIT

We have an app, with multiple threads, which are grabbing lines from a table for processing. Imagine queries like this: UPDATE our_table SET content_status = 'IN_PROGRESS', worker = 'worker_4' WHERE content_upload_status = 'ADD' and…
Zsolt János
  • 491
  • 8
  • 18
1 2 3
…
10 11