--- title: Doltgres Reaches 99% Compliance on SQL Logic Tests description: Doltgres, the version-controlled PostgreSQL-compatible database, has reached 99% compliance on its SQL Logic Test suite — a key milestone on the road to the... canonical: https://daily.dev/posts/doltgres-reaches-99-compliance-on-sql-logic-tests-hhnymgooh twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Doltgres Reaches 99% Compliance on SQL Logic Tests | daily.dev og:description: Doltgres, the version-controlled PostgreSQL-compatible database, has reached 99% compliance on its SQL Logic Test suite — a key milestone on the road to the... og:url: https://daily.dev/posts/doltgres-reaches-99-compliance-on-sql-logic-tests-hhnymgooh og:image: https://api.daily.dev/og/posts/HHNyMGooh.png og:image:alt: Doltgres Reaches 99% Compliance on SQL Logic Tests og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Doltgres Reaches 99% Compliance on SQL Logic Tests **[DoltHub Blog](https://daily.dev/sources/dolthub-blog)** · 6 min read · 0 upvotes · 0 comments ## Summary Doltgres, the version-controlled PostgreSQL-compatible database, has reached 99% compliance on its SQL Logic Test suite — a key milestone on the road to the Doltgres 1.0 release planned for August 6th. The team first established a baseline by running the test suite against stock PostgreSQL, discovering that many failures were due to SQLite/MySQL assumptions baked into the test runner rather than actual Doltgres bugs. Fixes included handling integer vs. float type differences, empty result sets, Postgres-specific type names, and MySQL-only statements. Parallelizing the test runner also dramatically reduced iteration time. The most notable real bug found was in the COALESCE() implementation, which was using incorrect type conversion for mixed numeric types instead of Postgres' assignment cast rules. With correctness now checked off, the team is on track for the August 6th 1.0 launch. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Doltgres 1.0 Coming August 6th](https://daily.dev/posts/doltgres-1-0-coming-august-6th-wyku1t2ei) · DoltHub Blog · 43 upvotes · 4 comments - [Doltgres 1.0](https://daily.dev/posts/doltgres-1-0-dnjnqean4) · DoltHub Blog · 13 upvotes · 2 comments - [One Week Out: Doltgres 1.0 Update](https://daily.dev/posts/one-week-out-doltgres-1-0-update-bm5g269fo) · DoltHub Blog · 10 upvotes · 2 comments --- Tags: [#testing](https://daily.dev/tags/testing), [#sql](https://daily.dev/tags/sql), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/doltgres-reaches-99-compliance-on-sql-logic-tests-hhnymgooh) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Doltgres Reaches 99% Compliance on SQL Logic Tests","url":"https://daily.dev/posts/doltgres-reaches-99-compliance-on-sql-logic-tests-hhnymgooh","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/doltgres-reaches-99-compliance-on-sql-logic-tests-hhnymgooh"},"datePublished":"2026-07-10T16:59:57.534Z","dateModified":"2026-07-10T17:00:18.248Z","description":"Doltgres, the version-controlled PostgreSQL-compatible database, has reached 99% compliance on its SQL Logic Test suite — a key milestone on the road to the...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/484316b585a6ae8b079f1b0ccc45aef9?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/484316b585a6ae8b079f1b0ccc45aef9?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"DoltHub Blog","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"DoltHub Blog","logo":"https://media.daily.dev/image/upload/s--LXDlvjS4--/f_auto,q_auto/v1780213587/logos/dolthub-blog?_a=BAMAMiWQ0","url":"https://daily.dev/sources/dolthub-blog"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/doltgres-reaches-99-compliance-on-sql-logic-tests-hhnymgooh","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"testing,sql,postgresql","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"DoltHub Blog","item":"https://daily.dev/sources/dolthub-blog"},{"@type":"ListItem","position":3,"name":"Doltgres Reaches 99% Compliance on SQL Logic Tests"}]} ```