search

timeseries / qstudio

qStudio - Free SQL Analysis Tool
https://www.timestored.com/qstudio/
Apache License 2.0
564 stars 25 forks source link

Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline #89

Closed richb-hanover closed 1 month ago

richb-hanover commented 1 month ago

Using qStudio 3.10 on macOS 12.7.5. I get this error when I first launch qStudio. I have a PRQL query (below) that auto-opens in the top pane. The Console also auto-opens.

To demonstrate the problem, click in the PRQL query, hit Cmd-/ to comment a line, and then again to uncomment, then hit Cmd-E to run the query. This gives the error message above. This is repeatable as many times as I like.

I can get rid of the error message by:

Then Cmd-E compiles the PRQL query and runs the SQL. If you want to test against the database, use Property_In_Lyme.sqlite

PRQL Query

# =======================================
# Generate a "CleanedScrapedData" SQL View that derives the following:
# - Select the current zoning data (SD_Version=14 as of 2024-03-13)
# - Tweak up the zoning districts 
#   - Correct Vision inconsistencies (ES,R,SFR,UFD,SD,etc => "RD" )
#   - Join with CorrectedZoningDistrict to add districts that Vision lacks
#   - Properties in Rural district with addresses on state roads 
#      get 3 acre minimum (Orford, Dorchester,
#      East & North Thetford, Dartmouth College Highway)
#   - ZDistrict is coded value (RD, LCD, etc.)
#   - RealDistrict is nice printable names 
# - Create StateRoad column
# - Join in the Exempt, muni and conservation easements
# - also include frontage values
# =======================================

prql target:sql.sqlite

# dollars displays a numeric value as dollars with commas
let dollars = d -> s"""printf("$%,d",{d})"""

# pct computes the amount (percent) the new differs from old
let pct = o n -> 100.0*( n - o ) / o

# prtpct prints a floating point number with "%"
let prtpct = v -> s'printf("%1.1f%", {v})'

# sig_fig - print a value with n decimal places
# inserts comma for thousands/millions 
let sig_fig = v n -> s"printf('%,1.{n}f', {v})"

# implement a "like" function in lieu of a regex
let like = fld str -> s"{fld} like '%' || {str} || '%' "

# isStateRoad == 1 if it's a state road
let isStateRoad = road -> case [
  (like road "ORFORD ") => 1,
  (like road "DARTMOUTH COLLEGE") => 1,
  (like road "DORCHESTER") => 1,
  (like road "THETFORD") => 1, # North Thetford and East Thetford
  true => 0,
]
# Clean up zoning districts
# Returns two or three character district
# or null if it's ""
let CleanZoningDistrict = zd -> case [
  zd == "ES" => "RD",
  zd == "R" => "RD",
  zd == "SFR" => "RD",
  zd == "URD" => "RD",
  zd == "SD" => "RD",
  zd == "LCD" => "LCD",
  zd == "CD" => "LCD",
  zd == "LDC" => "LCD",
  zd == "" => null,
  true => zd,
]
# SubDistrict distinguishes between on-state-road and not
# Take a two/three character district, return pleasing name
# Also might (but doesn't) distinguish between Lyme Center and Lyme Common
let SubDistrict = dist road -> case [
  dist == "RD" && road == 1 => "Rural-State Road",
  dist == "RD" && road == 0 => "Rural-Town Road",
  dist == "BD" => "Commercial",
  dist == "LCD" => "LymeCommon/Ctr",
  dist == "ELD" => "EastLyme",
  dist == "SKIWAY" => "Skiway",
  dist == "MFD" => "MtnForest",
  true => dist,
]

# ============ begin  query ==============

from sd=ScrapedData
filter SD_CollectedOn == '2024-07-15' # latest data
join side:left czd = CorrectedZoningDistrict (sd.SD_PID == czd.CZD_PID)
join side:left ef = EasementsFrontage(sd.SD_PID == ef.EF_PID)

derive { StateRoad = isStateRoad sd.SD_Street_Address }

# Fix zoning districts
# DistrictName distinguishes between on-state-road and not
derive { zd = CleanZoningDistrict sd.SD_Zoning_District }
derive { District =  zd ?? czd.CZD_Actual }
derive { DistrictName = SubDistrict District StateRoad }

select {
    PID=sd.SD_PID,
    Owner=sd.SD_Owner,
    Street_Address=sd.SD_Street_Address,
    MBLU=sd.SD_MBLU,
    Map=sd.SD_Map,
    Lot=sd.SD_Lot,
    Unit=sd.SD_Unit,
    Subunit=sd.SD_Subunit,
    Book_Page=sd.SD_Book_Page,
    Book=sd.SD_Book,
    Page=sd.SD_Page,
    Assessment=sd.SD_Assessment,
    Appraisal=sd.SD_Appraisal,
    Lot_Size=sd.SD_Lot_Size,
    Land_Use_Code=sd.SD_Land_Use_Code,
    Description=sd.SD_Description,
    #Zoning_District=sd.SD_Zoning_District,
    District,
    #ZDistrict,
    DistrictName,
    StateRoad,
    ef.EF_LotSize,
    ef.EF_Exempt,
    ef.EF_MuniEasement,
    ef.EF_ConsEasement, 
    ef.EF_Frontage,
    ef.EF_FrontSuffix,
    Num_Buildings=sd.SD_Num_Buildings,
    Recent_Sale_Price=sd.SD_Recent_Sale_Price,
    Recent_Sale_Date=sd.SD_Recent_Sale_Date,
    Prev_Sale_Price=sd.SD_Prev_Sale_Price,
    Prev_Sale_Date=sd.SD_Prev_Sale_Date,
    Ass_ImpCurr=sd.SD_Ass_ImpCurr,
    Ass_LandCurr=sd.SD_Ass_LandCurr,
    Ass_TotCurr=sd.SD_Ass_TotCurr,
    Ass_ImpPrev=sd.SD_Ass_ImpPrev,
    Ass_LandPrev=sd.SD_Ass_LandPrev,
    Ass_TotPrev=sd.SD_Ass_TotPrev,
    App_ImpCurr=sd.SD_App_ImpCurr,
    App_LandCurr=sd.SD_App_LandCurr,
    App_TotCurr=sd.SD_App_TotCurr,
    App_ImpPrev=sd.SD_App_ImpPrev,
    App_LandPrev=sd.SD_App_LandPrev,
    App_TotPrev=sd.SD_App_TotPrev,
    Version=sd.SD_Version,
    CollectedOn=sd.SD_CollectedOn,
}

sort { PID }
# Check for fixed-up districts
# filter (sd.SD_Zoning_District != ZDistrict)

Log file - the interesting exception is BEFORE the SQL code

Last login: Sat Sep 14 22:35:03 on ttys004
You have mail.
√ ~ % cd /Applications
√ /Applications % java -jar qstudio.jar
Sep 14, 2024 11:40:52 PM com.timestored.misc.DynamicClassLoader loadInstances
INFO: Searching for plugins in folder: /Users/richb/qstudio/libs
Sep 14, 2024 11:40:52 PM com.timestored.misc.DynamicClassLoader visitJarFileJavaClasses
INFO: Looking for plugins inside: /Users/richb/qstudio/libs/sqlite-jdbc-3.42.0.0.jar
Sep 14, 2024 11:40:52 PM com.timestored.misc.DynamicClassLoader loadInstances
INFO: Searching for plugins in folder: /Users/richb/qstudio/libs
Sep 14, 2024 11:40:52 PM com.timestored.misc.DynamicClassLoader visitJarFileJavaClasses
INFO: Looking for plugins inside: /Users/richb/qstudio/libs/sqlite-jdbc-3.42.0.0.jar
Sep 14, 2024 11:40:52 PM com.timestored.misc.DynamicClassLoader$InstanceFinderVisitor visit
INFO: Found Plugin with correct interface: org.sqlite.JDBC
Sep 14, 2024 11:40:52 PM com.timestored.qstudio.QStudioLauncher main
SEVERE: Could not load a plugin due to Unable to make protected void java.net.URLClassLoader.addURL(java.net.URL) accessible: module java.base does not "opens java.net" to unnamed module @40f9161a
/Applications
Sep 14, 2024 11:40:53 PM com.timestored.docs.OpenDocumentsModel addDocument
INFO: addDocument: new 1
Warning: the fonts "Times" and "Times" are not available for the Java logical font "Serif", which may have unexpected appearance or behavior. Re-enable the "Times" font to remove this warning.
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: Starting QStudioLauncher  launch() ###################################
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: version = 3.10
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: current dir = /Applications/.
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: PATH = /Users/richb/.local/bin:/Applications/Tools-Developer/Racket:/Users/richb/.pyenv/shims:/Users/richb/.pyenv/bin:/Users/richb/.deno/bin:/Users/richb/.pyenv/bin:/Users/richb/.nvm/versions/node/v20.9.0/bin:/Users/richb/.cargo/bin:/opt/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/Library/Apple/usr/bin:/Library/Apple/bin:/usr/libexec:/Applications/Tools-Developer/Racket/bin:/Users/richb/.rvm/bin
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: JAVA_HOME = null
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: java.version =16.0.1
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: os.name =Mac OS X
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: user.home =/Users/richb
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: user.dir =/Applications
Sep 14, 2024 11:40:55 PM com.timestored.connections.ConnectionManager reloadFromPreferences
WARNING: stored conns and current conns disagreed, using stored values
Sep 14, 2024 11:40:55 PM com.timestored.connections.ConnectionManager reloadFromPreferences
WARNING: serverConns = []
Sep 14, 2024 11:40:55 PM com.timestored.connections.ConnectionManager reloadFromPreferences
WARNING: sConns = [ServerConfig{name=\Users\richb\github\TaxFairness\Property_In_Lyme.sqlite, username=, host=localhost, port=0, cstoreType=SQLITE_JDBC, database=jdbc:sqlite:/Users/richb/github/TaxFairness/Property_In_Lyme.sqlite}]
SLF4J(W): No SLF4J providers were found.
SLF4J(W): Defaulting to no-operation (NOP) logger implementation
SLF4J(W): See https://www.slf4j.org/codes.html#noProviders for further details.
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.QStudioFrame <init>
INFO: Starting QStudioFrame Constructor
MODELS = 126.47598
Warning: the fonts "Times" and "Times" are not available for the Java logical font "Serif", which may have unexpected appearance or behavior. Re-enable the "Times" font to remove this warning.
Warning: the fonts "Times" and "Times" are not available for the Java logical font "Serif", which may have unexpected appearance or behavior. Re-enable the "Times" font to remove this warning.
Sep 14, 2024 11:40:55 PM com.timestored.swingxx.FileTreePanel refreshGui
INFO: FileTreePanel refreshGui
Sep 14, 2024 11:40:55 PM com.timestored.swingxx.FileTreePanel refreshGui
INFO: FileTreePanel refreshGui
Sep 14, 2024 11:40:55 PM com.timestored.qstudio.servertree.ServerListPanel refreshGui
INFO: refreshGui
Sep 14, 2024 11:40:55 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:40:56 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:40:56 PM com.timestored.swingxx.FileTreePanel refreshGui
INFO: FileTreePanel refreshGui
ENDER = 1189.735135
Sep 14, 2024 11:40:56 PM com.timestored.qstudio.model.AdminModel refresh
INFO: AdminModel hard Refresh
Sep 14, 2024 11:40:56 PM com.timestored.qstudio.QStudioFrame <init>
INFO: Finished QStudioFrame Constructor
Sep 14, 2024 11:40:56 PM com.timestored.qstudio.servertree.ServerListPanel refreshGui
INFO: refreshGui
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel setSelectedFolder
INFO: setSelectedFolder: null
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel addDocument
INFO: addDocument: new 2
Sep 14, 2024 11:40:56 PM com.timestored.docs.BackgroundDocumentsSaver restoreDocuments
INFO: attempting to restore existing known document
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel openDocument
INFO: openDocument: CleanScrapedDataView.prql
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel setSelectedDocument
INFO: setSelectedDocument: CleanScrapedDataView.prql
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel closeDocument
INFO: closeDocument: new 1
Sep 14, 2024 11:40:56 PM com.timestored.qstudio.QStudioLauncher$2 launch
INFO: Ending QStudioLauncher launch()
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel setSelectedDocument
INFO: setSelectedDocument: new 6
Sep 14, 2024 11:40:56 PM com.timestored.docs.OpenDocumentsModel setSelectedDocument
INFO: setSelectedDocument: CleanScrapedDataView.prql
Sep 14, 2024 11:40:56 PM com.timestored.plugins.PluginLoader getCClass
INFO: Could not find class already loaded. Refreshing from folders / jars.
Sep 14, 2024 11:40:57 PM com.timestored.connections.ConnectionManager statusUpdate
INFO: \Users\richb\github\TaxFairness\Property_In_Lyme.sqlite Connected = true
Sep 14, 2024 11:40:57 PM com.timestored.qstudio.servertree.ServerListPanel refreshGui
INFO: refreshGui
Sep 14, 2024 11:40:57 PM com.timestored.qstudio.model.AdminModel$2 run
INFO: refreshing \Users\richb\github\TaxFairness\Property_In_Lyme.sqlite
Sep 14, 2024 11:40:57 PM com.timestored.qstudio.servertree.ServerListPanel refreshGui
INFO: refreshGui
Sep 14, 2024 11:41:11 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main

    at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
    at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
    at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
    at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
    at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
    at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
    at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
    at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
    at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
    at java.desktop/javax.swing.JComponent.processKeyBindings(JComponent.java:2985)
    at java.desktop/javax.swing.JComponent.processKeyEvent(JComponent.java:2862)
    at java.desktop/java.awt.Component.processEvent(Component.java:6394)
    at java.desktop/java.awt.Container.processEvent(Container.java:2264)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4993)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
    at java.desktop/java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1950)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:875)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
    at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:11 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:11 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:11 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:13 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main

    at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
    at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
    at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
    at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
    at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
    at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
    at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
    at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
    at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
    at java.desktop/javax.swing.JComponent.processKeyBindings(JComponent.java:2985)
    at java.desktop/javax.swing.JComponent.processKeyEvent(JComponent.java:2862)
    at java.desktop/java.awt.Component.processEvent(Component.java:6394)
    at java.desktop/java.awt.Container.processEvent(Container.java:2264)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4993)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
    at java.desktop/java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1950)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:875)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
    at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:13 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:13 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:13 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:14 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main

    at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
    at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
    at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
    at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
    at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
    at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
    at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
    at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
    at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
    at java.desktop/javax.swing.JComponent.processKeyBindings(JComponent.java:2985)
    at java.desktop/javax.swing.JComponent.processKeyEvent(JComponent.java:2862)
    at java.desktop/java.awt.Component.processEvent(Component.java:6394)
    at java.desktop/java.awt.Container.processEvent(Container.java:2264)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4993)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
    at java.desktop/java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1950)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:875)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
    at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:14 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:14 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:14 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:15 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main

    at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
    at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
    at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
    at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
    at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
    at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
    at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
    at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
    at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
    at java.desktop/javax.swing.JComponent.processKeyBindings(JComponent.java:2985)
    at java.desktop/javax.swing.JComponent.processKeyEvent(JComponent.java:2862)
    at java.desktop/java.awt.Component.processEvent(Component.java:6394)
    at java.desktop/java.awt.Container.processEvent(Container.java:2264)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4993)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
    at java.desktop/java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1950)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:875)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
    at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:15 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:15 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:15 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
2024-09-14 23:41:20.770 java[48455:2786603] Apple AWT Internal Exception: java.lang.NullPointerException
Sep 14, 2024 11:41:22 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main

    at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
    at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
    at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
    at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
    at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
    at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
    at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
    at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
    at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
    at java.desktop/javax.swing.SwingUtilities.processKeyBindings(SwingUtilities.java:1730)
    at java.desktop/javax.swing.UIManager$2.postProcessKeyEvent(UIManager.java:1544)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:886)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
    at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:22 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:22 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:22 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:24 PM com.timestored.qstudio.CommonActions sendQuery
WARNING: Send Query Error
java.io.IOException: Non-zero exit value for runArgs:[E0001] Error: Missing main pipeline
↳ Hint: Expected a declaration at main

    at com.timestored.qstudio.CommonActions.compilePRQL(CommonActions.java:630)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:580)
    at com.timestored.qstudio.CommonActions.sendQuery(CommonActions.java:548)
    at com.timestored.qstudio.CommonActions.access$000(CommonActions.java:99)
    at com.timestored.qstudio.CommonActions$1.actionPerformed(CommonActions.java:174)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:354)
    at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:977)
    at java.desktop/javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1809)
    at java.desktop/javax.swing.JComponent.processKeyBinding(JComponent.java:2900)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:704)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:711)
    at java.desktop/javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:682)
    at java.desktop/javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:311)
    at java.desktop/javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:297)
    at java.desktop/javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2993)
    at java.desktop/javax.swing.SwingUtilities.processKeyBindings(SwingUtilities.java:1730)
    at java.desktop/javax.swing.UIManager$2.postProcessKeyEvent(UIManager.java:1544)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:886)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1144)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:1014)
    at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:840)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4874)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2322)
    at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2773)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4825)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Sep 14, 2024 11:41:24 PM com.timestored.jgrowl.FadingGrowler show
SEVERE: Error: Problem sending query to server
Sep 14, 2024 11:41:24 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=prql target:sql.sqlite
, wasResult=false, wasException=true}
Sep 14, 2024 11:41:24 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:26 PM com.timestored.docs.BackgroundDocumentsSaver requestSave
INFO: store currently open documents to scratch.
Sep 14, 2024 11:41:26 PM com.timestored.docs.BackgroundDocumentsSaver saveDocumentsScratch
INFO: Saving docs to scratch
Sep 14, 2024 11:41:34 PM com.timestored.qstudio.CommonActions sendQuery
INFO: Send Query->WITH table_1 AS (
  SELECT
    "SD_CollectedOn",
    "SD_Version",
    "SD_App_TotPrev",
    "SD_App_LandPrev",
    "SD_App_ImpPrev",
    "SD_App_TotCurr",
    "SD_App_LandCurr",
    "SD_App_ImpCurr",
    "SD_Ass_TotPrev",
    "SD_Ass_LandPrev",
    "SD_Ass_ImpPrev",
    "SD_Ass_TotCurr",
    "SD_Ass_LandCurr",
    "SD_Ass_ImpCurr",
    "SD_Prev_Sale_Date",
    "SD_Prev_Sale_Price",
    "SD_Recent_Sale_Date",
    "SD_Recent_Sale_Price",
    "SD_Num_Buildings",
    "SD_Description",
    "SD_Land_Use_Code",
    "SD_Lot_Size",
    "SD_Appraisal",
    "SD_Assessment",
    "SD_Page",
    "SD_Book",
    "SD_Book_Page",
    "SD_Subunit",
    "SD_Unit",
    "SD_Lot",
    "SD_Map",
    "SD_MBLU",
    "SD_Street_Address",
    "SD_Owner",
    "SD_PID",
    "SD_Zoning_District"
  FROM
    "ScrapedData" AS sd
  WHERE
    "SD_CollectedOn" = '2024-07-15'
),
table_0 AS (
  SELECT
    CASE
      WHEN table_1."SD_Street_Address" like '%' || 'ORFORD ' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DARTMOUTH COLLEGE' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DORCHESTER' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'THETFORD' || '%' THEN 1
      ELSE 0
    END AS "StateRoad",
    ef."EF_LotSize",
    ef."EF_Exempt",
    ef."EF_MuniEasement",
    ef."EF_ConsEasement",
    ef."EF_Frontage",
    ef."EF_FrontSuffix",
    table_1."SD_CollectedOn",
    table_1."SD_Version",
    table_1."SD_App_TotPrev",
    table_1."SD_App_LandPrev",
    table_1."SD_App_ImpPrev",
    table_1."SD_App_TotCurr",
    table_1."SD_App_LandCurr",
    table_1."SD_App_ImpCurr",
    table_1."SD_Ass_TotPrev",
    table_1."SD_Ass_LandPrev",
    table_1."SD_Ass_ImpPrev",
    table_1."SD_Ass_TotCurr",
    table_1."SD_Ass_LandCurr",
    table_1."SD_Ass_ImpCurr",
    table_1."SD_Prev_Sale_Date",
    table_1."SD_Prev_Sale_Price",
    table_1."SD_Recent_Sale_Date",
    table_1."SD_Recent_Sale_Price",
    table_1."SD_Num_Buildings",
    table_1."SD_Description",
    table_1."SD_Land_Use_Code",
    table_1."SD_Lot_Size",
    table_1."SD_Appraisal",
    table_1."SD_Assessment",
    table_1."SD_Page",
    table_1."SD_Book",
    table_1."SD_Book_Page",
    table_1."SD_Subunit",
    table_1."SD_Unit",
    table_1."SD_Lot",
    table_1."SD_Map",
    table_1."SD_MBLU",
    table_1."SD_Street_Address",
    table_1."SD_Owner",
    table_1."SD_PID",
    CASE
      WHEN table_1."SD_Zoning_District" = 'ES' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'R' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SFR' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'URD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'LCD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'CD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'LDC' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = '' THEN NULL
      ELSE table_1."SD_Zoning_District"
    END AS _expr_0,
    czd."CZD_Actual",
    table_1."SD_Zoning_District"
  FROM
    table_1
    LEFT JOIN "CorrectedZoningDistrict" AS czd ON table_1."SD_PID" = czd."CZD_PID"
    LEFT JOIN "EasementsFrontage" AS ef ON table_1."SD_PID" = ef."EF_PID"
)
SELECT
  "SD_PID" AS "PID",
  "SD_Owner" AS "Owner",
  "SD_Street_Address" AS "Street_Address",
  "SD_MBLU" AS "MBLU",
  "SD_Map" AS "Map",
  "SD_Lot" AS "Lot",
  "SD_Unit" AS "Unit",
  "SD_Subunit" AS "Subunit",
  "SD_Book_Page" AS "Book_Page",
  "SD_Book" AS "Book",
  "SD_Page" AS "Page",
  "SD_Assessment" AS "Assessment",
  "SD_Appraisal" AS "Appraisal",
  "SD_Lot_Size" AS "Lot_Size",
  "SD_Land_Use_Code" AS "Land_Use_Code",
  "SD_Description" AS "Description",
  COALESCE(_expr_0, "CZD_Actual") AS "District",
  CASE
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 1 THEN 'Rural-State Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 0 THEN 'Rural-Town Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'BD' THEN 'Commercial'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'LCD' THEN 'LymeCommon/Ctr'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'ELD' THEN 'EastLyme'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'SKIWAY' THEN 'Skiway'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'MFD' THEN 'MtnForest'
    ELSE COALESCE(_expr_0, "CZD_Actual")
  END AS "DistrictName",
  "StateRoad",
  "EF_LotSize",
  "EF_Exempt",
  "EF_MuniEasement",
  "EF_ConsEasement",
  "EF_Frontage",
  "EF_FrontSuffix",
  "SD_Num_Buildings" AS "Num_Buildings",
  "SD_Recent_Sale_Price" AS "Recent_Sale_Price",
  "SD_Recent_Sale_Date" AS "Recent_Sale_Date",
  "SD_Prev_Sale_Price" AS "Prev_Sale_Price",
  "SD_Prev_Sale_Date" AS "Prev_Sale_Date",
  "SD_Ass_ImpCurr" AS "Ass_ImpCurr",
  "SD_Ass_LandCurr" AS "Ass_LandCurr",
  "SD_Ass_TotCurr" AS "Ass_TotCurr",
  "SD_Ass_ImpPrev" AS "Ass_ImpPrev",
  "SD_Ass_LandPrev" AS "Ass_LandPrev",
  "SD_Ass_TotPrev" AS "Ass_TotPrev",
  "SD_App_ImpCurr" AS "App_ImpCurr",
  "SD_App_LandCurr" AS "App_LandCurr",
  "SD_App_TotCurr" AS "App_TotCurr",
  "SD_App_ImpPrev" AS "App_ImpPrev",
  "SD_App_LandPrev" AS "App_LandPrev",
  "SD_App_TotPrev" AS "App_TotPrev",
  "SD_Version" AS "Version",
  "SD_CollectedOn" AS "CollectedOn"
FROM
  table_0
ORDER BY
  "PID"

Sep 14, 2024 11:41:34 PM com.timestored.qstudio.model.QueryManager sendQuery
INFO: run() sendingQuery: WITH table_1 AS (
  SELECT
    "SD_CollectedOn",
    "SD_Version",
    "SD_App_TotPrev",
    "SD_App_LandPrev",
    "SD_App_ImpPrev",
    "SD_App_TotCurr",
    "SD_App_LandCurr",
    "SD_App_ImpCurr",
    "SD_Ass_TotPrev",
    "SD_Ass_LandPrev",
    "SD_Ass_ImpPrev",
    "SD_Ass_TotCurr",
    "SD_Ass_LandCurr",
    "SD_Ass_ImpCurr",
    "SD_Prev_Sale_Date",
    "SD_Prev_Sale_Price",
    "SD_Recent_Sale_Date",
    "SD_Recent_Sale_Price",
    "SD_Num_Buildings",
    "SD_Description",
    "SD_Land_Use_Code",
    "SD_Lot_Size",
    "SD_Appraisal",
    "SD_Assessment",
    "SD_Page",
    "SD_Book",
    "SD_Book_Page",
    "SD_Subunit",
    "SD_Unit",
    "SD_Lot",
    "SD_Map",
    "SD_MBLU",
    "SD_Street_Address",
    "SD_Owner",
    "SD_PID",
    "SD_Zoning_District"
  FROM
    "ScrapedData" AS sd
  WHERE
    "SD_CollectedOn" = '2024-07-15'
),
table_0 AS (
  SELECT
    CASE
      WHEN table_1."SD_Street_Address" like '%' || 'ORFORD ' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DARTMOUTH COLLEGE' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DORCHESTER' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'THETFORD' || '%' THEN 1
      ELSE 0
    END AS "StateRoad",
    ef."EF_LotSize",
    ef."EF_Exempt",
    ef."EF_MuniEasement",
    ef."EF_ConsEasement",
    ef."EF_Frontage",
    ef."EF_FrontSuffix",
    table_1."SD_CollectedOn",
    table_1."SD_Version",
    table_1."SD_App_TotPrev",
    table_1."SD_App_LandPrev",
    table_1."SD_App_ImpPrev",
    table_1."SD_App_TotCurr",
    table_1."SD_App_LandCurr",
    table_1."SD_App_ImpCurr",
    table_1."SD_Ass_TotPrev",
    table_1."SD_Ass_LandPrev",
    table_1."SD_Ass_ImpPrev",
    table_1."SD_Ass_TotCurr",
    table_1."SD_Ass_LandCurr",
    table_1."SD_Ass_ImpCurr",
    table_1."SD_Prev_Sale_Date",
    table_1."SD_Prev_Sale_Price",
    table_1."SD_Recent_Sale_Date",
    table_1."SD_Recent_Sale_Price",
    table_1."SD_Num_Buildings",
    table_1."SD_Description",
    table_1."SD_Land_Use_Code",
    table_1."SD_Lot_Size",
    table_1."SD_Appraisal",
    table_1."SD_Assessment",
    table_1."SD_Page",
    table_1."SD_Book",
    table_1."SD_Book_Page",
    table_1."SD_Subunit",
    table_1."SD_Unit",
    table_1."SD_Lot",
    table_1."SD_Map",
    table_1."SD_MBLU",
    table_1."SD_Street_Address",
    table_1."SD_Owner",
    table_1."SD_PID",
    CASE
      WHEN table_1."SD_Zoning_District" = 'ES' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'R' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SFR' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'URD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'LCD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'CD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'LDC' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = '' THEN NULL
      ELSE table_1."SD_Zoning_District"
    END AS _expr_0,
    czd."CZD_Actual",
    table_1."SD_Zoning_District"
  FROM
    table_1
    LEFT JOIN "CorrectedZoningDistrict" AS czd ON table_1."SD_PID" = czd."CZD_PID"
    LEFT JOIN "EasementsFrontage" AS ef ON table_1."SD_PID" = ef."EF_PID"
)
SELECT
  "SD_PID" AS "PID",
  "SD_Owner" AS "Owner",
  "SD_Street_Address" AS "Street_Address",
  "SD_MBLU" AS "MBLU",
  "SD_Map" AS "Map",
  "SD_Lot" AS "Lot",
  "SD_Unit" AS "Unit",
  "SD_Subunit" AS "Subunit",
  "SD_Book_Page" AS "Book_Page",
  "SD_Book" AS "Book",
  "SD_Page" AS "Page",
  "SD_Assessment" AS "Assessment",
  "SD_Appraisal" AS "Appraisal",
  "SD_Lot_Size" AS "Lot_Size",
  "SD_Land_Use_Code" AS "Land_Use_Code",
  "SD_Description" AS "Description",
  COALESCE(_expr_0, "CZD_Actual") AS "District",
  CASE
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 1 THEN 'Rural-State Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 0 THEN 'Rural-Town Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'BD' THEN 'Commercial'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'LCD' THEN 'LymeCommon/Ctr'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'ELD' THEN 'EastLyme'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'SKIWAY' THEN 'Skiway'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'MFD' THEN 'MtnForest'
    ELSE COALESCE(_expr_0, "CZD_Actual")
  END AS "DistrictName",
  "StateRoad",
  "EF_LotSize",
  "EF_Exempt",
  "EF_MuniEasement",
  "EF_ConsEasement",
  "EF_Frontage",
  "EF_FrontSuffix",
  "SD_Num_Buildings" AS "Num_Buildings",
  "SD_Recent_Sale_Price" AS "Recent_Sale_Price",
  "SD_Recent_Sale_Date" AS "Recent_Sale_Date",
  "SD_Prev_Sale_Price" AS "Prev_Sale_Price",
  "SD_Prev_Sale_Date" AS "Prev_Sale_Date",
  "SD_Ass_ImpCurr" AS "Ass_ImpCurr",
  "SD_Ass_LandCurr" AS "Ass_LandCurr",
  "SD_Ass_TotCurr" AS "Ass_TotCurr",
  "SD_Ass_ImpPrev" AS "Ass_ImpPrev",
  "SD_Ass_LandPrev" AS "Ass_LandPrev",
  "SD_Ass_TotPrev" AS "Ass_TotPrev",
  "SD_App_ImpCurr" AS "App_ImpCurr",
  "SD_App_LandCurr" AS "App_LandCurr",
  "SD_App_TotCurr" AS "App_TotCurr",
  "SD_App_ImpPrev" AS "App_ImpPrev",
  "SD_App_LandPrev" AS "App_LandPrev",
  "SD_App_TotPrev" AS "App_TotPrev",
  "SD_Version" AS "Version",
  "SD_CollectedOn" AS "CollectedOn"
FROM
  table_0
ORDER BY
  "PID"

Sep 14, 2024 11:41:34 PM com.timestored.qstudio.model.QueryManager sendQRtoListeners
INFO: queryResultReturned: QueryResult{query=WITH table_1 AS (
  SELECT
    "SD_CollectedOn",
    "SD_Version",
    "SD_App_TotPrev",
    "SD_App_LandPrev",
    "SD_App_ImpPrev",
    "SD_App_TotCurr",
    "SD_App_LandCurr",
    "SD_App_ImpCurr",
    "SD_Ass_TotPrev",
    "SD_Ass_LandPrev",
    "SD_Ass_ImpPrev",
    "SD_Ass_TotCurr",
    "SD_Ass_LandCurr",
    "SD_Ass_ImpCurr",
    "SD_Prev_Sale_Date",
    "SD_Prev_Sale_Price",
    "SD_Recent_Sale_Date",
    "SD_Recent_Sale_Price",
    "SD_Num_Buildings",
    "SD_Description",
    "SD_Land_Use_Code",
    "SD_Lot_Size",
    "SD_Appraisal",
    "SD_Assessment",
    "SD_Page",
    "SD_Book",
    "SD_Book_Page",
    "SD_Subunit",
    "SD_Unit",
    "SD_Lot",
    "SD_Map",
    "SD_MBLU",
    "SD_Street_Address",
    "SD_Owner",
    "SD_PID",
    "SD_Zoning_District"
  FROM
    "ScrapedData" AS sd
  WHERE
    "SD_CollectedOn" = '2024-07-15'
),
table_0 AS (
  SELECT
    CASE
      WHEN table_1."SD_Street_Address" like '%' || 'ORFORD ' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DARTMOUTH COLLEGE' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'DORCHESTER' || '%' THEN 1
      WHEN table_1."SD_Street_Address" like '%' || 'THETFORD' || '%' THEN 1
      ELSE 0
    END AS "StateRoad",
    ef."EF_LotSize",
    ef."EF_Exempt",
    ef."EF_MuniEasement",
    ef."EF_ConsEasement",
    ef."EF_Frontage",
    ef."EF_FrontSuffix",
    table_1."SD_CollectedOn",
    table_1."SD_Version",
    table_1."SD_App_TotPrev",
    table_1."SD_App_LandPrev",
    table_1."SD_App_ImpPrev",
    table_1."SD_App_TotCurr",
    table_1."SD_App_LandCurr",
    table_1."SD_App_ImpCurr",
    table_1."SD_Ass_TotPrev",
    table_1."SD_Ass_LandPrev",
    table_1."SD_Ass_ImpPrev",
    table_1."SD_Ass_TotCurr",
    table_1."SD_Ass_LandCurr",
    table_1."SD_Ass_ImpCurr",
    table_1."SD_Prev_Sale_Date",
    table_1."SD_Prev_Sale_Price",
    table_1."SD_Recent_Sale_Date",
    table_1."SD_Recent_Sale_Price",
    table_1."SD_Num_Buildings",
    table_1."SD_Description",
    table_1."SD_Land_Use_Code",
    table_1."SD_Lot_Size",
    table_1."SD_Appraisal",
    table_1."SD_Assessment",
    table_1."SD_Page",
    table_1."SD_Book",
    table_1."SD_Book_Page",
    table_1."SD_Subunit",
    table_1."SD_Unit",
    table_1."SD_Lot",
    table_1."SD_Map",
    table_1."SD_MBLU",
    table_1."SD_Street_Address",
    table_1."SD_Owner",
    table_1."SD_PID",
    CASE
      WHEN table_1."SD_Zoning_District" = 'ES' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'R' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SFR' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'URD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'SD' THEN 'RD'
      WHEN table_1."SD_Zoning_District" = 'LCD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'CD' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = 'LDC' THEN 'LCD'
      WHEN table_1."SD_Zoning_District" = '' THEN NULL
      ELSE table_1."SD_Zoning_District"
    END AS _expr_0,
    czd."CZD_Actual",
    table_1."SD_Zoning_District"
  FROM
    table_1
    LEFT JOIN "CorrectedZoningDistrict" AS czd ON table_1."SD_PID" = czd."CZD_PID"
    LEFT JOIN "EasementsFrontage" AS ef ON table_1."SD_PID" = ef."EF_PID"
)
SELECT
  "SD_PID" AS "PID",
  "SD_Owner" AS "Owner",
  "SD_Street_Address" AS "Street_Address",
  "SD_MBLU" AS "MBLU",
  "SD_Map" AS "Map",
  "SD_Lot" AS "Lot",
  "SD_Unit" AS "Unit",
  "SD_Subunit" AS "Subunit",
  "SD_Book_Page" AS "Book_Page",
  "SD_Book" AS "Book",
  "SD_Page" AS "Page",
  "SD_Assessment" AS "Assessment",
  "SD_Appraisal" AS "Appraisal",
  "SD_Lot_Size" AS "Lot_Size",
  "SD_Land_Use_Code" AS "Land_Use_Code",
  "SD_Description" AS "Description",
  COALESCE(_expr_0, "CZD_Actual") AS "District",
  CASE
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 1 THEN 'Rural-State Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'RD'
    AND "StateRoad" = 0 THEN 'Rural-Town Road'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'BD' THEN 'Commercial'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'LCD' THEN 'LymeCommon/Ctr'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'ELD' THEN 'EastLyme'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'SKIWAY' THEN 'Skiway'
    WHEN COALESCE(_expr_0, "CZD_Actual") = 'MFD' THEN 'MtnForest'
    ELSE COALESCE(_expr_0, "CZD_Actual")
  END AS "DistrictName",
  "StateRoad",
  "EF_LotSize",
  "EF_Exempt",
  "EF_MuniEasement",
  "EF_ConsEasement",
  "EF_Frontage",
  "EF_FrontSuffix",
  "SD_Num_Buildings" AS "Num_Buildings",
  "SD_Recent_Sale_Price" AS "Recent_Sale_Price",
  "SD_Recent_Sale_Date" AS "Recent_Sale_Date",
  "SD_Prev_Sale_Price" AS "Prev_Sale_Price",
  "SD_Prev_Sale_Date" AS "Prev_Sale_Date",
  "SD_Ass_ImpCurr" AS "Ass_ImpCurr",
  "SD_Ass_LandCurr" AS "Ass_LandCurr",
  "SD_Ass_TotCurr" AS "Ass_TotCurr",
  "SD_Ass_ImpPrev" AS "Ass_ImpPrev",
  "SD_Ass_LandPrev" AS "Ass_LandPrev",
  "SD_Ass_TotPrev" AS "Ass_TotPrev",
  "SD_App_ImpCurr" AS "App_ImpCurr",
  "SD_App_LandCurr" AS "App_LandCurr",
  "SD_App_TotCurr" AS "App_TotCurr",
  "SD_App_ImpPrev" AS "App_ImpPrev",
  "SD_App_LandPrev" AS "App_LandPrev",
  "SD_App_TotPrev" AS "App_TotPrev",
  "SD_Version" AS "Version",
  "SD_CollectedOn" AS "CollectedOn"
FROM
  table_0
ORDER BY
  "PID"
, wasResult=false, wasException=false}
Sep 14, 2024 11:41:35 PM com.timestored.sqldash.model.AbstractWidget configChanged
INFO: Widget 0 configChanged
Sep 14, 2024 11:41:35 PM com.timestored.sqldash.chart.JdbcChartPanel update
INFO: could not create chartResultSet
java.sql.SQLException: getDouble failed on value (  ) in column 10
    at java.sql.rowset/com.sun.rowset.CachedRowSetImpl.getDouble(CachedRowSetImpl.java:2026)
    at com.timestored.sqldash.chart.ChartResultSetBuilder.getDoubles(ChartResultSetBuilder.java:145)
    at com.timestored.sqldash.chart.ChartResultSetBuilder.getChartResultSet(ChartResultSetBuilder.java:94)
    at com.timestored.sqldash.chart.ChartResultSet.getInstance(ChartResultSet.java:58)
    at com.timestored.sqldash.chart.JdbcChartPanel.update(JdbcChartPanel.java:208)
    at com.timestored.sqldash.model.ChartWidget.tabChanged(ChartWidget.java:187)
    at com.timestored.qstudio.ChartResultPanel$1.queryResultReturned(ChartResultPanel.java:106)
    at com.timestored.qstudio.model.QueryManager.sendQRtoListeners(QueryManager.java:366)
    at com.timestored.qstudio.model.QueryManager.sendQuery(QueryManager.java:247)
    at com.timestored.qstudio.model.QueryManager.access$200(QueryManager.java:56)
    at com.timestored.qstudio.model.QueryManager$2.run(QueryManager.java:188)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
    at java.base/java.lang.Thread.run(Thread.java:831)
ryanhamilton commented 1 month ago

When you comment, then uncomment it leaves an area of text highlighted. So when you press control+E it is then running an empty or bad query. I think that's what's happening here.

I can recreate the error when I query an empty string.

richb-hanover commented 1 month ago

Good sleuthing!

I'm glad I mentioned the bit about using Cmd-/. I was only doing this to ensure that I was using 3.10. But of course, I now see that qStudio only sends the single commented-out line.

I am now groping for a solution - I don't think this is anything qStudio could (reasonably) address, so I will submit a request over at PRQL.

PS @ryanhamilton Could I ask a favor? You posted two issues on PRQL, both of which have been addressed. Would you close them? Many thanks. https://github.com/PRQL/prql/issues/4540 and https://github.com/PRQL/prql/issues/4502

richb-hanover commented 1 month ago

I changed my mind. I made a proposal at #90 that qStudio could implement. Thanks