Bug #29931 Connector/NET does not handle Saudi Hijri calendar correctly
Submitted: 20 Jul 2007 14:39 Modified: 7 Aug 2007 9:23
Reporter: Sveta Smirnova
Status: Closed
Category:Connector/Net Severity:S3 (Non-critical)
Version:5.1.1.0 OS:Microsoft Windows
Assigned to: Target Version:

[20 Jul 2007 14:39] Sveta Smirnova 
Description:
Connector/NET does not handle Saudi Hijri calendar correctly. 

Problem is class UmAlQuraCalendar. See also
http://msdn2.microsoft.com/en-us/library/system.globalization.umalquracalendar(VS.80).aspx:

The UmAlQuraCalendar class is nearly identical to the HijriCalendar class, except the
Saudi Hijri calendar uses a table-based algorithm licensed from the Saudi government to
calculate dates, can express dates to the year 1450 A.H., and does not support the
HijriAdjustment property.

How to repeat:
Run NET application on a user account with regional settings "Arabic (Saudi Arabia)"

You'll get error:

Specified time is not supported in this calendar. It should be between 07/18/0622
00:00:00 (Gregorian date) and 12/31/9999 23:59:59 (Gregorian date), inclusive.
Parameter name: time
Server stack trace:
at System.Globalization.HijriCalendar.CheckTicksRange(Int64 ticks)
at System.Globalization.HijriCalendar.GetDatePart(Int64 ticks, Int32 part)
at System.Globalization.HijriCalendar.GetDayOfMonth(DateTime time)
at System.DateTimeFormat.FormatCustomized(DateTime dateTime, String format,
DateTimeFormatInfo dtfi)
at System.DateTimeFormat.Format(DateTime dateTime, String format, DateTimeFormatInfo
dtfi)
at System.DateTime.ToString()
at MySql.Data.Types.MySqlDateTime.ComposePatterns()
at MySql.Data.Types.MySqlDateTime..ctor(Int32 year, Int32 month, Int32 day, Int32 hour,
Int32 minute, Int32 second, MySqlDbType type)
at MySql.Data.Types.MySqlDateTime.ParseMySql(String s, Boolean is41)
at MySql.Data.Types.MySqlDateTime.ReadValue(PacketReader reader, Int64 length)
at MySql.Data.MySqlClient.NativeDriver.ReadFieldValue(Int32 index, MySqlField field,
MySqlValue valObject)
at MySql.Data.MySqlClient.CommandResult.ReadDataRow(Boolean loadFields)
at MySql.Data.MySqlClient.MySqlDataReader.Read()

Suggested fix:
Provide workaround of calendar limitation for users with "Arabic (Saudi Arabia)" regional
settings
[20 Jul 2007 22:14] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/31289
[20 Jul 2007 22:16] Reggie Burnett 
Fixed in 5.0.8 and 5.1.3
[20 Jul 2007 22:18] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/31290
[7 Aug 2007 9:23] MC Brown 
A note has been added to the 5.0.8 and 5.1.3 changelogs: 

The Saudi Hijri calendar was not supported