Bug #105568 MySqlDataReader does not read info schema from views with functions
Submitted: 15 Nov 2021 2:36 Modified: 22 Mar 2022 7:11
Reporter: Matt Gordon Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:8.0.27 OS:Windows
Assigned to: MySQL Verification Team CPU Architecture:Any

[15 Nov 2021 2:36] Matt Gordon 
Description:
Full details can be found here: https://stackoverflow.com/questions/69968492/mysqldatareader-does-not-read-info-schema-fro...

How to repeat:
- Create a view that returns the result of a function for one of the columns
- Try to use MySqlDataReader.Read() with this command text in the MySqlCommand:

SELECT column_name, column_default, data_type, character_maximum_length, is_nullable, ordinal_position, numeric_precision, numeric_scale
FROM information_schema.columns
WHERE table_name = '{0}';

Suggested fix:
Determine why this is happening and ensure MySqlDataReader.Read() can read regardless of whether the view uses a result from a function or not.
[22 Feb 2022 7:11] MySQL Verification Team 
Hello Matt Gordon,

Thank you for the bug report.
I tried to reproduce your issue with the given sample code in the forum but it is not enough to reproduce at my end. Could you please provide complete repeatable test case (project bundled with all the required files, please make it as private if you prefer) to reproduce this issue at our end? Thank you. 

Regards,
Ashwini Patil
[23 Mar 2022 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".