Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Tracking: enable Sqllogictest tests in Sqlite #5997

Open
13 tasks
lmatz opened this issue Oct 24, 2022 · 3 comments
Open
13 tasks

Tracking: enable Sqllogictest tests in Sqlite #5997

lmatz opened this issue Oct 24, 2022 · 3 comments
Assignees
@lmatz
Labels
component/test Test related issue. type/feature type/tracking Tracking issue.

Comments

@lmatz
Copy link
Contributor

lmatz commented Oct 24, 2022 •
edited
Loading

Check https://github.com/risingwavelabs/sqlite-sqllogictest/tree/main/test for test cases.
@github-actions github-actions bot added this to the release-0.1.14 milestone Oct 24, 2022
@lmatz lmatz added help wanted Issues that need help from contributors component/test Test related issue. type/tracking Tracking issue. stage/Beta labels Oct 24, 2022
@lmatz lmatz mentioned this issue Oct 24, 2022
Open
4 tasks
@lmatz lmatz modified the milestones: release-0.1.14, release-0.1.15 Nov 21, 2022
@lmatz lmatz removed the help wanted Issues that need help from contributors label Nov 23, 2022
@xxchan
Copy link
Member

xxchan commented Dec 7, 2022

One note: sqlite's default ordering is ASC NULLS FIRST (We havn't implemented it yet #4743), while pg's is ASC NULLS LAST.

@fuyufjh fuyufjh removed this from the release-0.1.15 milestone Dec 19, 2022
@xxchan
Copy link
Member

xxchan commented Dec 19, 2022

One note: sqlite's test files are quite large (1G). Don't check in it to our repo. 🥸

@xxchan
Copy link
Member

xxchan commented Dec 19, 2022

/random and /index are large. Others are OK

  650.0 MiB /random
  413.2 MiB /index
    1.1 MiB select4.test
  836.0 KiB select3.test
  688.0 KiB select5.test
  252.0 KiB select1.test
  236.0 KiB select2.test
   84.0 KiB /evidence

@xxchan xxchan removed the stage/Beta label Oct 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@lmatz lmatz

Labels
component/test Test related issue. type/feature type/tracking Tracking issue.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@lmatz @fuyufjh @xxchan