© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•14mo ago•
21 replies
Hong

Failure in simple db test

I was following the db test instructions. I simply did
superbase test db
superbase test db


public.Feedback is a db table I set up on the supabase.com

begin;
select plan(1); 

-- Test for existence of required columns
SELECT has_column(
    'public',
    'Feedback',
    'id',
    'id column should exist'
);

select * from finish();
rollback;
begin;
select plan(1); 

-- Test for existence of required columns
SELECT has_column(
    'public',
    'Feedback',
    'id',
    'id column should exist'
);

select * from finish();
rollback;


I got this failure message,

WARN: no seed files matched pattern: supabase/seed.sql
Connecting to local database...
./database/feedback.test.sql .. 
# Failed test 1: "id column should exist"
# Looks like you failed 1 test of 1
Failed 1/1 subtests 

Test Summary Report
-------------------
./database/feedback.test.sql (Wstat: 0 Tests: 1 Failed: 1)
  Failed test:  1
Files=1, Tests=1,  0 wallclock secs ( 0.00 usr +  0.00 sys =  0.00 CPU)
Result: FAIL
error running container: exit 1
Try rerunning the command with --debug to troubleshoot the error.
WARN: no seed files matched pattern: supabase/seed.sql
Connecting to local database...
./database/feedback.test.sql .. 
# Failed test 1: "id column should exist"
# Looks like you failed 1 test of 1
Failed 1/1 subtests 

Test Summary Report
-------------------
./database/feedback.test.sql (Wstat: 0 Tests: 1 Failed: 1)
  Failed test:  1
Files=1, Tests=1,  0 wallclock secs ( 0.00 usr +  0.00 sys =  0.00 CPU)
Result: FAIL
error running container: exit 1
Try rerunning the command with --debug to troubleshoot the error.


Is it that I cannot test against the online table, but I must use a local table? or any other reasons?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

DB Push Connection Failure
SupabaseSSupabase / help-and-questions
6mo ago
Prisma failure on DB crud
SupabaseSSupabase / help-and-questions
5mo ago
Dynamic supabase db test --db-url with preview branches?
SupabaseSSupabase / help-and-questions
13mo ago
Setting up a dev/test DB
SupabaseSSupabase / help-and-questions
3mo ago