[MDEV-32865] Get datas from Table Created: 2023-11-23  Updated: 2023-12-05  Resolved: 2023-12-05

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Subquery
Affects Version/s: 10.11.5
Fix Version/s: N/A

Type: Bug Priority: Blocker
Reporter: laurent bisson Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

windows 10

Attachments: PNG File pws.PNG     PNG File pws2.PNG    
Issue Links:
Duplicate
duplicates MDEV-31608 MySQL.Data can not connect to MariaD... Closed

 Description   

Bonjour,

We use a powershell script to get datas from a MariaDB table version 10.11.5. But it doesn't work. Even if it works with 10.9.2 version server.

Problem is at line 23 in testCon.ps1 file, function $dataAdapter.Fill($dataSet, "data")
I don't understand what's the problem.
What is the difference between v10.9.2 and v10.11.5 that don't allow me to get datas ?

Thanks a lot, have a good day.

 Comments   
Comment by Vladislav Vaintroub [ 2023-12-05 ]

The difference is in "show collation", MariaDB 10.10+ returns some with NULL IDs, and MySQL Connector/NET does not like them.
I'm closing this one as duplicate, the primary bug for it is MDEV-31608

Generated at Thu Feb 08 10:34:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.