mirror of
https://github.com/clockworklabs/SpacetimeDB.git
synced 2026-05-26 17:42:04 -04:00
Tyler Cloutier
53 lines
799 B
Plaintext
53 lines
799 B
Plaintext
include ./test_data.slt
|
|
|
|
query IT rowsort
|
|
select * from inventory
|
|
----
|
|
1 'health1'
|
|
2 'health2'
|
|
3 'health3'
|
|
|
|
query IT rowsort
|
|
select inventory.* from inventory
|
|
----
|
|
1 'health1'
|
|
2 'health2'
|
|
3 'health3'
|
|
|
|
|
|
query I rowsort
|
|
select 1 from inventory
|
|
----
|
|
1
|
|
1
|
|
1
|
|
|
|
query IT rowsort
|
|
select * from inventory WHERE inventory_id = 1
|
|
----
|
|
1 'health1'
|
|
|
|
#Cheking using table identifiers
|
|
query TI
|
|
select name, inventory.inventory_id from inventory WHERE inventory_id = 1
|
|
----
|
|
'health1' 1
|
|
|
|
query I
|
|
SELECT inventory.inventory_id FROM inventory WHERE inventory.inventory_id = 1
|
|
----
|
|
1
|
|
|
|
query TI
|
|
select name, inventory_id from inventory WHERE inventory_id = 1
|
|
----
|
|
'health1' 1
|
|
|
|
|
|
query TI
|
|
select (name), (inventory_id) FROM inventory WHERE inventory_id = 1
|
|
----
|
|
'health1' 1
|
|
|
|
# TODO: Using expressions like inventory_id + 1
|