Bug: sql-server fails with TablePlus while introspecting schema due to UUID

josh-chamberlain commented 3 years ago

A recording of this happening: https://recordit.co/PIZauTONtT

Conversation in Discord:

The repo: https://www.dolthub.com/repositories/pdap/data-intake

The offending UUID: https://www.dolthub.com/repositories/pdap/data-intake/query/master?q=describe+incident_reports&active=Tables

The log:

TRACE: received query SELECT table_name as table_name,column_name as column_name,column_type as column_type FROM information_schema.columns WHERE table_schema='data_intake'AND data_type='enum'
DEBUG: executing query
panic: function: 'uuid' not found

The settings:

The config.yaml:

log_level: trace

behavior:
    read_only: false
    autocommit: true

user:
    name: root
    password: ""

listener:
    host: 127.0.0.1
    port: 12000
    max_connections: 1
    read_timeout_millis: 28800000
    write_timeout_millis: 28800000

databases: []

performance:
  query_parallelism: null

VinaiRachakonda commented 3 years ago

@josh-chamberlain What version of Dolt are you using? I'm currently unable to reproduce the bug. The UUID function should definitely exist

josh-chamberlain commented 3 years ago

Thanks for having a look @VinaiRachakonda ! dolt version 0.26.1

josh-chamberlain commented 3 years ago

Notably I ran brew upgrade dolt moments before attempting this 👀

VinaiRachakonda commented 3 years ago

@josh-chamberlain I tried the query that errored as well and the version number you are using and I can't reproduce. Would it be possible to reclone your repo and trying again? The full log would be great as well.

Thank you!

josh-chamberlain commented 3 years ago

@VinaiRachakonda this resolved after recloning the repo. Thank you for taking a look—closing for now.

dolthub / dolt

Bug: sql-server fails with TablePlus while introspecting schema due to UUID #1662