linq2db: MySQL: Data is Null. This method or property cannot be called on Null values.

Originally, I was seeing these issues in one spot that was using a database view. It was happening somewhat randomly (once or twice a day). I was not able to reproduce that issue and it was not happening when running the test suite, only in production.

Since I thought the issue was with the MySQL view I went ahead and got rid of the view. It’s now running against tables; doesn’t use views anymore. After I removed the views I was able to trigger the issue within the test suite.

The create statement for the emails table is:

CREATE TABLE `email_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(128) NOT NULL,
  `unsubscribed` tinyint(1) NOT NULL DEFAULT '0',
  `is_valid_for_analysis` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`) USING BTREE,
  UNIQUE KEY `id` (`id`,`unsubscribed`) USING BTREE,
  KEY `idx_analysis` (`id`,`is_valid_for_analysis`)
) ENGINE=InnoDB AUTO_INCREMENT=5230558 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

and the one for the vehicles table (the one that works even though it’s very similar to the emails table)

CREATE TABLE `vehicles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vin` varchar(17) NOT NULL,
  `year` int(4) NOT NULL,
  `make` varchar(50) NOT NULL,
  `model` varchar(50) NOT NULL DEFAULT '',
  `is_cleaned` tinyint(1) DEFAULT '0',
  `blackbook_value` decimal(10,4) DEFAULT NULL,
  `blackbook_last_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `year` (`year`) USING BTREE,
  KEY `vehicle` (`vin`,`year`,`make`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=24913935 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

@ili yes, I did migrate to VS2017

@MaceWindu I’ve hit that exact same issue (double dots “…”) with master… after rolling back to 1.8.3 this issue goes away

“there is no null values in any column of dr” – the email column is null, but it’s a string, so it shouldn’t be an issue. Here’s what “dr” looks like:

“mapping expression doesn’t try to access column with out-of-range index” – how do I check for this?

“mapping expression does what it needs for current query” – well… here’s what I was able to fish out from the debug view:

.Lambda #Lambda1<System.Func`6[LinqToDB.Linq.QueryContext,LinqToDB.IDataContext,System.Data.IDataReader,System.Linq.Expressions.Expression,System.Object[],Denali.Core.Entities.Organization.Dto.ProspectDetail]>(
    LinqToDB.Linq.QueryContext $context,
    LinqToDB.IDataContext $dctx,
    System.Data.IDataReader $rd,
    System.Linq.Expressions.Expression $expr,
    System.Object[] $ps) {
    .Block(
        MySql.Data.MySqlClient.MySqlDataReader $ldr,
        Denali.Core.Entities.Organization.Dto.ProspectDetail $ProspectDetail1) {
        $ldr = (MySql.Data.MySqlClient.MySqlDataReader)$rd;
        $ProspectDetail1 = .New Denali.Core.Entities.Organization.Dto.ProspectDetail(){
            ProspectDetailId = #(System.Int32)((System.UInt32).Call $ldr.GetValue(0)),
            ProspectId = #(System.Int32)((System.UInt32).Call $ldr.GetValue(1)),
            CustomerId = #(System.Int32)((System.UInt32).Call $ldr.GetValue(2)),
            CustomerKey = .If (
                .Call $ldr.IsDBNull(3)
            ) {
                null
            } .Else {
                .Call $ldr.GetString(3)
            },
            Proof = .If (
                .Call $ldr.IsDBNull(4)
            ) {
                null
            } .Else {
                .New System.Nullable`1[System.Int32](.Call $ldr.GetInt32(4))
            },
            FirstName = .Call $ldr.GetString(5),
            LastName = .Call $ldr.GetString(6),
            Street1 = .If (
                .Call $ldr.IsDBNull(7)
            ) {
                null
            } .Else {
                .Call $ldr.GetString(7)
            },
            Street2 = .If (
                .Call $ldr.IsDBNull(8)
            ) {
                null
            } .Else {
                .Call $ldr.GetString(8)
            },
            City = .If (
                .Call $ldr.IsDBNull(9)
            ) {
                null
            } .Else {
                .Call $ldr.GetString(9)
            },
            State = .If (
                .Call $ldr.IsDBNull(10)
            ) {
                null
            } .Else {
                .Call $ldr.GetString(10)
            },
            Zip = .If (
                .Call $ldr.IsDBNull(11)
            ) {
                null
            } .Else {
                .Call ((System.UInt32).Call $ldr.GetValue(11)).ToString()
            },
            Phone = .If (
                .Call $ldr.IsDBNull(12)
            ) {
                null
            } .Else {
                .Call $ldr.GetString(12)
            },
            Email = .Call $ldr.GetString(13),
            VIN = .If (
                .Call $ldr.IsDBNull(14)
            ) {
                null
            } .Else {
                .Call $ldr.GetString(14)
            },
            Year = .Call (.If (
                .Call $ldr.IsDBNull(15)
            ) {
                0
            } .Else {
                .Call $ldr.GetInt32(15)
            }).ToString(),
            Make = .If (
                .Call $ldr.IsDBNull(16)
            ) {
                null
            } .Else {
                .Call $ldr.GetString(16)
            },
            Model = .If (
                .Call $ldr.IsDBNull(17)
            ) {
                null
            } .Else {
                .Call $ldr.GetString(17)
            }
        };
        $ProspectDetail1
    }
}

Here’s what my query looks like:

What I find interesting is that both Phone and VIN are strings, just like Email, but those two are wrapped with a IsDBNull check while Email is not…

Also, what’s interesting is that if I force the null check by doing Email = ea.Email == null ? null : ea.Email instead of just Email = ea.Email then it works…

Thoughts?