docs icon indicating copy to clipboard operation
docs copied to clipboard

fix: Corrected surrealql statement.

Open ishaan26 opened this issue 6 months ago โ€ข 1 comments

DEFINE LOGIN is incorrect. It should be DEFINE USER

ishaan26 avatar Jun 21 '25 16:06 ishaan26

Deploy Preview for nostalgic-ptolemy-b01ab8 ready!

Name Link
Latest commit d53e435ccfee44ddf5e2e7515282b9f9ec4d0545
Latest deploy log https://app.netlify.com/projects/nostalgic-ptolemy-b01ab8/deploys/6856df31ab38f40008f3cc04
Deploy Preview https://deploy-preview-7291--nostalgic-ptolemy-b01ab8.netlify.app
Preview on mobile
Toggle QR Code...

QR Code

Use your smartphone camera to open QR code link.

To edit notification comments on pull requests, go to your Netlify project configuration.

netlify[bot] avatar Jun 21 '25 16:06 netlify[bot]

Thank you for the PR. Tested and validated the steps.

rajie@surreal:~$ surreal sql --conn http://localhost:8000 --user root --pass exampleRootPass --ns application --db todo --pretty
1 | DEFINE LOGIN exampleUser ON DATABASE PASSWORD 'examplePass';
# |        ^^^^^ 
#  Welcome to the SurrealDB SQL shell
#
#  How to use this shell:
#    - Different statements within a query should be separated by a (;) semicolon.
#    - To create a multi-line query, end your lines with a (\) backslash, and press enter.
#    - To exit, send a SIGTERM or press CTRL+C
#
#  Consult https://surrealdb.com/docs/cli/sql for further instructions
#
#  SurrealDB version: 2.3.6
#
		
application/todo> DEFINE USER exampleUser ON DATABASE PASSWORD 'examplePass';
-- Query 1 (execution time: 739.352ยตs)
NONE

application/todo> DEFINE LOGIN exampleUser ON DATABASE PASSWORD 'examplePass'; --< Parse error: Unexpected token `an identifier`, expected a define statement keyword
 --> [1:8]
  |
1 | DEFINE LOGIN exampleUser ON DATABASE PASSWORD 'examplePass';
  |        ^^^^^ 

Rajakavitha1 avatar Jun 29 '25 13:06 Rajakavitha1