Skip to content

Merge branch 'develop' into dependabot/gradle/sqldelight-2.0.2

Sign in for the full log view
GitHub Actions / Test Results failed Aug 8, 2024 in 0s

10 fail, 12 skipped, 718 pass in 4m 20s

740 tests   - 1   718 ✔️  - 2   4m 20s ⏱️ - 50m 4s
    6 suites ±0     12 💤 ±0 
    6 files   ±0     10 ❌ +1 

Results for commit 756d615. ± Comparison against earlier commit 63eece0.

Annotations

Check warning on line 0 in com.wire.kalium.persistence.dao.message.MessageNotificationsTest

See this annotation in the file changed.

@github-actions github-actions / Test Results

givenConversationWithMessages_whenConversationLastNotifiedDateUpdated_thenNotificationListEmpty (com.wire.kalium.persistence.dao.message.MessageNotificationsTest) failed 

persistence/build/outputs/androidTest-results/connected/debug/TEST-emulator-5554 - 12-_persistence-.xml [took 0s]
Raw output 
android.database.sqlite.SQLiteException: no such column: row_num (code 1): , while compiling: WITH NumberedMessages AS (
SELECT
m.id,
m.conversation_id AS conversationId,
m.content_type AS contentType,
m.creation_date AS date,
m.sender_user_id AS senderUserId,
(m.expire_after_millis IS NOT NULL) AS isSelfDelete,
u.name AS senderName,
u.preview_asset_id AS senderPreviewAssetId,
c.name AS conversationName,
tc.text_body AS text,
tc.is_quoting_self AS isQuotingSelf,
ac.asset_mime_type AS assetMimeType,
c.muted_status AS mutedStatus,
c.type AS conversationType,
c.degraded_conversation_notified AS degradedConversationNotified,
c.legal_hold_status AS legalHoldStatus,
IFNULL(lhs.legal_hold_status_change_notified, 1) == 1 AS legalHoldStatusChangeNotified,
row_num
FROM
Message m
JOIN
User u ON m.sender_user_id = u.qualified_id
JOIN
Conversation c ON m.conversation_id = c.qualified_id
LEFT JOIN
ConversationLegalHoldStatusChangeNotified AS lhs ON m.conversation_id == lhs.conversation_id AND (m.creation_date > IFNULL(c.last_notified_date, 0))
LEFT JOIN
MessageAssetContent ac ON m.id = ac.message_id AND m.conversation_id = ac.conversation_id
LEFT JOIN
MessageTextContent tc ON m.id = tc.message_id AND m.conversation_id = tc.conversation_id
WHERE
m.visibility = 'VISIBLE' AND
m.content_type IN ('TEXT', 'RESTRICTED_ASSET', 'ASSET', 'KNOCK', 'MISSED_CALL', 'LOCATION') AND
m.creation_date > COALESCE(c.last_notified_date, 0) AND
NOT EXISTS (SELECT 1 FROM SelfUser WHERE id = m.sender_user_id) AND
c.muted_status != 'ALL_MUTED' AND
c.archived = 0
)
SELECT
id,
conversationId,
contentType,
date,
senderUserId,
isSelfDelete,
senderName,
senderPreviewAssetId,
conversationName,
text,
isQuotingSelf,
assetMimeType,
mutedStatus,
conversationType,
degradedConversationNotified,
legalHoldStatus,
legalHoldStatusChangeNotified
FROM
NumberedMessages
WHERE
row_num <= 10 -- there is a bug in sqldelight where you can't use a parameter here
ORDER BY
date DESC
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(Native Method)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:592)
at net.zetetic.database.sqlcipher.SQLiteProgram.<init>(SQLiteProgram.java:64)
at net.zetetic.database.sqlcipher.SQLiteQuery.<init>(SQLiteQuery.java:43)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1168)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1159)
at app.cash.sqldelight.driver.android.AndroidQuery.executeQuery(AndroidSqliteDriver.kt:306)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.execute-zeHU3Mk(AndroidSqliteDriver.kt:169)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery-0yMERmw(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery(AndroidSqliteDriver.kt:29)
at app.cash.sqldelight.SimpleQuery.execute(Query.kt:98)
at app.cash.sqldelight.ExecutableQuery.executeAsList(Query.kt:174)
at com.wire.kalium.persistence.dao.message.MessageDAOImpl$getNotificationMessage$2.invokeSuspend(MessageDAOImpl.kt:302)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693)

Check warning on line 0 in com.wire.kalium.persistence.dao.message.MessageNotificationsTest

See this annotation in the file changed.

@github-actions github-actions / Test Results

givenConversation_whenMessageWithReplyOnOtherMessageInserted_thenNotificationIsNotMarkedAsReply (com.wire.kalium.persistence.dao.message.MessageNotificationsTest) failed 

persistence/build/outputs/androidTest-results/connected/debug/TEST-emulator-5554 - 12-_persistence-.xml [took 0s]
Raw output 
android.database.sqlite.SQLiteException: no such column: row_num (code 1): , while compiling: WITH NumberedMessages AS (
SELECT
m.id,
m.conversation_id AS conversationId,
m.content_type AS contentType,
m.creation_date AS date,
m.sender_user_id AS senderUserId,
(m.expire_after_millis IS NOT NULL) AS isSelfDelete,
u.name AS senderName,
u.preview_asset_id AS senderPreviewAssetId,
c.name AS conversationName,
tc.text_body AS text,
tc.is_quoting_self AS isQuotingSelf,
ac.asset_mime_type AS assetMimeType,
c.muted_status AS mutedStatus,
c.type AS conversationType,
c.degraded_conversation_notified AS degradedConversationNotified,
c.legal_hold_status AS legalHoldStatus,
IFNULL(lhs.legal_hold_status_change_notified, 1) == 1 AS legalHoldStatusChangeNotified,
row_num
FROM
Message m
JOIN
User u ON m.sender_user_id = u.qualified_id
JOIN
Conversation c ON m.conversation_id = c.qualified_id
LEFT JOIN
ConversationLegalHoldStatusChangeNotified AS lhs ON m.conversation_id == lhs.conversation_id AND (m.creation_date > IFNULL(c.last_notified_date, 0))
LEFT JOIN
MessageAssetContent ac ON m.id = ac.message_id AND m.conversation_id = ac.conversation_id
LEFT JOIN
MessageTextContent tc ON m.id = tc.message_id AND m.conversation_id = tc.conversation_id
WHERE
m.visibility = 'VISIBLE' AND
m.content_type IN ('TEXT', 'RESTRICTED_ASSET', 'ASSET', 'KNOCK', 'MISSED_CALL', 'LOCATION') AND
m.creation_date > COALESCE(c.last_notified_date, 0) AND
NOT EXISTS (SELECT 1 FROM SelfUser WHERE id = m.sender_user_id) AND
c.muted_status != 'ALL_MUTED' AND
c.archived = 0
)
SELECT
id,
conversationId,
contentType,
date,
senderUserId,
isSelfDelete,
senderName,
senderPreviewAssetId,
conversationName,
text,
isQuotingSelf,
assetMimeType,
mutedStatus,
conversationType,
degradedConversationNotified,
legalHoldStatus,
legalHoldStatusChangeNotified
FROM
NumberedMessages
WHERE
row_num <= 10 -- there is a bug in sqldelight where you can't use a parameter here
ORDER BY
date DESC
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(Native Method)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:592)
at net.zetetic.database.sqlcipher.SQLiteProgram.<init>(SQLiteProgram.java:64)
at net.zetetic.database.sqlcipher.SQLiteQuery.<init>(SQLiteQuery.java:43)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1168)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1159)
at app.cash.sqldelight.driver.android.AndroidQuery.executeQuery(AndroidSqliteDriver.kt:306)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.execute-zeHU3Mk(AndroidSqliteDriver.kt:169)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery-0yMERmw(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery(AndroidSqliteDriver.kt:29)
at app.cash.sqldelight.SimpleQuery.execute(Query.kt:98)
at app.cash.sqldelight.ExecutableQuery.executeAsList(Query.kt:174)
at com.wire.kalium.persistence.dao.message.MessageDAOImpl$getNotificationMessage$2.invokeSuspend(MessageDAOImpl.kt:302)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693)

Check warning on line 0 in com.wire.kalium.persistence.dao.message.MessageNotificationsTest

See this annotation in the file changed.

@github-actions github-actions / Test Results

givenConversation_whenNoLegalHoldNotified_thenNotificationIsPresent (com.wire.kalium.persistence.dao.message.MessageNotificationsTest) failed 

persistence/build/outputs/androidTest-results/connected/debug/TEST-emulator-5554 - 12-_persistence-.xml [took 0s]
Raw output 
android.database.sqlite.SQLiteException: no such column: row_num (code 1): , while compiling: WITH NumberedMessages AS (
SELECT
m.id,
m.conversation_id AS conversationId,
m.content_type AS contentType,
m.creation_date AS date,
m.sender_user_id AS senderUserId,
(m.expire_after_millis IS NOT NULL) AS isSelfDelete,
u.name AS senderName,
u.preview_asset_id AS senderPreviewAssetId,
c.name AS conversationName,
tc.text_body AS text,
tc.is_quoting_self AS isQuotingSelf,
ac.asset_mime_type AS assetMimeType,
c.muted_status AS mutedStatus,
c.type AS conversationType,
c.degraded_conversation_notified AS degradedConversationNotified,
c.legal_hold_status AS legalHoldStatus,
IFNULL(lhs.legal_hold_status_change_notified, 1) == 1 AS legalHoldStatusChangeNotified,
row_num
FROM
Message m
JOIN
User u ON m.sender_user_id = u.qualified_id
JOIN
Conversation c ON m.conversation_id = c.qualified_id
LEFT JOIN
ConversationLegalHoldStatusChangeNotified AS lhs ON m.conversation_id == lhs.conversation_id AND (m.creation_date > IFNULL(c.last_notified_date, 0))
LEFT JOIN
MessageAssetContent ac ON m.id = ac.message_id AND m.conversation_id = ac.conversation_id
LEFT JOIN
MessageTextContent tc ON m.id = tc.message_id AND m.conversation_id = tc.conversation_id
WHERE
m.visibility = 'VISIBLE' AND
m.content_type IN ('TEXT', 'RESTRICTED_ASSET', 'ASSET', 'KNOCK', 'MISSED_CALL', 'LOCATION') AND
m.creation_date > COALESCE(c.last_notified_date, 0) AND
NOT EXISTS (SELECT 1 FROM SelfUser WHERE id = m.sender_user_id) AND
c.muted_status != 'ALL_MUTED' AND
c.archived = 0
)
SELECT
id,
conversationId,
contentType,
date,
senderUserId,
isSelfDelete,
senderName,
senderPreviewAssetId,
conversationName,
text,
isQuotingSelf,
assetMimeType,
mutedStatus,
conversationType,
degradedConversationNotified,
legalHoldStatus,
legalHoldStatusChangeNotified
FROM
NumberedMessages
WHERE
row_num <= 10 -- there is a bug in sqldelight where you can't use a parameter here
ORDER BY
date DESC
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(Native Method)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:592)
at net.zetetic.database.sqlcipher.SQLiteProgram.<init>(SQLiteProgram.java:64)
at net.zetetic.database.sqlcipher.SQLiteQuery.<init>(SQLiteQuery.java:43)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1168)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1159)
at app.cash.sqldelight.driver.android.AndroidQuery.executeQuery(AndroidSqliteDriver.kt:306)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.execute-zeHU3Mk(AndroidSqliteDriver.kt:169)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery-0yMERmw(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery(AndroidSqliteDriver.kt:29)
at app.cash.sqldelight.SimpleQuery.execute(Query.kt:98)
at app.cash.sqldelight.ExecutableQuery.executeAsList(Query.kt:174)
at com.wire.kalium.persistence.dao.message.MessageDAOImpl$getNotificationMessage$2.invokeSuspend(MessageDAOImpl.kt:302)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693)

Check warning on line 0 in com.wire.kalium.persistence.dao.message.MessageNotificationsTest

See this annotation in the file changed.

@github-actions github-actions / Test Results

givenConversationIsArchived_whenMessageInserted_thenDoNotNotify (com.wire.kalium.persistence.dao.message.MessageNotificationsTest) failed 

persistence/build/outputs/androidTest-results/connected/debug/TEST-emulator-5554 - 12-_persistence-.xml [took 0s]
Raw output 
android.database.sqlite.SQLiteException: no such column: row_num (code 1): , while compiling: WITH NumberedMessages AS (
SELECT
m.id,
m.conversation_id AS conversationId,
m.content_type AS contentType,
m.creation_date AS date,
m.sender_user_id AS senderUserId,
(m.expire_after_millis IS NOT NULL) AS isSelfDelete,
u.name AS senderName,
u.preview_asset_id AS senderPreviewAssetId,
c.name AS conversationName,
tc.text_body AS text,
tc.is_quoting_self AS isQuotingSelf,
ac.asset_mime_type AS assetMimeType,
c.muted_status AS mutedStatus,
c.type AS conversationType,
c.degraded_conversation_notified AS degradedConversationNotified,
c.legal_hold_status AS legalHoldStatus,
IFNULL(lhs.legal_hold_status_change_notified, 1) == 1 AS legalHoldStatusChangeNotified,
row_num
FROM
Message m
JOIN
User u ON m.sender_user_id = u.qualified_id
JOIN
Conversation c ON m.conversation_id = c.qualified_id
LEFT JOIN
ConversationLegalHoldStatusChangeNotified AS lhs ON m.conversation_id == lhs.conversation_id AND (m.creation_date > IFNULL(c.last_notified_date, 0))
LEFT JOIN
MessageAssetContent ac ON m.id = ac.message_id AND m.conversation_id = ac.conversation_id
LEFT JOIN
MessageTextContent tc ON m.id = tc.message_id AND m.conversation_id = tc.conversation_id
WHERE
m.visibility = 'VISIBLE' AND
m.content_type IN ('TEXT', 'RESTRICTED_ASSET', 'ASSET', 'KNOCK', 'MISSED_CALL', 'LOCATION') AND
m.creation_date > COALESCE(c.last_notified_date, 0) AND
NOT EXISTS (SELECT 1 FROM SelfUser WHERE id = m.sender_user_id) AND
c.muted_status != 'ALL_MUTED' AND
c.archived = 0
)
SELECT
id,
conversationId,
contentType,
date,
senderUserId,
isSelfDelete,
senderName,
senderPreviewAssetId,
conversationName,
text,
isQuotingSelf,
assetMimeType,
mutedStatus,
conversationType,
degradedConversationNotified,
legalHoldStatus,
legalHoldStatusChangeNotified
FROM
NumberedMessages
WHERE
row_num <= 10 -- there is a bug in sqldelight where you can't use a parameter here
ORDER BY
date DESC
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(Native Method)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:592)
at net.zetetic.database.sqlcipher.SQLiteProgram.<init>(SQLiteProgram.java:64)
at net.zetetic.database.sqlcipher.SQLiteQuery.<init>(SQLiteQuery.java:43)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1168)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1159)
at app.cash.sqldelight.driver.android.AndroidQuery.executeQuery(AndroidSqliteDriver.kt:306)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.execute-zeHU3Mk(AndroidSqliteDriver.kt:169)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery-0yMERmw(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery(AndroidSqliteDriver.kt:29)
at app.cash.sqldelight.SimpleQuery.execute(Query.kt:98)
at app.cash.sqldelight.ExecutableQuery.executeAsList(Query.kt:174)
at com.wire.kalium.persistence.dao.message.MessageDAOImpl$getNotificationMessage$2.invokeSuspend(MessageDAOImpl.kt:302)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693)

Check warning on line 0 in com.wire.kalium.persistence.dao.message.MessageNotificationsTest

See this annotation in the file changed.

@github-actions github-actions / Test Results

givenConversation_whenMessageNormalInserted_thenIsSelfDeleteFlagSetToFalse (com.wire.kalium.persistence.dao.message.MessageNotificationsTest) failed 

persistence/build/outputs/androidTest-results/connected/debug/TEST-emulator-5554 - 12-_persistence-.xml [took 0s]
Raw output 
android.database.sqlite.SQLiteException: no such column: row_num (code 1): , while compiling: WITH NumberedMessages AS (
SELECT
m.id,
m.conversation_id AS conversationId,
m.content_type AS contentType,
m.creation_date AS date,
m.sender_user_id AS senderUserId,
(m.expire_after_millis IS NOT NULL) AS isSelfDelete,
u.name AS senderName,
u.preview_asset_id AS senderPreviewAssetId,
c.name AS conversationName,
tc.text_body AS text,
tc.is_quoting_self AS isQuotingSelf,
ac.asset_mime_type AS assetMimeType,
c.muted_status AS mutedStatus,
c.type AS conversationType,
c.degraded_conversation_notified AS degradedConversationNotified,
c.legal_hold_status AS legalHoldStatus,
IFNULL(lhs.legal_hold_status_change_notified, 1) == 1 AS legalHoldStatusChangeNotified,
row_num
FROM
Message m
JOIN
User u ON m.sender_user_id = u.qualified_id
JOIN
Conversation c ON m.conversation_id = c.qualified_id
LEFT JOIN
ConversationLegalHoldStatusChangeNotified AS lhs ON m.conversation_id == lhs.conversation_id AND (m.creation_date > IFNULL(c.last_notified_date, 0))
LEFT JOIN
MessageAssetContent ac ON m.id = ac.message_id AND m.conversation_id = ac.conversation_id
LEFT JOIN
MessageTextContent tc ON m.id = tc.message_id AND m.conversation_id = tc.conversation_id
WHERE
m.visibility = 'VISIBLE' AND
m.content_type IN ('TEXT', 'RESTRICTED_ASSET', 'ASSET', 'KNOCK', 'MISSED_CALL', 'LOCATION') AND
m.creation_date > COALESCE(c.last_notified_date, 0) AND
NOT EXISTS (SELECT 1 FROM SelfUser WHERE id = m.sender_user_id) AND
c.muted_status != 'ALL_MUTED' AND
c.archived = 0
)
SELECT
id,
conversationId,
contentType,
date,
senderUserId,
isSelfDelete,
senderName,
senderPreviewAssetId,
conversationName,
text,
isQuotingSelf,
assetMimeType,
mutedStatus,
conversationType,
degradedConversationNotified,
legalHoldStatus,
legalHoldStatusChangeNotified
FROM
NumberedMessages
WHERE
row_num <= 10 -- there is a bug in sqldelight where you can't use a parameter here
ORDER BY
date DESC
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(Native Method)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:592)
at net.zetetic.database.sqlcipher.SQLiteProgram.<init>(SQLiteProgram.java:64)
at net.zetetic.database.sqlcipher.SQLiteQuery.<init>(SQLiteQuery.java:43)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1168)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1159)
at app.cash.sqldelight.driver.android.AndroidQuery.executeQuery(AndroidSqliteDriver.kt:306)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.execute-zeHU3Mk(AndroidSqliteDriver.kt:169)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery-0yMERmw(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery(AndroidSqliteDriver.kt:29)
at app.cash.sqldelight.SimpleQuery.execute(Query.kt:98)
at app.cash.sqldelight.ExecutableQuery.executeAsList(Query.kt:174)
at com.wire.kalium.persistence.dao.message.MessageDAOImpl$getNotificationMessage$2.invokeSuspend(MessageDAOImpl.kt:302)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693)

Check warning on line 0 in com.wire.kalium.persistence.dao.message.MessageNotificationsTest

See this annotation in the file changed.

@github-actions github-actions / Test Results

givenConversationWithMessages_whenConversationModifiedDateUpdated_thenNotificationNotAffected (com.wire.kalium.persistence.dao.message.MessageNotificationsTest) failed 

persistence/build/outputs/androidTest-results/connected/debug/TEST-emulator-5554 - 12-_persistence-.xml [took 0s]
Raw output 
android.database.sqlite.SQLiteException: no such column: row_num (code 1): , while compiling: WITH NumberedMessages AS (
SELECT
m.id,
m.conversation_id AS conversationId,
m.content_type AS contentType,
m.creation_date AS date,
m.sender_user_id AS senderUserId,
(m.expire_after_millis IS NOT NULL) AS isSelfDelete,
u.name AS senderName,
u.preview_asset_id AS senderPreviewAssetId,
c.name AS conversationName,
tc.text_body AS text,
tc.is_quoting_self AS isQuotingSelf,
ac.asset_mime_type AS assetMimeType,
c.muted_status AS mutedStatus,
c.type AS conversationType,
c.degraded_conversation_notified AS degradedConversationNotified,
c.legal_hold_status AS legalHoldStatus,
IFNULL(lhs.legal_hold_status_change_notified, 1) == 1 AS legalHoldStatusChangeNotified,
row_num
FROM
Message m
JOIN
User u ON m.sender_user_id = u.qualified_id
JOIN
Conversation c ON m.conversation_id = c.qualified_id
LEFT JOIN
ConversationLegalHoldStatusChangeNotified AS lhs ON m.conversation_id == lhs.conversation_id AND (m.creation_date > IFNULL(c.last_notified_date, 0))
LEFT JOIN
MessageAssetContent ac ON m.id = ac.message_id AND m.conversation_id = ac.conversation_id
LEFT JOIN
MessageTextContent tc ON m.id = tc.message_id AND m.conversation_id = tc.conversation_id
WHERE
m.visibility = 'VISIBLE' AND
m.content_type IN ('TEXT', 'RESTRICTED_ASSET', 'ASSET', 'KNOCK', 'MISSED_CALL', 'LOCATION') AND
m.creation_date > COALESCE(c.last_notified_date, 0) AND
NOT EXISTS (SELECT 1 FROM SelfUser WHERE id = m.sender_user_id) AND
c.muted_status != 'ALL_MUTED' AND
c.archived = 0
)
SELECT
id,
conversationId,
contentType,
date,
senderUserId,
isSelfDelete,
senderName,
senderPreviewAssetId,
conversationName,
text,
isQuotingSelf,
assetMimeType,
mutedStatus,
conversationType,
degradedConversationNotified,
legalHoldStatus,
legalHoldStatusChangeNotified
FROM
NumberedMessages
WHERE
row_num <= 10 -- there is a bug in sqldelight where you can't use a parameter here
ORDER BY
date DESC
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(Native Method)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:592)
at net.zetetic.database.sqlcipher.SQLiteProgram.<init>(SQLiteProgram.java:64)
at net.zetetic.database.sqlcipher.SQLiteQuery.<init>(SQLiteQuery.java:43)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1168)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1159)
at app.cash.sqldelight.driver.android.AndroidQuery.executeQuery(AndroidSqliteDriver.kt:306)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.execute-zeHU3Mk(AndroidSqliteDriver.kt:169)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery-0yMERmw(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery(AndroidSqliteDriver.kt:29)
at app.cash.sqldelight.SimpleQuery.execute(Query.kt:98)
at app.cash.sqldelight.ExecutableQuery.executeAsList(Query.kt:174)
at com.wire.kalium.persistence.dao.message.MessageDAOImpl$getNotificationMessage$2.invokeSuspend(MessageDAOImpl.kt:302)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693)

Check warning on line 0 in com.wire.kalium.persistence.dao.message.MessageNotificationsTest

See this annotation in the file changed.

@github-actions github-actions / Test Results

givenConversation_whenMessageSelfDeleteMessageInserted_thenIsSelfDeleteFlagSetToTrue (com.wire.kalium.persistence.dao.message.MessageNotificationsTest) failed 

persistence/build/outputs/androidTest-results/connected/debug/TEST-emulator-5554 - 12-_persistence-.xml [took 0s]
Raw output 
android.database.sqlite.SQLiteException: no such column: row_num (code 1): , while compiling: WITH NumberedMessages AS (
SELECT
m.id,
m.conversation_id AS conversationId,
m.content_type AS contentType,
m.creation_date AS date,
m.sender_user_id AS senderUserId,
(m.expire_after_millis IS NOT NULL) AS isSelfDelete,
u.name AS senderName,
u.preview_asset_id AS senderPreviewAssetId,
c.name AS conversationName,
tc.text_body AS text,
tc.is_quoting_self AS isQuotingSelf,
ac.asset_mime_type AS assetMimeType,
c.muted_status AS mutedStatus,
c.type AS conversationType,
c.degraded_conversation_notified AS degradedConversationNotified,
c.legal_hold_status AS legalHoldStatus,
IFNULL(lhs.legal_hold_status_change_notified, 1) == 1 AS legalHoldStatusChangeNotified,
row_num
FROM
Message m
JOIN
User u ON m.sender_user_id = u.qualified_id
JOIN
Conversation c ON m.conversation_id = c.qualified_id
LEFT JOIN
ConversationLegalHoldStatusChangeNotified AS lhs ON m.conversation_id == lhs.conversation_id AND (m.creation_date > IFNULL(c.last_notified_date, 0))
LEFT JOIN
MessageAssetContent ac ON m.id = ac.message_id AND m.conversation_id = ac.conversation_id
LEFT JOIN
MessageTextContent tc ON m.id = tc.message_id AND m.conversation_id = tc.conversation_id
WHERE
m.visibility = 'VISIBLE' AND
m.content_type IN ('TEXT', 'RESTRICTED_ASSET', 'ASSET', 'KNOCK', 'MISSED_CALL', 'LOCATION') AND
m.creation_date > COALESCE(c.last_notified_date, 0) AND
NOT EXISTS (SELECT 1 FROM SelfUser WHERE id = m.sender_user_id) AND
c.muted_status != 'ALL_MUTED' AND
c.archived = 0
)
SELECT
id,
conversationId,
contentType,
date,
senderUserId,
isSelfDelete,
senderName,
senderPreviewAssetId,
conversationName,
text,
isQuotingSelf,
assetMimeType,
mutedStatus,
conversationType,
degradedConversationNotified,
legalHoldStatus,
legalHoldStatusChangeNotified
FROM
NumberedMessages
WHERE
row_num <= 10 -- there is a bug in sqldelight where you can't use a parameter here
ORDER BY
date DESC
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(Native Method)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:592)
at net.zetetic.database.sqlcipher.SQLiteProgram.<init>(SQLiteProgram.java:64)
at net.zetetic.database.sqlcipher.SQLiteQuery.<init>(SQLiteQuery.java:43)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1168)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1159)
at app.cash.sqldelight.driver.android.AndroidQuery.executeQuery(AndroidSqliteDriver.kt:306)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.execute-zeHU3Mk(AndroidSqliteDriver.kt:169)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery-0yMERmw(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery(AndroidSqliteDriver.kt:29)
at app.cash.sqldelight.SimpleQuery.execute(Query.kt:98)
at app.cash.sqldelight.ExecutableQuery.executeAsList(Query.kt:174)
at com.wire.kalium.persistence.dao.message.MessageDAOImpl$getNotificationMessage$2.invokeSuspend(MessageDAOImpl.kt:302)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693)

Check warning on line 0 in com.wire.kalium.persistence.dao.message.MessageNotificationsTest

See this annotation in the file changed.

@github-actions github-actions / Test Results

givenMutedConversation_whenNewMessageInserted_thenNotificationEmpty (com.wire.kalium.persistence.dao.message.MessageNotificationsTest) failed 

persistence/build/outputs/androidTest-results/connected/debug/TEST-emulator-5554 - 12-_persistence-.xml [took 0s]
Raw output 
android.database.sqlite.SQLiteException: no such column: row_num (code 1): , while compiling: WITH NumberedMessages AS (
SELECT
m.id,
m.conversation_id AS conversationId,
m.content_type AS contentType,
m.creation_date AS date,
m.sender_user_id AS senderUserId,
(m.expire_after_millis IS NOT NULL) AS isSelfDelete,
u.name AS senderName,
u.preview_asset_id AS senderPreviewAssetId,
c.name AS conversationName,
tc.text_body AS text,
tc.is_quoting_self AS isQuotingSelf,
ac.asset_mime_type AS assetMimeType,
c.muted_status AS mutedStatus,
c.type AS conversationType,
c.degraded_conversation_notified AS degradedConversationNotified,
c.legal_hold_status AS legalHoldStatus,
IFNULL(lhs.legal_hold_status_change_notified, 1) == 1 AS legalHoldStatusChangeNotified,
row_num
FROM
Message m
JOIN
User u ON m.sender_user_id = u.qualified_id
JOIN
Conversation c ON m.conversation_id = c.qualified_id
LEFT JOIN
ConversationLegalHoldStatusChangeNotified AS lhs ON m.conversation_id == lhs.conversation_id AND (m.creation_date > IFNULL(c.last_notified_date, 0))
LEFT JOIN
MessageAssetContent ac ON m.id = ac.message_id AND m.conversation_id = ac.conversation_id
LEFT JOIN
MessageTextContent tc ON m.id = tc.message_id AND m.conversation_id = tc.conversation_id
WHERE
m.visibility = 'VISIBLE' AND
m.content_type IN ('TEXT', 'RESTRICTED_ASSET', 'ASSET', 'KNOCK', 'MISSED_CALL', 'LOCATION') AND
m.creation_date > COALESCE(c.last_notified_date, 0) AND
NOT EXISTS (SELECT 1 FROM SelfUser WHERE id = m.sender_user_id) AND
c.muted_status != 'ALL_MUTED' AND
c.archived = 0
)
SELECT
id,
conversationId,
contentType,
date,
senderUserId,
isSelfDelete,
senderName,
senderPreviewAssetId,
conversationName,
text,
isQuotingSelf,
assetMimeType,
mutedStatus,
conversationType,
degradedConversationNotified,
legalHoldStatus,
legalHoldStatusChangeNotified
FROM
NumberedMessages
WHERE
row_num <= 10 -- there is a bug in sqldelight where you can't use a parameter here
ORDER BY
date DESC
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(Native Method)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:592)
at net.zetetic.database.sqlcipher.SQLiteProgram.<init>(SQLiteProgram.java:64)
at net.zetetic.database.sqlcipher.SQLiteQuery.<init>(SQLiteQuery.java:43)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1168)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1159)
at app.cash.sqldelight.driver.android.AndroidQuery.executeQuery(AndroidSqliteDriver.kt:306)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.execute-zeHU3Mk(AndroidSqliteDriver.kt:169)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery-0yMERmw(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery(AndroidSqliteDriver.kt:29)
at app.cash.sqldelight.SimpleQuery.execute(Query.kt:98)
at app.cash.sqldelight.ExecutableQuery.executeAsList(Query.kt:174)
at com.wire.kalium.persistence.dao.message.MessageDAOImpl$getNotificationMessage$2.invokeSuspend(MessageDAOImpl.kt:302)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693)

Check warning on line 0 in com.wire.kalium.persistence.dao.message.MessageNotificationsTest

See this annotation in the file changed.

@github-actions github-actions / Test Results

givenConversation_whenMessageWithReplyOnMyMessageInserted_thenNotificationMarkedAsReply (com.wire.kalium.persistence.dao.message.MessageNotificationsTest) failed 

persistence/build/outputs/androidTest-results/connected/debug/TEST-emulator-5554 - 12-_persistence-.xml [took 0s]
Raw output 
android.database.sqlite.SQLiteException: no such column: row_num (code 1): , while compiling: WITH NumberedMessages AS (
SELECT
m.id,
m.conversation_id AS conversationId,
m.content_type AS contentType,
m.creation_date AS date,
m.sender_user_id AS senderUserId,
(m.expire_after_millis IS NOT NULL) AS isSelfDelete,
u.name AS senderName,
u.preview_asset_id AS senderPreviewAssetId,
c.name AS conversationName,
tc.text_body AS text,
tc.is_quoting_self AS isQuotingSelf,
ac.asset_mime_type AS assetMimeType,
c.muted_status AS mutedStatus,
c.type AS conversationType,
c.degraded_conversation_notified AS degradedConversationNotified,
c.legal_hold_status AS legalHoldStatus,
IFNULL(lhs.legal_hold_status_change_notified, 1) == 1 AS legalHoldStatusChangeNotified,
row_num
FROM
Message m
JOIN
User u ON m.sender_user_id = u.qualified_id
JOIN
Conversation c ON m.conversation_id = c.qualified_id
LEFT JOIN
ConversationLegalHoldStatusChangeNotified AS lhs ON m.conversation_id == lhs.conversation_id AND (m.creation_date > IFNULL(c.last_notified_date, 0))
LEFT JOIN
MessageAssetContent ac ON m.id = ac.message_id AND m.conversation_id = ac.conversation_id
LEFT JOIN
MessageTextContent tc ON m.id = tc.message_id AND m.conversation_id = tc.conversation_id
WHERE
m.visibility = 'VISIBLE' AND
m.content_type IN ('TEXT', 'RESTRICTED_ASSET', 'ASSET', 'KNOCK', 'MISSED_CALL', 'LOCATION') AND
m.creation_date > COALESCE(c.last_notified_date, 0) AND
NOT EXISTS (SELECT 1 FROM SelfUser WHERE id = m.sender_user_id) AND
c.muted_status != 'ALL_MUTED' AND
c.archived = 0
)
SELECT
id,
conversationId,
contentType,
date,
senderUserId,
isSelfDelete,
senderName,
senderPreviewAssetId,
conversationName,
text,
isQuotingSelf,
assetMimeType,
mutedStatus,
conversationType,
degradedConversationNotified,
legalHoldStatus,
legalHoldStatusChangeNotified
FROM
NumberedMessages
WHERE
row_num <= 10 -- there is a bug in sqldelight where you can't use a parameter here
ORDER BY
date DESC
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(Native Method)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:592)
at net.zetetic.database.sqlcipher.SQLiteProgram.<init>(SQLiteProgram.java:64)
at net.zetetic.database.sqlcipher.SQLiteQuery.<init>(SQLiteQuery.java:43)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1168)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1159)
at app.cash.sqldelight.driver.android.AndroidQuery.executeQuery(AndroidSqliteDriver.kt:306)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.execute-zeHU3Mk(AndroidSqliteDriver.kt:169)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery-0yMERmw(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery(AndroidSqliteDriver.kt:29)
at app.cash.sqldelight.SimpleQuery.execute(Query.kt:98)
at app.cash.sqldelight.ExecutableQuery.executeAsList(Query.kt:174)
at com.wire.kalium.persistence.dao.message.MessageDAOImpl$getNotificationMessage$2.invokeSuspend(MessageDAOImpl.kt:302)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693)

Check warning on line 0 in com.wire.kalium.persistence.dao.message.MessageNotificationsTest

See this annotation in the file changed.

@github-actions github-actions / Test Results

givenConversationLastNotifiedDateIsNull_whenNewMessageInserted_thenNotificationPropagated (com.wire.kalium.persistence.dao.message.MessageNotificationsTest) failed 

persistence/build/outputs/androidTest-results/connected/debug/TEST-emulator-5554 - 12-_persistence-.xml [took 0s]
Raw output 
android.database.sqlite.SQLiteException: no such column: row_num (code 1): , while compiling: WITH NumberedMessages AS (
SELECT
m.id,
m.conversation_id AS conversationId,
m.content_type AS contentType,
m.creation_date AS date,
m.sender_user_id AS senderUserId,
(m.expire_after_millis IS NOT NULL) AS isSelfDelete,
u.name AS senderName,
u.preview_asset_id AS senderPreviewAssetId,
c.name AS conversationName,
tc.text_body AS text,
tc.is_quoting_self AS isQuotingSelf,
ac.asset_mime_type AS assetMimeType,
c.muted_status AS mutedStatus,
c.type AS conversationType,
c.degraded_conversation_notified AS degradedConversationNotified,
c.legal_hold_status AS legalHoldStatus,
IFNULL(lhs.legal_hold_status_change_notified, 1) == 1 AS legalHoldStatusChangeNotified,
row_num
FROM
Message m
JOIN
User u ON m.sender_user_id = u.qualified_id
JOIN
Conversation c ON m.conversation_id = c.qualified_id
LEFT JOIN
ConversationLegalHoldStatusChangeNotified AS lhs ON m.conversation_id == lhs.conversation_id AND (m.creation_date > IFNULL(c.last_notified_date, 0))
LEFT JOIN
MessageAssetContent ac ON m.id = ac.message_id AND m.conversation_id = ac.conversation_id
LEFT JOIN
MessageTextContent tc ON m.id = tc.message_id AND m.conversation_id = tc.conversation_id
WHERE
m.visibility = 'VISIBLE' AND
m.content_type IN ('TEXT', 'RESTRICTED_ASSET', 'ASSET', 'KNOCK', 'MISSED_CALL', 'LOCATION') AND
m.creation_date > COALESCE(c.last_notified_date, 0) AND
NOT EXISTS (SELECT 1 FROM SelfUser WHERE id = m.sender_user_id) AND
c.muted_status != 'ALL_MUTED' AND
c.archived = 0
)
SELECT
id,
conversationId,
contentType,
date,
senderUserId,
isSelfDelete,
senderName,
senderPreviewAssetId,
conversationName,
text,
isQuotingSelf,
assetMimeType,
mutedStatus,
conversationType,
degradedConversationNotified,
legalHoldStatus,
legalHoldStatusChangeNotified
FROM
NumberedMessages
WHERE
row_num <= 10 -- there is a bug in sqldelight where you can't use a parameter here
ORDER BY
date DESC
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(Native Method)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:592)
at net.zetetic.database.sqlcipher.SQLiteProgram.<init>(SQLiteProgram.java:64)
at net.zetetic.database.sqlcipher.SQLiteQuery.<init>(SQLiteQuery.java:43)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1168)
at net.zetetic.database.sqlcipher.SQLiteDatabase.query(SQLiteDatabase.java:1159)
at app.cash.sqldelight.driver.android.AndroidQuery.executeQuery(AndroidSqliteDriver.kt:306)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver$executeQuery$2.invoke(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.execute-zeHU3Mk(AndroidSqliteDriver.kt:169)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery-0yMERmw(AndroidSqliteDriver.kt:192)
at app.cash.sqldelight.driver.android.AndroidSqliteDriver.executeQuery(AndroidSqliteDriver.kt:29)
at app.cash.sqldelight.SimpleQuery.execute(Query.kt:98)
at app.cash.sqldelight.ExecutableQuery.executeAsList(Query.kt:174)
at com.wire.kalium.persistence.dao.message.MessageDAOImpl$getNotificationMessage$2.invokeSuspend(MessageDAOImpl.kt:302)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693)
View more details on GitHub Actions