Bill Linder

Created July 27, 2021 15:13

Also.  Just upgraded DataGrip to the new release.  That did not fix it.

1. Community
2. DataGrip
3. "Unable to resolve column" in DataGrip wrt MySql statement for "Select fields into variable from table where conditions"

• 1 vote

Created July 28, 2021 15:44

Thank you Vasily!

1. Community
2. DataGrip
3. "Unable to resolve column" in DataGrip wrt MySql statement for "Select fields into variable from table where conditions"

• 0 votes

Created July 27, 2021 14:59

Had an idea:  What if I use a table alias?  And it worked. Now, why?  lol

1. Community
2. DataGrip
3. "Unable to resolve column" in DataGrip wrt MySql statement for "Select fields into variable from table where conditions"

• 0 votes

Created July 27, 2021 14:50

Here is the scrubbed up (had to remove certain comments) version of the stored procedure in question as well: CREATE PROCEDURE `cart_remove_2`( thisSessionID BIGINT,userid VARCHAR(8),cartid VARCHAR...

1. Community
2. DataGrip
3. "Unable to resolve column" in DataGrip wrt MySql statement for "Select fields into variable from table where conditions"

• 0 votes

Created July 27, 2021 13:51

Thank you for helping me with this.   The DDL for the containers table from DataGrip, minus comments due to company rules: create table containers(idx bigint unsigned auto_incrementprimary key,cont...

1. Community
2. DataGrip
3. "Unable to resolve column" in DataGrip wrt MySql statement for "Select fields into variable from table where conditions"

• 0 votes

Created July 22, 2021 16:33

Version for DataGrip is: DataGrip 2021.1.3Build #DB-211.7442.53, built on June 7, 2021Licensed to Bill LinderYou have a perpetual fallback license for this version.Subscription is active until June...

1. Community
2. DataGrip
3. "Unable to resolve column" in DataGrip wrt MySql statement for "Select fields into variable from table where conditions"

• 0 votes