AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AugSQL
AugSQL
Query spins and spi...
 
Notifications
Clear all

Bug - Resolved Query spins and spins and spins

 
Votes Received: 1

AugSQL
Last Post by Tim Rodman 2 years ago
0 Posts
1 Users
1 Reactions
71 Views
RSS
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
Topic starter
June 26, 2023 11:19 pm
(@timrodman)
Famed Member
Joined: 10 years ago

This was a problem in version 0.4.0, but it's no longer a problem in version 0.6.0; all of the queries below now work in version 0.6.0.

Still though, I'm documenting it here in case it happens again.

 

This query runs:

SELECT *
FROM sys.procedures

 

This query runs:

SELECT TOP 10 *
FROM sys.procedures

This query runs:

SELECT TOP 10 *
FROM sys.procedures
WHERE name LIKE 'sp%'

But this query spins and spins and spins:

SELECT *
FROM sys.procedures
WHERE name LIKE 'sp%'
AugSQL Developer reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,521 Topics
  • 10.9 K Posts
  • 25 Online
  • 2,321 Members
Our newest member: Courtney Wilder
Latest Post: Can UDFs be populated using an Import Scenario?
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×