# SQLite.load! fails for temp tables?

**URL:** https://discourse.julialang.org/t/sqlite-load-fails-for-temp-tables/73886
**Category:** New to Julia
**Created:** [January 1, 2022, 12:34am UTC](https://discourse.julialang.org/t/sqlite-load-fails-for-temp-tables/73886 "2022-01-01T00:34:31Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![freeman](https://avatars.discourse-cdn.com/v4/letter/f/ec9cab/32.png) [@freeman](https://discourse.julialang.org/u/freeman)
#### Post date: [January 1, 2022, 12:34am UTC](https://discourse.julialang.org/t/sqlite-load-fails-for-temp-tables/73886/1 "2022-01-01T00:34:31Z")

</div>

This is not a big deal, but I was surprised that the following doesn’t work for temp tables:

```julia
x = [(a=1, b=2), (a=3, b=4)];
db = SQLite.DB()
table_name = x |> SQLite.load!(db; temp=true)

```

Throws

```julia
ERROR: SQLiteException("no such table: sqlitejl_ymYTz")

```

To me it’s unexpected that a `temp=true` exists which also goes alongside with omiting a table name (as per docs), but at the same time throws “no such table”. Am I missing something?