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
0
votes
0 answers

MariaDB 10.4 has a performance drop

I have a magento 2.4.5-p1 store, and that forced me to upgrade to Mariadb 10.4. So, I have noticed a huge drop in performance. Previously I could run several processes at the same time, and I never had a table locking problem, now with this new…
Thorres
  • 1
  • 2
0
votes
0 answers

Is there a way to select Maria Db table row that has json values column together with other columns where* a condition is met in the Json

Using the Sample of json values attached below , im unable to select all attributes of the json where receivedstatus='YES' and those that receivedstatus='No' not to show up . [ { "itemCode": "LAB-BIOCHEM-0007", "serviceName": "Blood Gas…
MICHAEL NJUGUNA
  • 11
  • 3
0
votes
1 answer

DataGrip fails to import CSV file with entries-count exceeding a specific threshold

I have a MaridaDB table and importing a CSV file of 36,000 entries using the DataGrip "import" dialog box succeeds with no issues at all; but, when a single entry is added to the CSV file to have 36,001 entries, the import fails with the following…
goodUser
  • 249
  • 1
  • 13
0
votes
1 answer

Calculate difference between endTime from ID 1 and startTime from ID 2

id startTime endTime 1 2022-12-3 13:00:00 2022-12-3 14:00:00 2 2022-12-3 14:00:00 2022-12-3 14:30:00 3 2022-12-3 15:00:00 2022-12-3 15:15:00 4 2022-12-3 15:30:00 2222-12-3 16:30:00 5 2022-12-3 18:30:00 …
Cole
  • 23
  • 8
0
votes
0 answers

SpringBoot multiple datasources Junit test fails with H2

I have a springboot project which requests data from 2 datasources (2 MariaDB SQL databases) and I have successfully implemented it by creating 2 configuration classes for each DB and their respective Beans. My DB used by default is the User DB…
pierre57
  • 11
  • 1
0
votes
1 answer

how can I add all images in a array but show only one car

I have a table named cars. Then I have a table named car_infos and then I have a table car_photos. So if I have 3 images on my car_photos and want to select all cars then my rows shows the car x3. If I have 4 images then my rows shows the car x4. So…
universe11
  • 703
  • 1
  • 11
  • 35
0
votes
1 answer

Mysql select query with ordering issue

I want to display one paid status(1) column and then 3 unpaid(0) status column respectively. Paid status is taken based on Expirydate, the date greater than now is considered paid status and date which is less than expiry date is considered unpaid…
Jewel John
  • 1
  • 1
0
votes
1 answer

How to store passwords in the database (Python)

While making my first major project, I have encountered a problem. I need to store passwords in a database. I know about hashing using bcrypt and salting, but I don't know how to properly store them in the database (what type of data to use). Should…
StNicolay
  • 1
  • 1
0
votes
0 answers

innodb_strict_mode=OFF MariaDB 10.4

I need to turn off inno_strict_mode Following is my current my.cnf file Is it correct to change in this way?
user3718303
  • 41
  • 5
0
votes
1 answer

MySQL/MariaDB Count not output all result of WHERE IN clause of array

I need help on this. Will really appreciate it. I am sending an array from an endpoint to my model to fetch the count of each item in my array, If I do a simple selection of all or some of the columns in my table, I get all the results. If I combine…
chized
  • 23
  • 1
  • 6
0
votes
2 answers

Using PHP in MYSQL for order by with MariaDb

I'm trying to retrieve records in the order in which I think they are being accessed. My code is as follows: the data to search for: $to_check="Yes_ij_affirmation', ',_cm', 'there_px_ex', 'is_vbz_1', '._fs"; the select statement: $sql = "SELECT wd,…
PhilB
  • 7
  • 6
0
votes
1 answer

Cannot log in to mariadb from node.js app

I can log in with the same credentials from Windows Command Line and from MariaDB admin. But trying to log in from node.js app fails... const mariadb = require('mariadb'); const pool = mariadb.createPool({ host: 'localhost', …
Николай Беляков
  • 183
  • 1
  • 8
0
votes
1 answer

How do I retrieve a unique list of JSON values from JSON arrays stored in TEXT columns in multiple rows in a MariaDB table

I currently have an array of JSON objects stored in a TEXT column called 'tax_components' in a table called 'orders' in a MariaDB Database (version 10.4) like below: Row 1 [ {"tax_type":"Vat…
Anand George
  • 5
  • 4
0
votes
3 answers

Deleting rows using a limit and offset without using IN clause

I want to delete rows with an offset, so I am forced to use a nested query since its not support in the raw DELETE clause. I know this would worked (ID is the primary key): DELETE FROM customers WHERE ID IN ( SELECT ID FROM customers …
Paul Shan
  • 63
  • 1
  • 8
0
votes
0 answers

How to I split a column (of Strings) in MariaDB

I´m new to MariaDB. I have imported a Json.file in my MySQL Workbench. But e.g. the authors are all in one line instead each author in one line. Is there a way to split them up, so each author gets a new line like this: Lucinda Riley\n Margit…
Marco
  • 35
  • 5
1 2 3
…
10 11