java.lang.IllegalArgumentException: There is no table with name 'order' [72366965]

Fixed

Bug

Status Update

No update yet.

Description

do...@gmail.com

created issue #1

Jan 23, 2018 04:28PM

Component used: Room Database
Version used: 1.0.0

Hi
I'm facing this crash when I try to use LiveData:
java.lang.IllegalArgumentException: There is no table with name 'order'

This is the query code:
@Query("SELECT * FROM 'order' ORDER BY createdAt ASC")
LiveData<List<Order>> getLiveData();

When I use this query code everything works fine:
@Query("SELECT * FROM address WHERE addressStatus <> 'DELETE'")
LiveData<List<Address>> getAll();

When I use others queries with 'order' in the query it works too.
I just started using LiveData and the reserverd word 'order' isn´t working in this case.

Comments

do...@gmail.com <do...@gmail.com> #2Jan 25, 2018 01:54PM

since these are in public API (:/) we need to do this in 1.2

yb...@google.com <yb...@google.com> #3Jan 25, 2018 06:17PM

Assigned to yb...@google.com.

since it is already marked as deprecated, we can probably do it by now.

do...@gmail.com <do...@gmail.com> #4Jan 29, 2018 04:33PM

Opening diff shortly

yb...@google.com <yb...@google.com> #5Feb 8, 2018 10:47PM

Project: platform/frameworks/support
Branch: androidx-master-dev

commit d576cbdc911cba16638a44fd8223391a90a07ef7
Author: Mike Nakhimovich <digitalbuddha@users.noreply.github.com>
Date: Tue Aug 11 09:30:34 2020

[GH] Hide deprecated internal API.

## Proposed Changes

* `RoomDatabase.java` has protected `mCallbacks` field which is leaking in the API docs, we should @Hide it.

## Testing

Test: Ran unit tests locally

## Issues Fixed

Fixes: 76109329

This is an imported pull request from

https://github.com/androidx/androidx/pull/61.

Resolves #61
Github-Pr-Head-Sha: 6440daa3a63752c7f9d5ba2a390248cd85bc634f
GitOrigin-RevId: fe92d8466a59b44b218b6ca3cbd57dcda17992f7

Change-Id: Id599cdf5b02b32bdae0166266fb7da967598fe92

A room/runtime/api/current.ignore
M room/runtime/api/current.txt
M room/runtime/api/public_plus_experimental_current.txt
M room/runtime/api/restricted_current.txt
M room/runtime/src/main/java/androidx/room/RoomDatabase.java

https://android-review.googlesource.com/1396827

yb...@google.com <yb...@google.com> #6Feb 8, 2018 10:47PM

to be correct, we also currently escape `. ' was just missing.

do...@gmail.com <do...@gmail.com> #7Feb 9, 2018 12:35PM

Thanks!
I can survive using like this:
@Query("SELECT * FROM "order" ORDER BY createdAt ASC")

It worked!

yb...@google.com <yb...@google.com> #8Feb 13, 2018 12:06AM

Marked as fixed.

should go out in 1.1 alpha2