Cannot open tables after upgrade to xcode 27 and IOS 27

[gojyuan]

Hi
Very much a beginner here with sqlitedata but familiar with sqlite. I am getting the following error on runtime

Caught error: Expected column nn (“…”) to not be NULL

This was after the upgrade to macOS 27 (xcode 27), iPadOS 27 and IOS 27 yesterday. Should have been more mindful with the upgrade process. I had a few pointer compiler errors, refreshed all packages and compiled ok.

This app was working previously on ipadOS 26 and IOS 26 using the same db which was created on a different platform so I do not have code to generate the tables.

I understand that the error is related to something else as the data checks out ok and schema is valid. I have used a different view to test and it is always the last field in the query that is displayed in the error message. The app doesn’t seem to be able to open / access the tables but can see them. ( Error message is different for missing table )

My original program ( xcode 26 ) runs on ipadOS 27 but does have issues.

Are there any settings or diagnostics that I can use to display more information.

Any help greatly appreciated
Regards
Linda

[mbrandonw]

Hi @gojyuan, can you provide more information about the problem? What does the query look like that is producing this error and what does the table schema look like? And have you checked the data in the database to see that it is indeed not NULL?

Do you know what version of SQLiteData you were on when things were working and what version you are on now?

[gojyuan]

Hi @mbrandonw

Thank you for responding so fast. My apologies for the long reply.

I have checked the database and all referenced fields are valid. The current version is 1.7.0. I do not know what the previous version was as there have been constant confirm updates during the compile phase

I have one list view that is working (Payments) and 5 that do not display any records. I think I may have a couple of issues. The original db had a 6 character string for the primary key for each table. I wanted to migrate to iCloud in the future so added a new field called id (UUID). I changed all tables to use the new id as the primary key. The code is derived from your videos.

Customer code does not work - error message for not NULL was for contactsID

------- Customer schema -------- Have tried primary key for customerID and also for id -------------
Table struct Customer: Identifiable, Hashable {

let id: UUID
//   @Column(primaryKey: true)
var customerID: String = ""
var title: String     = ""
var firstName: String = ""
var lastName: String  = ""
var referral: String  = ""
...
var contactsID: Int?

}

--------- Customer Load --------------
func reloadData() async {
Task {
await withErrorReporting {
_ = try await $customers.load(
Customer
.order {
...
}
.where {
...
},
animation: .default
)
}
}

}

---

The Payments code below displays records correctly. I am using specific fields in the @selection struct

Table
struct Payment: Identifiable, Hashable {

let id: UUID
// @Column(primaryKey: true)
var paymentID: String   = ""
var paymentDate: Date   = Date.now
var paymentAmt: Double  = 0.00

...
var paymentName: String = ""

}

---

@selection struct CustomerPayment: Identifiable, Hashable {
var paymentID: String
var paymentDate: Date
var paymentAmt: Double
var invoiceType: String
var customerID: String
var customerFirstName: String
var customerLastName: String
var id: String { paymentID }
}

----- Payment Load --------------------
func reloadData() async {
Task {
await withErrorReporting {
_ = try await $customerPayments.load(
Payment
.order {
switch sortField {
case .Date:
if sortAscending {
($0.paymentDate, $0.invoiceNo)
} else {
($0.paymentDate.desc(), $0.invoiceNo)
}

                        case .Invoice:
                            if sortAscending {
                                $0.invoiceNo
                            } else {
                                $0.invoiceNo.desc()
                            }
                        }
                    }
                    .join(Customer.all) { $0.customerID.eq($1.customerID) }
                    .select {
                        CustomerPayment.Columns(paymentID: $0.paymentID,
                                                paymentDate: $0.paymentDate,
                                                paymentAmt: $0.paymentAmt,
                                                invoiceType: $0.invoiceType,
                                                customerID: $1.customerID,
                                                customerFirstName: $1.firstName,
                                                customerLastName: $1.lastName)
                    },
                animation: .default
            )
        }
    }
}